wi 10 64 bits
Versie: 220.127.116.11.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.
Cor can you help me here in?
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided an example document.
I have a file but not for public, i try make file for public.
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)"
Created attachment 125155 [details]
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?
(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..
(In reply to vlb from comment #0)
> wi 10 64 bits
> Versie: 18.104.22.168.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 22.214.171.124 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 126.96.36.199 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..
Win 8.1 32-bit
LibO Version: 188.8.131.52.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)
(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 184.108.40.206/220.127.116.11beta2 (x64)windows + Lo 18.104.22.168 Ubuntu and there is still a error present. It is slightly different.
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
I have test in wi 10 Versie: 22.214.171.124 (x64)and the bug is still present.
Created attachment 168284 [details]
The example file saved with current nightly
Export is still bad in:
Version: 126.96.36.199.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
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.
Created attachment 168285 [details]
The corrupted file after Excel 2013 repaired it