Hi
I'm sorry that I haven't replied sooner, but I had not installed Koffice
because I'm running Trisquel on 12 gig hard drive. I know, it's just a
"thing". So, I installed Koffice and did a test.
I work with spreadsheets regularly using Koffice and translate them through
OO if I have to send them to a MS user etc. So I am familiar with the
program.
I test the following sheet on a Gateway 4200 dual core 64 with 2 gig of ram:
An ODS sheet with 23 x 37 cells. First four rows text, the rest data with
the exception of two calculated rows, one of them total and one "media" for
the rows.
I don't have ANOVA or anything like that set up.
It opened in about 3 seconds in OO and probably 2.5 with Kspread.
I was able to move columns, copy columns, undo the moves and it was almost
instantaneous.
I was able to make a standard bar chart from all of the columns(using only
one column as lable and aside from the "normal" couple of second or so lag
after one clicks the chart button, everything went normally.
So....given the above, I'd say that SirGrant is probably correct that you may
have a corrupted file.
However, it did occur to me that maybe you have somehow inadvertently created
some kind of "special" number and that it might be hidden away in a place
that you don't easily see and it might be interacting with the data. There
is, in OO a box to tick for that when you first open it. Or it may be that
you created a script, or called a script, with an unremembered combo of
keystrokes and it is in an odd place in the sheet and you haven't noticed it.
just a thought.
Again, SirGrant is probably correct.
janus
