View previous topic :: View next topic |
Author |
Message |
MatsWolpers Blue Pill
Joined: Aug 10, 2009 Posts: 2
|
Posted: Fri Mar 05, 2010 12:53 am Post subject: calc cell format |
|
this is in 3.0.2 patch 0
i have a column containing calendar dates in one sheet.
in another sheet i have a dropdown cell with assigned validity refering to that column of calendar dates.
when i drop the list to select my value of choice, i see integer numbers in the 42000 range instead of calendar date formated information. selecting is still possible and eventually leads to a formatted result, but not having the formatting available while selecting is a bit of a nuisance.
is this something i should address with the open office fellas?
thanks, mats |
|
Back to top |
|
|
yoxi Cipher
Joined: Sep 07, 2004 Posts: 1799 Location: Dawlish, Devon
|
Posted: Fri Mar 05, 2010 4:02 am Post subject: |
|
Is there not some way to apply a date format to your dropdown cell? |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Fri Mar 05, 2010 8:46 am Post subject: |
|
I cannot reproduce this when I create a listbox in a new spreadsheet and assign a range of date cells so can you provide a sample spreadsheet file that we can look at?
You can attach a sample file using the steps in this forum post.
Patrick |
|
Back to top |
|
|
MatsWolpers Blue Pill
Joined: Aug 10, 2009 Posts: 2
|
Posted: Fri Mar 05, 2010 12:59 pm Post subject: |
|
pluby wrote: | I cannot reproduce this
|
well created that file using NO2.cant.remember, maybe that makes a difference. sorry for not mentioning it 1st time round, it was before breakfast.
pluby wrote: |
so can you provide a sample spreadsheet file that we can look at?
|
i made a clone and changed all the data. on my machine, the effect is still there. ( the rest of my environment is os x 10.5.6, btw ). this file is attached.
oh, and i am now updated to 3.0.2 patch 1. same difference.
mats |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Fri Mar 05, 2010 5:00 pm Post subject: |
|
Thank you for the sample document. I can easily reproduce your problem when I select the date cell on the last sheet and click on the dropdown list icon next to the cell.
Unfortunately, the bad news is that this same problem occurs in OpenOffice.org 3.0.1 (the version that NeoOffice 3.0.2 is based on) as well as in OpenOffice.org 3.1.1 (the version that the next version of NeoOffice will be based on) so this is definitely a missing OpenOffice.org feature.
There is some good news. I found that this problem no longer occurs in OpenOffice.org 3.2 which was released last month. While our next release in April or May will be based on the older OpenOffice.org 3.1.1 code, we will likely upgrade NeoOffice to the OpenOffice.org 3.2 code in the second half of 2010.
In the meantime, if you find seeing the OpenOffice.org code's underlying date numbers in your Validity listboxes, a workaround is to download and install OpenOffice.org 3.2 and open your spreadsheets with this type of Validity listbox in OpenOffice.org 3.2.
Both NeoOffice and OpenOffice.org can coexist on the same machine although I recommend that you only run one or the other at the same time as both applications use lots of memory and running both at the same time may leave very little memory for other applications.
Patrick |
|
Back to top |
|
|
|