Download it now!
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 XLSX-Conditional-Formatting
  Show dependency treegraph
 
Reported: 2016-05-17 22:25 UTC by VLB
Modified: 2019-10-22 17:44 UTC (History)
3 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

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.