1

In Libre Calc, when I try to insert a row, I get the message, "Filled cells cannot be shifted beyond the sheet." This message makes me think that the file "thinks" there is data way out to "infinity" in this spreadsheet. In actuality, I'm only using three columns which easily fit on a standard 8.5x11 inch paper. How do I fix the spreadsheet so I can insert rows?

2 Answers 2

1

You've said you only have three columns. But your error relates to rows, not to columns.

I could reproduce your error by going to the bottom-most row, row 1048576, of the spreadsheet and typing something in a cell in that row. After that, if I tried to insert even one row anywhere in the sheet, I got the error. Similarly, if I filled a cell in row 1048566, and try to add eleven rows above the row in which I entered data, I get the error. I don't get the error if I insert only nine rows or ten rows above that row. Note how the row with the filled cell is pushed down to exactly the end of the sheet when you add ten rows.

In other words, your sheet can have only 1048576 rows. If you work at the top of the spreadsheet, as most of us normally do, we don't notice the limitation of 1048576 rows.

1
  • I searched some more after I asked this question, and I found the answer which was very similar to yours. Thanks for taking the time to answer!
    – user125523
    Commented Jan 24, 2013 at 0:21
1

Solved problem: Scroll through your open workbook (spreadsheet) and look for stray entries in columns and rows in unused areas of the document. Delete these entries and the spreadsheet will allow you to add rows again.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .