Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Rounding issue in XLSX date cells
<sheetData>
<row r="1" customFormat="false" ht="12.8" hidden="false" customHeight="false" outlineLevel="0" collapsed="false">
<c r="A1" s="1" t="n">
<v>41552</v>
</c>
</row>
<row r="2" customFormat="false" ht="12.8" hidden="false" customHeight="false" outlineLevel="0" collapsed="false">
<c r="A2" s="1" t="n">
<v>41551.9999999998</v>
</c>
</row>
</sheetData>
@duncan-bayne

This comment has been minimized.

Copy link
Owner Author

@duncan-bayne duncan-bayne commented Sep 3, 2015

If you extract the above XLSX with xlsx2csv, one date comes out as midnight, the other 23:59:59:

$ xlsx2csv test.xlsx
05/10/2013 00:00:00
04/10/2013 23:59:59

... and yet they both display as 05/10/2013 00:00:00 in the spreadsheet.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment