https://bugs.documentfoundation.org/show_bug.cgi?id=165130
Bug ID: 165130
Summary: FILESAVE XLSX: corrupt warning from Excel 2019 when
topLeftCell is in frozen zone
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 104839
Created attachment 199074
--> https://bugs.documentfoundation.org/attachment.cgi?id=199074&action=edit
custom frozen spreadsheet.xlsx: hand-modified to force wrong topLeftCell
The problem occurs during export, if the sheet has a frozen view and somehow
the bottom-right pane is showing some of the frozen range. In this case, it was
writing the topLeftCell as a cell that shouldn't be possible. This has not
always been a problem..., Excel 2010 opens this just fine. (It just displays
like Calc - showing a split screen.) However at least Excel 2019 complains
about a corrupt view. It then "deletes" the "corrupt" view and so the user
loses the freeze line(s).
Probably generated by multiuser online, this can also occur during a file-open
of an already "corrupted" document.
Steps to reproduce
1.) open custom frozen spreadsheet.xlsx in LO. (Excel already complains it is
corrupted.)
2.) save and reload in Excel.
LO has not "fixed" the document, but still round-trips it corrupted, showing
that is it possible to potentially create a corrupt xlsx file in certain
circumstances.
[When opening the document, notice that the bottom right pane is showing cell
A1 again. That shouldn't be possible for a frozen sheet. The freeze is still in
place, and will "activate" once you move right/down enough.]
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
--
You are receiving this mail because:
You are the assignee for the bug.
