John Richard Smith wrote: > Oh, yes, That's the nature of averages, you have to start the first > line so many horizontal (H)columns down, so 10day moving average > starts at horizontal line 10, 30 at H30, 50 at H50, 89 at H89,200 at > H200, and so on,
Ahh, OK, now I understand what your data is -- originally I didn't know whether you were perhaps collecting data for example every 15 minutes and generating, for example, a 2 hour moving average. (I guess I could have pieced this out by looking at your sample file more closely ;-) BTW, just for the record, I would characterize your spreadsheets as very small at this point in time, and would expect that you can use a spreadsheet (something faster to load than KSpread) for a long time to come. > > > I would say the developers at kde resposible for kspread need to > > > look into this urgently. > > > > Yes, I wonder if anybody has filed a bug -- are you willing to try > > it? > I suppose I could, though I'm hardly a racing hot computer buff. > To be honest I don't know anything about how to go about it. > > Still, I will, and suggestions how? Well, I'll give you some hints -- for me now it would involve a fair amount of searching to recall how to do it -- basically: * Go to the kde website (IIRC) it's www.kde.org. * Look for something about reporting bugs, or, look for something specific about KSpread (IIRC, they keep one common database buglist (bugzilla) to report bugs for all their applications * Are you using the most recent version of KSpread? Last time I tried to report a bug, the instructions didn't want to allow it because I was using an older version of whatever application I was going to report on (it was probably konqueror), because I've taken to upgrading kde when a new Mandrake install includes an updated version -- and, my "experimental" machine is still at Mandrake 8.1 (my "production" machine is at Mandrake 7.2). * When you get to the place where you can report bugs, they will want you to make a reasonable effort to confirm that you are not reporting a bug that is already reported, I ususally try a search on a few likely key words, if no duplicate bug is found, I'll report my bug, but I usually say something like "I tried a search on [slow loading] and [something else] (for example), and could not find a duplicate" -- it lets them know you tried. * Describe the bug, tell them the version of KSpread you're using, the processor speed, amount of RAM memory, in this case something about the disk size and type (IDE vs. SCSI). Maybe a good clue to mention is that the same size spreadsheet loads in 1 1/2 seconds in Gnumeric on the same hardware, 1 second in Excel on slower hardware. Let me know how you make out. regards, Randy Kramer
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
