[Solved] Trying to Insert Row: "Filled cells cannot be

Discuss the spreadsheet application

[Solved] Trying to Insert Row: "Filled cells cannot be

Postby JohnTN » Tue Mar 12, 2019 4:24 am

Just trying to insert a row in a spreadsheet and get a message: "Filled cells cannot be shifted beyond the sheet". Open Office 3.1.0.

If I go to the bottom of the spreadsheet with empty rows it will let me insert a row. I am trying to insert a new name and address in an alphabetical listing.

John
Last edited by RoryOF on Tue Mar 12, 2019 4:32 pm, edited 1 time in total.
Reason: Added [Solved] and green tick. [RoryOF, Moderator]
OpenOffice 3.1, Windows 7
JohnTN
 
Posts: 7
Joined: Mon Oct 19, 2015 2:09 am

Re: Trying to Insert Row: "Filled cells cannot be shifted ..

Postby RusselB » Tue Mar 12, 2019 5:06 am

First suggestion is that you upgrade your version of OpenOffice. 3.1.0 is very old and may not have all of the abilities available in later versions.
That said, what row do you get if you use Ctrl+End? That will be the bottom row and right most column of your spreadsheet.
I don't have a copy of 3.1.0, but in 4.1.6, you can have 1,048,576 rows.
Since your task is to put in new information in alphabetical order, you could just enter the information, then sort the spreadsheet using the name column (I'm guessing) as the primary sort key.
OpenOffice 4.1.7 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: 5498
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Trying to Insert Row: "Filled cells cannot be shifted ..

Postby JohnTN » Tue Mar 12, 2019 4:02 pm

I will try updating and using sort as a last resort but I don't think the version is the problem. This spreadsheet was copied from another sheet that contained addresses for 2018 and the 2018 sheet will let me add rows. This years sheet (a copy of 2018 sheet renamed for 2019) will let me add rows on other tabs in the spreadsheet but not on the one tab that contains the list of address (about 150 rows of addresses). If I go to row 151 which contains no data it will let me insert a row above 151.

John
OpenOffice 3.1, Windows 7
JohnTN
 
Posts: 7
Joined: Mon Oct 19, 2015 2:09 am

Re: Trying to Insert Row: "Filled cells cannot be shifted ..

Postby JohnTN » Tue Mar 12, 2019 4:06 pm

Another test I tried. I want to insert a row above the current row 20. I tried deleting the contents of row 20 so there were no entries in that row and then inserting a row above it but still got same message. FYI, there are 65,536 rows in my spreadsheet, all below row 150 are empty, as far as I know.
John
OpenOffice 3.1, Windows 7
JohnTN
 
Posts: 7
Joined: Mon Oct 19, 2015 2:09 am

Re: Trying to Insert Row: "Filled cells cannot be shifted ..

Postby RoryOF » Tue Mar 12, 2019 4:10 pm

To move quicky to the last cell with content, try Ctrl End. It may be that a cell has a pace or a full stop in it.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29569
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Trying to Insert Row: "Filled cells cannot be shifted ..

Postby JohnTN » Tue Mar 12, 2019 4:16 pm

Solved. Somehow there was one column that had data copied into it all the way to the bottom of the sheet. When I deleted all this extraneous data it freed up the sheet to let me insert rows.

John
OpenOffice 3.1, Windows 7
JohnTN
 
Posts: 7
Joined: Mon Oct 19, 2015 2:09 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests