https://bugs.documentfoundation.org/show_bug.cgi?id=149856
Bug ID: 149856
Summary: XLSX: the "highest row with data" marker will go to
1048576 when deleting any row within rows with data
Product: LibreOffice
Version: 7.3.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Assume I have an Excel file (XLSX) with a data sheet containing several rows
with data only (e.g. 10 rows), when deleting one of these rows with data and
save, then open the Excel file with MS Excel or PHPSpreadsheet library, using
Excel hot key to go to the highest row or using the $sheet->getHighestRow()
goes to the 1048576th row respectively BUT NOT the 9th row. This will cause
some problem when processing the Excel with some software library, e.g.
PHPSpreadsheet
Steps to Reproduce:
1. open an Excel XLSX file with some rows with data
2. delete one of the data rows and save
3. open the resulting file with MS Excel or PHPSpreadsheet PHP programming
library
4. press hotkey ([command]-[down arrow] x 2 times) for MS Excel or call
$sheet->getHighestRow() when opening the Excel sheet using PHPSpreadsheet
Actual Results:
1. in MS Excel, pressing [command]-[down arrow] x 2 times will go to the
1048576th row
2. the $sheet->getHighestRow() returns 1048576
Expected Results:
1. in MS Excel, pressing [command]-[down arrow] x 2 times should go to the last
row with data
2. should return the last row with data
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 8; OS: Mac OS X 12.3; UI render: default; VCL: osx
Locale: en-HK (en_HK.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
