Re: [libreoffice-users] LO Calc, limits(?)

2022-09-02 Thread Chris J.
Hi. As Johnny says, we probably need more information to help. #VALUE normally means that the number is too big to fit in the space it is allowed. You should be able to see the value by selecting the cell and looking at the contents in the display above the top of the sheet. Or make the cell

Re: [libreoffice-users] LO Calc, limits(?)

2022-09-02 Thread Dave Howorth
On Fri, 2 Sep 2022 20:52:13 +0200 Johnny Rosenberg wrote: > Den fre 2 sep. 2022 kl 17:33 skrev Chris J. > : > > > Hi. > > > > Hi! > > > > Is there some practical limit to the number of rows specifically, > > but columns too, that an LO Calc spreadsheet can have? > > > > Yes. Maximum for

Re: [libreoffice-users] LO Calc, limits(?)

2022-09-02 Thread Johnny Rosenberg
Den fre 2 sep. 2022 kl 17:33 skrev Chris J. : > Hi. > > Hi! > > Is there some practical limit to the number of rows specifically, but > columns too, that an LO Calc spreadsheet can have? > Yes. Maximum for rows is 2²⁰ rows, that is 1048576 rows. I'm not sure about columns, but the newest

[libreoffice-users] LO Calc, limits(?)

2022-09-02 Thread Chris J.
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