search

tafia / calamine

A pure Rust Excel/OpenDocument SpreadSheets file reader: rust on metal sheets
MIT License
1.61k stars 155 forks source link

fix incorrect date parsing caused by excel date bug #328

Closed Geo-W closed 1 year ago

Geo-W commented 1 year ago

Date earlier than 1900-03-01 will be parsed 1 day earlier, which is caused by excel incorrectly recognizing 1900 as leap year.

e.g. 1900-01-05 => Some(1900-01-04T00:00:00)

both 1900-02-28 and 1900-02-29 will be parsed as Some(1900-02-28T00:00:00) after fix.

tafia commented 1 year ago

Thanks