Calc: Default Formatting ruins dates

[dotancohen]

Binary package hint: openoffice.org-calc

When a date is entered into a Calc cell and then Default Formatting is selected, the date turns into an integer. For example, entering "2008-7-7" and then selecting Default Formating causes the cell to display "39636".

It would be nice if Calc just showed the data as it was entered. If the user enters "03102008" and Calc reformats it to "2008-10-03", then the user clicks Default Formating, then Calc should show "03102008" and not "39874".

[Chris Cheney (ccheney)]

Typing "2009-06-29" into calc for me in English (USA) causes it to show the date properly. Were you entering the date in the format for your locale?

[dotancohen (dotancohen)]

Chris, after entering the date right-click on the cell and choose "default formating". Now what does the cell show?

[Chris Cheney (ccheney)]

Confirmed on official OOo 3.1

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[penalvch (penalvch)]

No reference URL.

[penalvch (penalvch)]

dotancohen, this is:
- a clearcut upstream issue. Your welcome to send this to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status.
- won't be fixed in LibreOffice Packaging
Resolving as Won't Fix in LibreOffice Packaging. This does not mean the issue will not be cared about, but if it is cared about (even by Ubuntu/Canonical contributors), it is done upstream at LibreOffice.

libreoffice (Ubuntu) => Won't Fix Wishlist