Bug 99982 - FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel
Summary: FILE SAVE: formatting (and copy of formatting to new file) (from specific f...
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: filter:xlsx
Depends on:
Blocks: XLSX-Corrupted
  Show dependency treegraph
 
Reported: 2016-05-21 15:30 UTC by VLB
Modified: 2022-12-27 17:49 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
test file (18.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-05-21 15:30 UTC, VLB
Details
test file XSLX 5.1.3.2 (6.62 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-05-21 15:32 UTC, VLB
Details
orig test file - saved as xlsx in daily20160525 (7.57 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-05-28 13:05 UTC, Cor Nouws
Details
test file copied from orig file - saved as xlsx in daily20160525 (6.72 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-05-28 13:06 UTC, Cor Nouws
Details
error message on opening in Excel (9.69 KB, image/png)
2016-05-28 13:08 UTC, Cor Nouws
Details
Minimized example file (12.24 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-12-21 12:19 UTC, NISZ LibreOffice Team
Details
The minimized example file saved as xlsx (4.78 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-12-21 12:21 UTC, NISZ LibreOffice Team
Details
The minimized example and its xlsx-version in Calc (106.89 KB, image/png)
2020-12-21 12:22 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-21 15:30:51 UTC
Created attachment 125213 [details]
test file

Wi 10 64 bits LO 5.1.3.2

By copy only "formats" and "comments" cells to new file and save as XSLX and open in excel 2007 give error.

Reprodeuce:

1) open attachment
2) select cells A1:Q5 and choose copy cells
3) open new file and choose "paste special"
4) save file as *.ods and close
5) open new *.ods file and save as XSLX and close
6) open file in excel and give error

Not reproduce:
1) open attachment
2) select cells A1:M5 and choose copy cells
3) open new file and choose "paste special"
4) save file as *.ods and close
5) open new *.ods file and save as XSLX and close
6) open file in excel and didn't give error

The only changed is more horizontal columns
Comment 1 VLB 2016-05-21 15:32:26 UTC
Created attachment 125214 [details]
test file XSLX 5.1.3.2
Comment 2 Cor Nouws 2016-05-28 12:16:13 UTC
(In reply to vlb from comment #0)

> 1) open attachment
> 2) select cells A1:Q5 and choose copy cells
> 3) open new file and choose "paste special"

What do you select in "Paste special" ?

Choosing default settings (Text/Numbers/Date time) I did both tests in daily20160525.

The files open without problem in Excel 2010.
Your https://bugs.documentfoundation.org/attachment.cgi?id=125214 does give the error.
Comment 3 VLB 2016-05-28 12:40:01 UTC
> What do you select in "Paste special" ?
I select in "paste special" option "comments" and "formats"
> 
> Choosing default settings (Text/Numbers/Date time) I did both tests in
> daily20160525.
When i slect in menu "clear direct formatting" for the entire sheet then save as XSLX and open the file without error.

I can reproduce it also with open the ods file and save as XSLX in LO 5.1.3 and when opening in excel 2007 give a error.
Comment 4 Cor Nouws 2016-05-28 13:04:54 UTC
(In reply to vlb from comment #3)
> > What do you select in "Paste special" ?
> I select in "paste special" option "comments" and "formats"

I confirm the problem with that scenario.

> I can reproduce it also with open the ods file and save as XSLX in LO 5.1.3
> and when opening in excel 2007 give a error.

Using the original file: same problem.
Comment 5 Cor Nouws 2016-05-28 13:05:55 UTC
Created attachment 125346 [details]
orig test file - saved as xlsx in daily20160525
Comment 6 Cor Nouws 2016-05-28 13:06:32 UTC
Created attachment 125347 [details]
test file copied from orig file - saved as xlsx in daily20160525
Comment 7 Cor Nouws 2016-05-28 13:08:50 UTC
Created attachment 125348 [details]
error message on opening in Excel
Comment 8 Cor Nouws 2016-05-28 13:52:06 UTC
@frank: form your initial description we know that the problematic formatting is in the range M1:Q5.
Can you please narrow down the range? That should make it easier to fix the problem.
Thanks
Comment 9 VLB 2016-05-28 14:04:43 UTC
(In reply to Cor Nouws from comment #8)
> @frank: form your initial description we know that the problematic
> formatting is in the range M1:Q5.
> Can you please narrow down the range? That should make it easier to fix the
> problem.
> Thanks

In bug 99921 it is the same file but only formatting in the file. In that file is the same issue i think.
Comment 10 VLB 2016-05-28 14:33:56 UTC
(In reply to Cor Nouws from comment #8)
> @frank: form your initial description we know that the problematic
> formatting is in the range M1:Q5.
> Can you please narrow down the range? That should make it easier to fix the
> problem.
> Thanks

When the orginal test file is open and delete all range a1:M6 and i do the steps to reproduce it is als give the error, when you copy the range A1:Ap.

The range select A1:AO is without error.
Comment 11 VLB 2017-12-20 14:49:19 UTC
I have test in LO 6.0.0.0beta2 64 bit and issue is still present.
Comment 12 VLB 2017-12-20 14:50:24 UTC
(In reply to vlb from comment #11)
> I have test in LO 6.0.0.0beta2 64 bit and issue is still present.

When i paste without format then didn't give error.
Comment 13 VLB 2019-10-22 17:49:51 UTC
I have test in wi 10 Versie: 6.3.2.2 (x64)and the bug is still present.
Comment 14 NISZ LibreOffice Team 2020-12-21 12:19:52 UTC
Created attachment 168377 [details]
Minimized example file

Looks like the problem source is the custom formatting in P1 of the original file.
Comment 15 NISZ LibreOffice Team 2020-12-21 12:21:34 UTC
Created attachment 168378 [details]
The minimized example file saved as xlsx

Calc opens this, but resets the custom formatting to the default Number - Standard.
Excel fails to open this as seen on attachment #125348 [details]
Comment 16 NISZ LibreOffice Team 2020-12-21 12:22:32 UTC
Created attachment 168379 [details]
The minimized example and its xlsx-version in Calc

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
Comment 17 NISZ LibreOffice Team 2020-12-21 12:25:05 UTC
Removing conditional formatting metabug, this is a number formatting problem.

@Eike, I thought you might be interested in this one.
Comment 18 QA Administrators 2022-12-25 03:21:46 UTC Comment hidden (obsolete)
Comment 19 VLB 2022-12-27 17:49:36 UTC
I have test in
Version: 7.4.3.2 (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL

The issue is still present in Excel 2016.