Ask Your Question

Calc - can't add rows [closed]

asked 2014-02-02 22:30:48 +0200

LaBlo gravatar image

Howdy: trying to simply add rows to a calc spreadsheet.

I click the "Insert Row" option, and I only get this message: "Filled cells cannot be shifted beyond the sheet."

I have tried clicking on blank rows; that doesn't work.

Cutting and pasting rows into blank spaces down the spreadsheet works, but that is super clumsy and ridiculous.

Anyone have an answer for this? Anyone else have this problem?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 05:59:54.057529


Please edit your question to indicate your operating system and LO version. Thanks.

oweng gravatar imageoweng ( 2014-02-02 23:59:19 +0200 )edit

4 Answers

Sort by » oldest newest most voted

answered 2014-02-03 00:14:33 +0200

oweng gravatar image

In Calc there is a upper limit to the number of rows and columns (1024, refer enhancement fdo#50916) each sheet can contain. When inserting new columns or rows all existing content is shifted. If there is any entry (content) in either the final row or column, this message will be displayed:

Filled cells cannot be shifted beyond the sheet.

... because the existing number of rows / columns cannot be increased. It is easy to produce this error message by opening a new spreadsheet, entering "a" in A1, CTRL+left_arrow to go to the last column, enter "z", and then right-click on any column header and select "Insert Columns" (v3.x-v4.0) / "Insert Columns left" (v4.1).

Check to see if you have any content in the sheet in the last row or column. Move this content elsewhere.

edit flag offensive delete link more


Hi @oweng, despite the long distance, we are able to cross in the air.

m.a.riosv gravatar imagem.a.riosv ( 2014-02-03 01:21:41 +0200 )edit

answered 2014-02-02 22:39:42 +0200

m.a.riosv gravatar image

Maybe with your insertion you are moving the data below your inserted rows beyond the limit for rows (1048576). Search for your last row with data Ctrl+End and calculate if you are trying to insert more rows than there are between the last with data and the limit.

edit flag offensive delete link more


@mariosv, I had this page open for some time before posting. I should have clicked refresh.

oweng gravatar imageoweng ( 2014-02-03 00:15:55 +0200 )edit

answered 2015-10-01 11:22:58 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Try to copy-paste whole sheet to new sheet, it helped to me

edit flag offensive delete link more

answered 2014-02-02 23:02:29 +0200

LaBlo gravatar image

Hi Mario:

Thanks for your advice: that was exactly the problem! Some data had indeed jumped to the end, to 1048576, in spite of my document being of the simplest and shortest type.

Well done, Sir.

I might have never thought to look spite of the "beyond the sheet" comment, that i clearly didn't understand.

edit flag offensive delete link more


Please add "thank you" to the answer directly as a comment. Thanks!

bencomp gravatar imagebencomp ( 2014-02-03 00:31:28 +0200 )edit

Question Tools

1 follower


Asked: 2014-02-02 22:30:48 +0200

Seen: 7,928 times

Last updated: Feb 03 '14