https://bugs.documentfoundation.org/show_bug.cgi?id=149856
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Mike Kaganski <[email protected]> --- (In reply to Richard from comment #0) > Expected Results: > 1. in MS Excel, pressing [command]-[down arrow] x 2 times should go to the > last row with data No. The first press is expected to bring you to the last row of the current block; the second one should bring you to the end of the next block - or to the last physical spreadsheet row (1048576) if there's no blocks below. The behavior you describe is expected. > 2. should return the last row with data No. getHighestRow is not related to "rows with data" - unlike getHighestDataRow. See e.g. https://github.com/PHPOffice/PhpSpreadsheet/issues/2051 (which is basically the same issue). Deleting rows from a file created in Excel must append new rows to the bottom; the default row heights differ between Excel and Calc -> the appended rows are narrower than the rest, and that *formatting* is reflected in the markup (and is detected by PHPSpreadsheet, and reflected by getHighestRow). Eike: can we read the default row height from the file, or maybe clone formatting from the row above when appending new rows? -- You are receiving this mail because: You are the assignee for the bug.
