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 XLSX-Conditional-Formatting
  Show dependency treegraph
 
Reported: 2016-05-21 15:30 UTC by vlb
Modified: 2019-10-22 17:49 UTC (History)
2 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

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.