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?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
