[Solved] Spreadsheet suddenly truncated at row 749

Discuss the spreadsheet application

[Solved] Spreadsheet suddenly truncated at row 749

Postby carrc99x » Wed Sep 11, 2019 5:37 am

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.
Last edited by robleyd on Sat Sep 14, 2019 5:24 am, edited 2 times in total.
Reason: Add green tick
OpenOffice 4.1.6. Windows 10 64 bit.
carrc99x
 
Posts: 6
Joined: Wed Sep 11, 2019 5:22 am

Re: Spreadsheet suddenly truncated at row 749

Postby RusselB » Wed Sep 11, 2019 5:58 am

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.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5401
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Spreadsheet suddenly truncated at row 749

Postby carrc99x » Wed Sep 11, 2019 7:47 am

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.
OpenOffice 4.1.6. Windows 10 64 bit.
carrc99x
 
Posts: 6
Joined: Wed Sep 11, 2019 5:22 am

Re: Spreadsheet suddenly truncated at row 749

Postby robleyd » Wed Sep 11, 2019 10:39 am

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.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2941
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Spreadsheet suddenly truncated at row 749

Postby carrc99x » Wed Sep 11, 2019 12:08 pm

Ctrl+End goes to row 749 on the original spreadsheet i.e. without row 1048576 included as described in previous reply.
OpenOffice 4.1.6. Windows 10 64 bit.
carrc99x
 
Posts: 6
Joined: Wed Sep 11, 2019 5:22 am

Re: Spreadsheet suddenly truncated at row 749

Postby RoryOF » Wed Sep 11, 2019 12:10 pm

File format used?
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29453
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spreadsheet suddenly truncated at row 749

Postby carrc99x » Thu Sep 12, 2019 7:18 am

NTFS
OpenOffice 4.1.6. Windows 10 64 bit.
carrc99x
 
Posts: 6
Joined: Wed Sep 11, 2019 5:22 am

Re: Spreadsheet suddenly truncated at row 749

Postby robleyd » Thu Sep 12, 2019 7:37 am

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.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2941
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Spreadsheet suddenly truncated at row 749

Postby carrc99x » Thu Sep 12, 2019 3:15 pm

Then .ods is correct.
OpenOffice 4.1.6. Windows 10 64 bit.
carrc99x
 
Posts: 6
Joined: Wed Sep 11, 2019 5:22 am

Re: Spreadsheet suddenly truncated at row 749

Postby RusselB » Thu Sep 12, 2019 3:27 pm

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?
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5401
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Spreadsheet suddenly truncated at row 749

Postby RoryOF » Thu Sep 12, 2019 3:42 pm

Has your file ever been saved in .xls format, or edited on another computer in such format?
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29453
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spreadsheet suddenly truncated at row 749

Postby carrc99x » Sat Sep 14, 2019 5:18 am

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.
OpenOffice 4.1.6. Windows 10 64 bit.
carrc99x
 
Posts: 6
Joined: Wed Sep 11, 2019 5:22 am


Return to Calc

Who is online

Users browsing this forum: RusselB and 31 guests