This project has moved. For the latest updates, please go here.

1904 Date Format

Jan 24, 2012 at 7:32 PM

We are using your lovely ClosedXML library for a great time tracker; however, we have the ability to have negative times.  And, as per default, Excel uses the 1900 date format, which means NEGATIVE times, meaning time to be removed from the total time sheet, will not display correctly on the excel sheet.

The resolve within normal excel is to change the options from 1900 to 1904 Date format, so that it displays.

Is there a way, using this library, to change the created woorkbooks properties to the 1904 format?

Coordinator
Jan 25, 2012 at 5:11 AM

Pick up the latest source code. Implemented the property workbook.Use1904DateSystem

Coordinator
Jan 25, 2012 at 6:26 PM

Actually, don't pick it up. I need to think of how/if I'll convert dates automagically.