https://bz.apache.org/ooo/show_bug.cgi?id=126908
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Resolution|NOT_AN_ISSUE |--- Status|CLOSED |REOPENED Ever confirmed|0 |1 --- Comment #2 from orcmid <[email protected]> --- It does not make sense that one can enter a date and then a different date is shown for the cell. The input and output conversions should be symmetrical for dates, no matter what the origin date is. That is, the same origin day (e.g., 1899-12-30 or 1900-01-01) should apply in both directions, and any leap-year correction should also. If this is not changed while working on the sheet, there should be no input-output discrepancy. This smells like a bug. Also, having the defect appear in this particular range is very strange. If it is about the 1900 leap-year tweak, what happens with 29 February 1900 should be evident. Nicolay, 1. Are you working in .ods format or are you starting/saving-in a different format? 2. Under Tools > Options > OpenOffice Calc > Calculate which date origin is selected: 1899-12-30, 1900-01-01, or 1904-01-01? 3. What are the actual forms of the dates that you enter and that are then displayed. That is, do you use "14 July 1919" and see "13 July 1919" or are the actual entered and displayed values different than those. Be specific. 4. For one of the cells that shows the defect, when you select the cell and Format > Cells ... what is the Category and "Format code" for the cell? -- You are receiving this mail because: You are the assignee for the issue.
