excel-streaming-reader icon indicating copy to clipboard operation
excel-streaming-reader copied to clipboard

xlsx files with date1904 interpreted as 1900 dates.

Open oyvindwe opened this issue 5 years ago • 0 comments

Using LibreOffice on Linux, we created an xlsx file where the dates were off by 5 years and a day when parsing.

It turned out that the attriibute date1904 may be set to either 1 or true to indicate 1904-01-01 as base date, se e.g. https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.workbookproperties?view=openxml-2.8.1 which points to https://www.w3.org/TR/xmlschema-2/#boolean (I tried to look this up in Office Open spec, but it was rather hard to navigate.)

oyvindwe avatar Aug 28 '20 14:08 oyvindwe