I have been updating my database by adding new line above or below. Now get message ‘Filled cells cannot be shifted beyond the sheet’. I get this everytime I try and add a line to my database. How can I remedy this?
Tag: calc
Details: I have been updating my database by adding new line above or below
Using these two terms simultaneously confuses me. Are you talking about Base or Calc?
If you are talking about Calc: Check row `1048576` (last row of your sheet, use `CTRL+ARROW DOWN` to move to the last row), whether you inadvertently added some data there (even *non-visible* characters like a `SPACE` character cause this and it might the easiest, fastest solution to select the row and to `CTRL+X` everything).
If you really have 1048576 rows filled, you have reached the limit of a single standard LibreOffice sheet(!) and you need to add a new sheet to your document.
I did what ‘Opaque’ suggested 1048576 did have a number in it. Deleted it. All solved. Thanks