Bug 92975 - FILESAVE: .xlsx edited and saved in LibO is not compatible with MS Office 2007
Summary: FILESAVE: .xlsx edited and saved in LibO is not compatible with MS Office 2007
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.8.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Corrupted
  Show dependency tree / graph
 
Reported: 2015-07-28 08:33 UTC by Attila Hammer
Modified: 2020-09-04 09:17 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
This is my colleague me sent Microsoft Office 2007 created original XLSX table (184.62 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-07-28 08:33 UTC, Attila Hammer 		Details
This is a saved .xlsx table with I simple save as in Libreoffice Calc after I opened the first attached file (776.07 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-07-28 08:34 UTC, Attila Hammer 		Details
Linux console output (repeated lines reduced) (7.96 KB, text/plain)
2015-10-20 15:24 UTC, Timur 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Attila Hammer 2015-07-28 08:33:17 UTC 
Created attachment 117492 [details]
This is my colleague me sent Microsoft Office 2007 created original XLSX table

Dear Developers,

My colleague sent me a Microsoft Office 2007 or 2010 created .xlsx file.
After I edited the calc table, I saved the table in Libreoffice Calc with Microsoft Excel 2007/2010/2013 XML format (.xlsx the file extension).
With Libreoffice correct opening the calc table, but my colleague Microsoft Office application is not.
The original.xlsx file in my Ubuntu system the file command says following:
teszt.xlsx: Microsoft Excel 2007+
The another name saved Libreoffice Calc created .xlsx file the file command says following:
teszt2.xlsx: Zip archive data, at least v2.0 to extract
I tryed the Office open XML sheet format too the saveas dialog, but the file command producing the second file related result.

I attaching the original and the second Libreoffice saved files, possible this is help.
I tested this issue in my Ubuntu 14.04 system with original packaged Libreoffice 4.2.8 version, the Libreoffice 4.4.4 latest version and Libreoffice 5.0 RC3 version.
Testcase:
1. Open the attached teszt.xlsx file.
2. Save the file with an another name, the office 2007 related calc formats.
Expected result:
Microsoft Office if this is possible need opening the another name Libreoffice Calc saved .xlsx file.
Actual result:
My tested Libreoffice versions correct opening both two files, but my colleague Microsoft Office version unfortunately only the first file opening right.

Attila
Comment 1 Attila Hammer 2015-07-28 08:34:57 UTC 
Created attachment 117493 [details]
This is a saved .xlsx table with I simple save as in Libreoffice Calc after I opened the first attached file
Comment 2 raal 2015-07-30 17:15:33 UTC 
Hello Attila,
I can open file teszt2.xlxs in excel 2010 without problem. Seems to be a problem in your colleague's office. What's the version of his office?
Comment 3 Attila Hammer 2015-07-31 04:50:27 UTC 
Hi Raal,

I will ask he when come back from holiday.
Me unfortunately not have Microsoft Office product to test this issue, I not use my machines with Windows and Microsoft office.
This is a good news with you opened right the teszt2.xlsx file with Office 2010.

Attila
Comment 4 tommy27 2015-07-31 04:57:29 UTC 
tested both attachements under http://www.docspal.com/viewer

the original one from MSO is correctly loaded
the file save in LibO fails to be loaded

so some issue probably exists and is probably limited to old MSO versions (2007 right?) which is probably used by DocsPal too.

anyway I set status to NEW since LibO alters compatibility and interoperability of that file
Comment 5 ebrian_dale 2015-10-20 07:05:07 UTC 
Same problem with LO Calc 5.0.2.  MS Excel viewer cannot open an unedited Excel file saved in LO Calc file which LO Calc can open after saving. MS Excel 2007 opens the LO Calc saved file after repairing what it sees as a corrupted file. The repair log states: <?xml version="1.0" encoding="UTF-8" standalone="true"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error058520_01.xml</logFileName><summary>Errors were detected in file 'D:\Public\Public Downloads\174270_1-TAX FORM 2015_R saved in LO.xlsx'</summary><repairedParts summary="Following is a list of repairs:"><repairedPart>Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Load error. Line 2, column 249.</repairedPart></repairedParts><repairedRecords summary="Following is a list of repairs:"><repairedRecord>Repaired Records: String properties from /xl/sharedStrings.xml part (Strings)</repairedRecord></repairedRecords></recoveryLog>

I can upload the files if required.
Comment 6 Timur 2015-10-20 15:24:06 UTC 
Created attachment 119790 [details]
Linux console output (repeated lines reduced)

I'm not sure this is a valid bug, nor that it should be fixed. 
RT files cannot be open with Excel 2007 and Excel Viewer but they open fine with Excel 2010.
Comment 7 QA Administrators 2016-11-08 11:27:07 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2020-01-11 03:54:01 UTC Comment hidden (obsolete)
Comment 9 Timur 2020-09-04 09:17:05 UTC 
I retested this with LO master 7.1+. Resaved XLS/X open both in MSO 2007 and 2016. So I close as WFM.

Note: now saved XLSX is similar size to original, unlike before when it was larger, probably wrong.