Red Hat Bugzilla – Bug 881523
xls2csv misinterprets the DATEMODE chunk
Last modified: 2015-04-13 16:51:24 EDT
Created attachment 653930 [details]
Patch to fix the problem
Description of problem:
When parsing an XLS file, xls2csv interprets the presence of DATEMODE to determine the epoch for date storage. The correct use of the DATEMODE chunk (when present) is to inspect the value and use that to determine the epoch for date storage.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Convert an XLS file produced with a recent version of MS Excel
2. Inspect the dates in the output CSV file
The dates are off by four years.
The dates are accurage.
Patch coming up!
Created attachment 653931 [details]
Patch for the specfile
Reference for my patch: https://www.openoffice.org/sc/excelfileformat.pdf
(see section 5.28 on page 154)
I am not really sure how to verify that patch.