excel-streaming-reader
excel-streaming-reader copied to clipboard
xlsx files with date1904 interpreted as 1900 dates.
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.)