[Solved] Spreadsheet suddenly truncated at row 749

[carrc99x]

OpenOffice 4.1.6, Windows 10 64 bit. My spreadsheet has suddenly been truncated at row 749. I cannot find any help as to how to ADD (not insert) rows. In any case row 749 is well short of the maximum number of rows.

[RusselB]

Welcome to the Forums.
Can you insert rows? If not, then, for some reason, the last row 1048576 has something in it and all of the rows from 750 to 1048576 have been hidden.
Can you see any row numbers after 749?
If the file doesn't contain confidential information, please attach a copy of it. Instructions for doing so are here
The above link also includes information on making your file anonymous, so that confidential information remains confidential, yet allows us to see your file structure.

[carrc99x]

I can insert rows. When I insert a row I then have an empty 749 row & the original 749 is then numbered as 750. When I delete row 749 I then get a new last row numbered 1048576 with nothing in between row 749 & row 1048576.

[robleyd]

You can confirm the extent of your sheet with Ctrl+End; this key combination takes you to the bottom right of the cell area that is in use.

[carrc99x]

Ctrl+End goes to row 749 on the original spreadsheet i.e. without row 1048576 included as described in previous reply.

[RoryOF]

File format used?

[carrc99x]

NTFS

[robleyd]

The question refers to the file format in which you save your spreadsheet rather than the type of file system you use; native ODF format (.ods) or something else.

[carrc99x]

Then .ods is correct.

[RusselB]

Since you can insert a row above 749, what happens if you insert that row (now giving you access to row 1048576, according to you), then highlight everything from 750 to 1048576 (which, it sounds like, will look like 2 rows), then right click on one of those row numbers, then select Show?

[RoryOF]

Has your file ever been saved in .xls format, or edited on another computer in such format?

[carrc99x]

Your suggestion on Fri Sep 13, 2019 12:27 am using right click & Show has worked. I saved & reopened & everything is bach to normal.
Thank you very much for your help.