https://bugs.documentfoundation.org/show_bug.cgi?id=170246
Bug ID: 170246
Summary: Removing rows in XLSX creates row 1048576
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If a user opens an .xlsx spreadsheet originating from MS Excel which has only a
few rows and removes some of them, then saves the result as .xlsx,
<row r="1048576" ...>
will be created in xl/worksheets/sheet1.xml and the updated <dimension> tag
will reflect this, e. g.: <dimension ref="A1:D1048576"/>
The unexpectedly created <row r="1048576" ...> will be empty and invisible in
the UI. However, this drives crazy simple programs, processing the spreadsheet
row by row and column by column. They try to process 1048576 rows from 1 to
1048576 which takes eternity.
Steps to Reproduce:
1. Create a new spreadsheet in MS Excel 365.
2. In row 1, enter "Hello" in cell A1, "world" in cell B2. In row 2, enter
"Mum" in A2, "loves" in B2, "ice" in C2, "cream" in D2. Exact strings do not
matter.
3. Save as excel.xlsx (default MS Excel XLSX format)
3. Open excel.xlsx in LibreOffice Calc
4. context menu on row 1 (right mouse click row 1) -> click "Delete rows".
5. Save as localc.xlsx
6. Look at xl/worksheets/sheet1.xml inside localc.xlsx
Actual Results:
<dimension ref="A1:D1048576"/>
...
<sheetData>
<row r="1" customFormat="false" ht="15" hidden="false" customHeight="false"
outlineLevel="0" collapsed="false">
...
</row>
<row r="1048576" customFormat="false" ht="12.8" hidden="false"
customHeight="false" outlineLevel="0" collapsed="false"/>
</sheetData>
...
Expected Results:
<dimension ref="A1:D1"/>
...
<sheetData>
<row r="1" customFormat="false" ht="15" hidden="false" customHeight="false"
outlineLevel="0" collapsed="false">
...
</row>
</sheetData>
...
Reproducible: Always
User Profile Reset: No
Additional Info:
LibreOffice Calc version:
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 20; OS: Windows 11 X86_64 (build 26100); UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
MS Excel version:
Microsoft® Excel® for Microsoft 365 MSO (Version 2510 Build 16.0.19328.20266)
64-bit
To quickly look at the XML inside the localc.xlsx, I used the following console
command under Linux:
unzip -p localc.xlsx xl/worksheets/sheet1.xml | xmllint --pretty 1 /dev/stdin
--
You are receiving this mail because:
You are the assignee for the bug.
