Hello,
I can't seem to manage Calc with even a simple problem. I am trying to
read and work with a spreadsheet made from a .csv file with columns of
numbers. I really have tried to read and work with the HELP file.
First I could not add 4 numbers but with lots of tries found that it
seemed to be because all my numbers ended in .0 and when I did a global
replace of .0 with nothing I could then add numbers. Once I did that I
was able to compute an average and then copy the formula to other places
in the spreadsheet. I first did try formatting the number field but that
didn't seem to help. If someone could tell me why I can't use numbers
ending in .0 I would be interested.
Second my current problem is I cannot find the spread of 4 numbers. I
tried =MAX(C2:C3;C4;C5)-MIN(C2;C3;C4:C5) and it worked! Then when I
copied that formula into a new location to get
=MAX(C6;C7;C8;C9)-MIN(C6;C7;C8;C9) it gives me the incorrect value 0. If
I copy or type the formula into any other cell it will not work.
If anyone knows what my problem is I would appreciate it.
Thank you
Bill Dillinger
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org