https://bugs.freedesktop.org/show_bug.cgi?id=78294
Priority: medium
Bug ID: 78294
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FILEOPEN: Date off by 4 years if .ods is loaded with
1904 date being effective in settings
Severity: major
Classification: Unclassified
OS: All
Reporter: er...@redhat.com
Hardware: All
Status: NEW
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
1. create new spreadsheet document
2. make sure Tools->Options->Calc->Calculate Date is 1899-12-30
3. enter date 1977-11-11
4. save as 1899.ods
5. close document
6. create new spreadsheet document
7. set Tools->Options->Calc->Calculate Date to 1904-01-01
8. enter date 1977-11-11
9. save as 1904.ods
10. close document
11. open 1899.ods
12. see date is now 1973-11-10
13. don't forget to create a new spreadsheet document and set
Tools->Options->Calc->Calculate Date to 1899-12-30 again and save, otherwise
the setting persists for further documents..
14. the error of loading 1899.ods vanishes after having set and saved the value
1899-12-30 once
Explanation: 1899.ods does not contain a <table:null-date> value, which
according to ODF means to use the default 1899-12-30 null-date but apparently
we use the then in effect option settings' null-date (1904-01-01) instead in
this case, despite that the settings after having loaded the document says
1899-12-30. Note that 1904.ods does contain the null-date 1904-01-01 and things
work correctly regardless of the previous null-date set in Tools-Options.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
