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.
[Solved] Filled cells cannot be shifted beyond the sheet
[Solved] Filled cells cannot be shifted beyond the sheet
Last edited by Hagar Delest on Sat Jul 01, 2017 10:18 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Open Office 4.1.2 Win 10
Re: Error: Filled cells cannot be shifted beyond the sheet.
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
Re: Error: Filled cells cannot be shifted beyond the sheet.
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
Re: Error: Filled cells cannot be shifted beyond the sheet.
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
Re: Error: Filled cells cannot be shifted beyond the sheet.
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
Re: Error: Filled cells cannot be shifted beyond the sheet.
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Error: Filled cells cannot be shifted beyond the sheet.
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
Re: [Solved] Filled cells cannot be shifted beyond the sheet
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
Re: [Solved] Filled cells cannot be shifted beyond the sheet
Ok, thanks. Just solved the problem, didn't notice a pesky '0' in one of the cells!
OpenOffice 4.1.14 on Windows 10