https://bz.apache.org/ooo/show_bug.cgi?id=127781
Issue ID: 127781
Issue Type: DEFECT
Summary: Timestamp change on load of .xls
Product: Calc
Version: 4.1.3
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Critical
Priority: P5 (lowest)
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 86427
--> https://bz.apache.org/ooo/attachment.cgi?id=86427&action=edit
top left origina .ods, top center .xls on Excel, and on bottom center .xls
opened with OpenOffice calc
1)new file, format .ods on cacl timestamp.ods, and timestamp.xls
2) any cell, if(b1<>"";b1;now()) timestamp. Iterations active to avoid error.
2b) if(a1<>"";if(b1<>"";b1;now());""), and I just place an (x) on A1 for
timestamp
3) save file as timestamp.ods, and timestamp.xls format
4) open timestamp.xls format with openoffice calc, and timestamp states now()
not
when it was really made.
5) open timestamp.xls on Microsoft Excel and timestamp is correct. No issue
here.
6) save timestamp.xls on openoffice, and all information will get lost.
7) issue step (4) If I just want to make a quick change to the file. I am not
able to, because timestamp has change. And I would have to open again the
timestamp.ods, and save it as timestamp.xml again, and yet never be able to
really open .xml file to edit anything bacause of timestamp changing, that is
really a hassle, and needs to be fixed.
--
You are receiving this mail because:
You are the assignee for the issue.
