Ask Your Question

revolver's profile - activity

2014-10-21 13:08:02 +0200 received badge  Famous Question (source)
2014-09-17 17:00:35 +0200 received badge  Notable Question (source)
2014-09-17 15:16:07 +0200 received badge  Popular Question (source)
2014-09-17 14:48:26 +0200 commented answer Incorrect date display in calc for xls files

I know it's the null value, It shouldn't be the null value. Openning it with Microsoft Office shows all the dates just fine. As for the file, Here it is on another file sharing file: here

2014-09-17 13:35:41 +0200 received badge  Editor (source)
2014-09-17 13:34:58 +0200 asked a question Incorrect date display in calc for xls files

Whenever I open my financial reports in libre calc the date fields are all displayed as: 31/12/1899 00:00:00. Microsoft Office displays all the dates in the file correctly.

image description

I uploaded the file (with the irrelevant info omitted): link text

EDIT: Apparently, libre calc resets all the dates to null values when it reads the file. I took another xls file and made sure the dates were all valid then used MS Office to save it as an xlsx. Openning the xls file with LO calc resets the date values. To my surprise, openning the xlsx files worked, the dates didn't reset. Here's the xls file for your viewing pleasure (watch how the dates are valid before openning the file). It's a bug in calc's xls support, I should just add it to LO's bug tracker, Right?