Hi.

Is there some practical limit to the number of rows specifically, but columns too, that an LO Calc spreadsheet can have?


I've run into this before with my checkbook. The spreadsheet is arranged such that down is back in time, the current amount is at the top. There's a formula in one column that calculates the current amount in the account. This is where the problem happens. I added some deposits this morning and in the new rows at the top in the column which should calculate the amount in the account I get the literal #VALUE.


The column with the formula worked perfectly up to this point. The sheet has 2540 rows. I get there error gong from 2536 to 2537.


Thanks.



--

Chris Johnson   rchristopherjohn...@gmail.com
Ex SysAdmin, now, writer /Marriage is a great institution, but I'm not ready for an institution yet.
/(Mae West)

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Reply via email to