Bug 88361

Summary: Excel file (with XML format) corrupted after save as
Product: LibreOffice Reporter: mr_smyle
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: raal
Version: 4.3.5.2 release   
Hardware: All   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: document for example
xls mime
in windows
Other example

Description mr_smyle 2015-01-13 09:44:00 UTC
Created attachment 112154 [details]
document for example

I create file with FastReport and export it to Excel (XML)

Open it in windows - show fine formatting as expected

Open it in Lunux (Ubuntu 14.04) - wrong formatting:
 - seems like rows heights are ignore height
 - line breaks in cells not recognized.

After editing in windows and saving, issue in Linux still present.

LibreOffice 4.3.5.2 on both Linux and Windows
Comment 1 mr_smyle 2015-01-13 09:45:27 UTC
Created attachment 112155 [details]
xls mime
Comment 2 Urmas 2015-01-13 13:06:33 UTC
There are no any linebreaks in cells in your file.
Comment 3 mr_smyle 2015-01-13 18:57:30 UTC
Created attachment 112176 [details]
in windows

Attached screenshot from first open file in windows. Linebreaks in section (1) gone away after save.

Rows heights in section (2) in linux not recognized. Both before and after save in windows.
Comment 4 mr_smyle 2015-01-13 18:58:44 UTC
I can send source file to PM - it have confident information.
Comment 5 raal 2015-01-14 07:39:57 UTC
(In reply to mr_smyle from comment #1)
> Created attachment 112155 [details]
> xls mime

I tried to open this file in Excel 2010 and cannot open - error message: File corrupted, cannot open.
I can open file in LO 4.3.5, win7

Because cannot open file in excel I'll set status as notourbug. Seems to be bug in FastReport.
Comment 6 mr_smyle 2015-01-14 14:08:08 UTC
Created attachment 112217 [details]
Other example

Raal, I add other example, please check!
I'm sure LO corrupt file during save and Excel cannot open it after.
Comment 7 raal 2015-01-14 19:07:25 UTC
I can confirm with Version: 4.4.1.0.0+
Build ID: b460414bcd1dfd2f260696e306c49c56585c6464
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-01-11_05:32:52

Steps to reproduce
 -  open second file (it's xml file with .xls suffix) in LO. This file i can open in excel.
 - Save as this file in LO. XML format.
 - Close, reopen in LO. 
 - Open in excel 2010
errors :
 - in LO are borders 4 pt width
 - in Excel I cannot open -  error.
Comment 8 mr_smyle 2015-01-15 06:59:03 UTC
raal, file corruption is the second issue. What to do with different representation file on screen (rows heights and line breaks) in Ubuntu and in Windows with same LO version? Fill other one issue?
Comment 9 raal 2015-01-15 07:29:00 UTC
(In reply to mr_smyle from comment #8)
> raal, file corruption is the second issue. What to do with different
> representation file on screen (rows heights and line breaks) in Ubuntu and
> in Windows with same LO version? Fill other one issue?

Better is to have 1 bugreport = 1 bug. You can link this bugreport because I can confirm both issues:
 errors :
 - in LO are borders 4 pt width
 - in Excel I cannot open -  error.

If I remember, linebreaks in A1 was correct, row heights not (smaller value).

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.