Page 1 of 1
Wrong timestaps in XLSX files.
Posted: Tue Oct 29, 2013 8:04 am
by d3nton
Hello.
The 'Date' and the 'Date last saved' timestamps are always set to 1/1/2000 instead of the correct value.
Please take a look at this picture:
http://www.file-upload.net/download-823 ... t.png.html.
Could you please fix this.
Thank you.
Re: Wrong timestaps in XLSX files.
Posted: Fri Nov 08, 2013 12:11 pm
by larsa
Hello
Will be fixed in update 5.20.07, ready by the beginning of next week. See release notes for details.
Re: Wrong timestaps in XLSX files.
Posted: Tue Nov 26, 2013 7:42 am
by d3nton
Thank you very much for your good support and the quick fix!
Re: Wrong timestaps in XLSX files.
Posted: Fri Feb 28, 2014 9:42 am
by d3nton
Hello.
I seems that there is still a small bug in V5.20.18
In my timezone (UTC +1:00) the 'Date last saved' is currently 1 hour ahead.
E.g. instead of 9:00 (the current time) it is 10:00. Other Dates like creation date or modified date are correct.
Re: Wrong timestaps in XLSX files.
Posted: Fri Feb 28, 2014 10:06 am
by d3nton
Microsoft is really inconsistent in saving date values in the docprops such as 'created' and 'modified' dates.
I found out that the 'modified' date is saved in UTC whereas other time values like 'created' are saved as local time.
A fix can be implemented in XC12Manager5.pas. You can use the SystemTime for the DateModified docprop:
Code: Select all
procedure TXc12Manager.BeforeWrite;
var
YY,MM,DD: word;
UTC: SystemTime;
begin
FStyleSheet.BeforeWrite;
FGrManager.BeforeWrite;
if FDocProps.AutoUpdate then begin
DecodeDate(FDocProps.DateCreated,YY,MM,DD);
if (FDocProps.DateCreated = 0) or (YY <= 2000) then
FDocProps.DateCreated := Now;
GetSystemTime(UTC);
FDocProps.DateModified := SystemTimeToDateTime(UTC);
end;
end;
Re: Wrong timestaps in XLSX files.
Posted: Wed Mar 05, 2014 3:33 pm
by larsa
Hello
Fixed in update 5.20.19
