Hi Regina,
Regina Henschel wrote:
Hi Leonard,
Leonard Mada schrieb:
I needed today to fill up exactly 30,000 rows. How do I do this?
Enter the cell range - for example A2:AMJ30001 - into the 'Name Box'
(the drop down list on the left side of the formula bar) and hit
enter. Now the range is marked.
Yes, I remembered some 5 minutes later, but unfortunately Calc has
already crashed - which made me very angry. Now, I tried this same with
A1:A30000 and pasted just a simple formula on an empty spreadhseet, BUT
Calc crashed again. [Though it works with simple numbers.]
But why did it crash with the formula?
It repeatedly crashes. [The original formula evaluates to a "Value!"
error - but nevertheless it should not crash.]
This is a rather limited range 1 x 30,000 = 30,000 cells in an otherwise
empty spreadsheet. I do have 1.3 GB physical RAM + additional swapfile.
Win2k SP4
In the Win TaskManager, Calc changes immediately to "Not responding".
Waiting >10 minutes did not result in a response.
Now I tried it again with a formula that does NOT evaluate to an error,
and it crashed over again. It becomes immediately non-responsive. This
is a major limitation, because any serious work involves more and more
data.We are in the year 2008 and 30,000 cells is not a rarity anymore. I
already feel the 65,535-rows limitation, BUT actually Calc even doesn't
reach that theoretical limit.
Sincerely,
Leonard
If you do not know, that the last column is AMJ, then click the head
of the first row. The Name Box will show the last column. Then you can
adapt the line number to your needs.
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
