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