| Summary: | Overwriting is not working as expected | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Florian Reisinger <reisi007> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | CLOSED WONTFIX | ||
| Severity: | blocker | CC: | erack, jbfaure |
| Priority: | medium | ||
| Version: | 3.5.0 RC1 | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | See description... | ||
I think it is not a bug: when you type 3/10 the first time, Calc interprets that as a date and modifies the cell format in date format. When you overwrite the contents of the cell by th formula =3/10 you have still a date, but now you have a number of day since 30/12/1899. So you get the date 30/12/1899. Eike: can you confirm my diagnosis? Best regards. JBF True, the once applied date format persists if a formula is entered and displays the result (taken as serial date number) as date. First hand the confusion arises because 3/10 is accepted as date in a de-DE locale, this behavior is changed in master (to become LibO 3.6) with locale dependent date accpetance patterns, see bug 44636. And by no means this would had been a blocker bug ... closing. |
Created attachment 55900 [details] See description... 1) Open a new Calc document 2) In cell any cell a fractin ( 3/10 ....) 3) With 3/10 it displays 03.10.12 (German DD.MM.YY) 4) Now overwrite this cell with the same fracten as in 2), but with a "=" before ( =3/10 ) overwrite...Click once on a cell and start typing 5) 30.12.99 is displayed Please refer to the screenshot Windows 7 x64 LibO 3.5RC1