Bug 147410 - [FILESAVE] File corrupted saving in xls and opening in MS Excel
Summary: [FILESAVE] File corrupted saving in xls and opening in MS Excel
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-14 12:24 UTC by kevinpr
Modified: 2022-07-25 11:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Step1 (10.50 KB, application/vnd.ms-excel)
2022-02-14 12:25 UTC, kevinpr 		Details
Step2 (10.50 KB, application/vnd.ms-excel)
2022-02-14 12:25 UTC, kevinpr 		Details
Step3. Is step2 file, opened in LOO and saved as xlsx (7.21 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-02-14 12:25 UTC, kevinpr 		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 kevinpr 2022-02-14 12:24:48 UTC 
Description:
Open a file in xls format, adding a multiply formula and saving causes file to corrupt

Steps to Reproduce:
1. Open the "step1.xls" file
2. Provide formula for S2: "=F2*1.2"
3. Down to S11 (Same formula with F3,4...)
4. Save as step2.xls
5. Open in MS Excel (Tested 2016 and LTSC)

Actual Results:
MS Excel says file is corrupt and formula changes to #N/A

Expected Results:
MS Excel opens file correctly.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice can open the file succesfully.
If I save as xlsx format, MS Excel can open the file without problems.
Comment 1 kevinpr 2022-02-14 12:25:14 UTC 
Created attachment 178263 [details]
Step1
Comment 2 kevinpr 2022-02-14 12:25:27 UTC 
Created attachment 178264 [details]
Step2
Comment 3 kevinpr 2022-02-14 12:25:51 UTC 
Created attachment 178265 [details]
Step3. Is step2 file, opened in LOO and saved as xlsx
Comment 4 Ezinne 2022-02-20 21:12:25 UTC 
The version is not specified.

Please can you share the information in the About dialog?
Comment 5 kevinpr 2022-02-21 07:44:14 UTC 
Hi
About dialog info:

Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 12; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL
Comment 6 Robert Davis 2022-05-31 16:11:57 UTC 
Same here. Save a XLS spreadsheet that has MID() function in field. Gets changed to #NA in EXCEL but loads fine in Libreoffice. XLSX saving works fine. Started doing this in 7.3.
Comment 7 raal 2022-07-20 15:37:37 UTC 
I can not confirm with Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 28daee8a3252e03a67484dc8d3dd26fd73af4826
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

and excel 2010. When I open your file step2.xls in excel2010, I get error message.

Seems to be fixed with dev version. Please could you test it with
dev version?  You can download it here:
http://dev-builds.libreoffice.org/daily/master/
Thank you
Comment 8 Robert Davis 2022-07-20 22:13:24 UTC 
7.3.4 Fixed this for me.  I tried to create a new file using my same steps and had no problems in Excel. I then loaded an old .xls that had the problem and re-saved it as a new .xls and that file now had no problem loading in Excel.
Comment 9 kevinpr 2022-07-25 10:51:11 UTC 
Fixed for me too in 7.3.4.2
Old files (Saved with LOO <= 7.3.3) continue to be opening fine in LOO > 7.3.3, and if saved again, opens right in MSOffice
Thanks