Arild Bjork wrote: > It's a very simple spreadsheet used to give my kids extra math practice. > It consists of 9 subtraction or addition excersizes like this > > number > + or - number > > in a 3 by 3 matrix > > To decide between addition or subtraction I use the RAND() function in a > hidden column to the left of the excersize. It produces a number between > 0 and 1. If the number is above 0.5 it's addition. This number is used > to decide the symbol to be displayed (+ or -) and how to set the formula > for the last number in the excersize since my kids haven't learned > numbers below zero yet. > > The number on top is set by random times 1000: > =RAND()*1000 > > If it's addition the number below is set by RAND() times 1000. If it's > subtraction, the number below is RAND() times the number above: > =IF(A2<=0,5;RAND()*C1;RAND()*1000) > > When the file is in ODS-format it opens in 10 seconds. OO Calc 2.3 or > Staroffice 8 hangs on loading document in 10 seconds. The file size is > 11 kB. When the file is in Excel-format it opens in less than a second. > The file size is 75 kB. It's repeatable closing and opening the document > using recent documents in OO or StarOffice. > > System: > AMD 2600+ > 1 GB > OO 2.3 > StarOffice 8 Product Update 7 > > Is this a bug in OO/SO?
Your description lets me think that there is indeed a problem. But you won't get a definitive answer by asking on a users mailing list and only describing your file. I recommend to file an issue in our bug tracker and attach the file so that developers can have a look at the problem. Ciao, Mathias -- Mathias Bauer (mba) - Project Lead OpenOffice.org Writer OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't reply to "[EMAIL PROTECTED]". I use it for the OOo lists and only rarely read other mails sent to it. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
