I've an OO spreadsheet of a reasonable size. It has about four or five
sheets, one of which has about 10,000 lines, and it has an array formula to
go through and total the categories of this 10k line sheet into an array 6 x
400 cells. Lets say, they could be a 10k list of events, of 400 types,
occurring at one of 6 dates.
When opening, it takes forever to do something it calls 'adjusting row
height'. I can't figure out what it can be doing, since all row heights are
default values. Looking on the OO discussion groups, someone has posted this
query but got no answer. It makes no difference if its in xls format or odt.
Any ideas?
Yes, I know one should probably not do this sort of thing in a spreadsheet,
and maybe I'll rewrite it in a better vehicle, but the advantage was, done in
a spreadsheet its available to any intelligent secretary. Or that was my
theory, which was a bit dented when trying to explain how in array formulas
multiplication becomes logical and.... It seems simple, but it turned out to
be quite hard for them to get their heads around. But its still more
accessible than a 'real programme'.
Peter