[Solved] Filled cells cannot be shifted beyond the sheet

Discuss the spreadsheet application
Locked
camber
Posts: 4
Joined: Tue Jun 27, 2017 10:27 pm

[Solved] Filled cells cannot be shifted beyond the sheet

Post by camber »

doing my taxes.....I can't figure out how to insert new row. It used to work now I get this error. Any help appreciated. I'm spending more time trying to solve than getting data in to my sheet1. Calc 4.1.2 win 10
thx.
Last edited by Hagar Delest on Sat Jul 01, 2017 10:18 pm, edited 1 time in total.
Reason: tagged [Solved].
Open Office 4.1.2 Win 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Error: Filled cells cannot be shifted beyond the sheet.

Post by RoryOF »

Please describe just how you are trying to insert a row(s); in what file format are you working? Did the file ever originate in MS Excel?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
camber
Posts: 4
Joined: Tue Jun 27, 2017 10:27 pm

Re: Error: Filled cells cannot be shifted beyond the sheet.

Post by camber »

Using OO calc 4.1.2 make in 00 never other app has used file. Using Insert-row trying to put new row in spreadsheet. File format ods
Open Office 4.1.2 Win 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Error: Filled cells cannot be shifted beyond the sheet.

Post by RoryOF »

Click on the row number where you want the new row to select the entire row, and /Insert /Rows, or right click on the row number and /Insert Rows from the popup. Ditto for columns, mutatis mutandis.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
camber
Posts: 4
Joined: Tue Jun 27, 2017 10:27 pm

Re: Error: Filled cells cannot be shifted beyond the sheet.

Post by camber »

I am , but will try again. I'm upgrading. I think it has something to do with the sheet. But i have tried highlighting whole row, just a cell, and it doesnt' seem to matter.
Open Office 4.1.2 Win 10
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Error: Filled cells cannot be shifted beyond the sheet.

Post by FJCC »

Try the key combination CTRL + END. That will take you to the intersection of the last used row and the last used column. I suspect there is spurious data in your sheet in the last usable row 1048576. If CTRL + END does take you to an unexpected row, use the CTRL and Arrow keys to find the cell with the data.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
camber
Posts: 4
Joined: Tue Jun 27, 2017 10:27 pm

Re: Error: Filled cells cannot be shifted beyond the sheet.

Post by camber »

I lov eyou!!! you were right i found it!!! And now I have to do my taxes, i hate you too!!!!thank you sooooooooooo much
Open Office 4.1.2 Win 10
apache11
Posts: 2
Joined: Thu May 04, 2023 5:05 pm

Re: [Solved] Filled cells cannot be shifted beyond the sheet

Post by apache11 »

I have the same problem. Checked all the cells but found no other data! What else can I do??
OpenOffice 4.1.14 on Windows 10
apache11
Posts: 2
Joined: Thu May 04, 2023 5:05 pm

Re: [Solved] Filled cells cannot be shifted beyond the sheet

Post by apache11 »

Ok, thanks. Just solved the problem, didn't notice a pesky '0' in one of the cells!
OpenOffice 4.1.14 on Windows 10
Locked