Bug 99921 - EDITING: file save as XLSX give error-by page formatting pagestyle
Summary: EDITING: file save as XLSX give error-by page formatting pagestyle
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Corrupted
  Show dependency treegraph
 
Reported: 2016-05-17 22:25 UTC by VLB
Modified: 2020-12-24 15:05 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
test file with only format (15.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-05-18 18:41 UTC, VLB
Details
xcel file (23.66 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-05-18 18:42 UTC, VLB
Details
The example file saved with current nightly (33.71 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-12-18 11:04 UTC, NISZ LibreOffice Team
Details
The corrupted file after Excel 2013 repaired it (43.74 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-12-18 11:07 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description VLB 2016-05-17 22:25:38 UTC
wi 10 64 bits
Versie: 5.2.0.0.alpha1  (x64)
Build ID: 902b28a39528b6c92602e9b521a1d0861be1caf9
CPU Threads: 8; Versie besturingssysteem:Windows 6.19; UI Render: standaard; 
Locale: nl-NL (nl_NL)

I have a file and when i select all cells and choose "clear direct formatting" and save as xslx and open in excel 2007 shows error.

When i click left point sheet(full sheet) and choose "clear direct formatting" and save as xslx and open in excel 2007 didn't shows error.
Comment 1 VLB 2016-05-17 22:28:04 UTC
Cor can you help me here in?
Comment 2 Buovjaga 2016-05-18 10:10:59 UTC
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided an example document.
Comment 3 VLB 2016-05-18 10:32:25 UTC
I have a file but not for public, i try make file for public.
Comment 4 VLB 2016-05-18 18:41:44 UTC
Created attachment 125154 [details]
test file with only format

I have from the orginal file all the format from the sheet copied to a new file.

Step to reproduce;

1) open file in LO
2) save as XSLX and open in excel and there are error present

error mesage "Repaired Records: Format of the component /xl/styles.xml (Styles)"
Comment 5 VLB 2016-05-18 18:42:21 UTC
Created attachment 125155 [details]
xcel file
Comment 6 VLB 2016-05-24 06:45:25 UTC
I have a big sheet reduce to a smal file with only formatting.
By save to XSLX give error and in the sheet delete all conditional formatting in the sheet. Can you help to resolve this problem?
Comment 7 Cor Nouws 2016-05-24 07:35:03 UTC
(In reply to vlb from comment #1)
> Cor can you help me here in?

downloaded files - will search for a moment when on train today..
Comment 8 Cor Nouws 2016-05-28 11:33:10 UTC
Hi Frank,

(In reply to vlb from comment #0)
> wi 10 64 bits
> Versie: 5.2.0.0.alpha1  (x64)
> Build ID: 902b28a39528b6c92602e9b521a1d0861be1caf9
> CPU Threads: 8; Versie besturingssysteem:Windows 6.19; UI Render: standaard; 
> Locale: nl-NL (nl_NL)

I tested on Ubuntu 32 bits with LibreOffice 5.1.3.2 Locale nl_NL and LibreOffice daily20160525 Locale en_US.

> I have a file and when i select all cells and choose "clear direct
> formatting" and save as xslx and open in excel 2007 shows error.
> 
> When i click left point sheet(full sheet) and choose "clear direct
> formatting" and save as xslx and open in excel 2007 didn't shows error.

Both in 5.1.3.2 and daily I saved two versions as xlsx: one done Cltr+A and one done Click left point.

All the 4 files opened without error in Excel 2010.
But file https://bugs.documentfoundation.org/attachment.cgi?id=125155 you provided, does give the error on opening.

So possibly a difference between behaviour of LibreOffice on Windows 64 bits and Ubuntu 32 bits..
Comment 9 Buovjaga 2016-05-28 14:03:57 UTC
Repro.

Win 8.1 32-bit
MSO 2013
LibO Version: 5.3.0.0.alpha0+
Build ID: 9d2f7be4e65595241db3cf5135b69bd9e4ce6a30
CPU Threads: 4; OS Version: Windows 6.29; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-05-27_22:55:26
Locale: fi-FI (fi_FI)
Comment 10 VLB 2017-12-20 14:40:04 UTC
(In reply to Cor Nouws from comment #8)

> 
> So possibly a difference between behaviour of LibreOffice on Windows 64 bits
> and Ubuntu 32 bits..

I have test in the latest LO 5.4.3.2/6.0.0.0beta2 (x64)windows + Lo 5.4.2.2 Ubuntu and there is still a error present. It is slightly different.

To reproduce:
1) open attachment "test file"
2) click a random cell c20
3) click left point sheet(full sheet) or do Cltr+A (it doesn't make difference)
4) choose "clear direct formatting"
5) save as *.xlxs
6) when opening in excel give a error

No reproduce, where step 2 is skipped:
1) open attachment "test file"
2) click left point sheet(full sheet) or do Cltr+A (it doesn't make difference)
3) choose "clear direct formatting"
4) save as *.xlxs
5) when opening in excel didn't give a error
Comment 11 VLB 2019-10-22 17:44:58 UTC
I have test in wi 10 Versie: 6.3.2.2 (x64)and the bug is still present.
Comment 12 NISZ LibreOffice Team 2020-12-18 11:04:04 UTC
Created attachment 168284 [details]
The example file saved with current nightly

Export is still bad in:

Version: 7.2.0.0.alpha0+ (x64)
Build ID: e97a81e94511b52987a50b7bdb72c922899da588
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

However reproduction steps are different:
- Saving attachment #125154 [details] unchanged results this file - broken, Excel finds unreadable content in xl/styles.xml
- Cleaning all direct formatting from attachment #125154 [details] results in an Excel-compatible file.

Also the original file does not contain conditional formatting.
Comment 13 NISZ LibreOffice Team 2020-12-18 11:07:03 UTC
Created attachment 168285 [details]
The corrupted file after Excel 2013 repaired it