On Thu, 16 Mar 2006 15:29:39 +0100 James Leifer <[EMAIL PROTECTED]> wrote:
> Hello, > > I'm running Openoffice 2.0.1-4bpo1, the backported version on debian > sarge, on a 1.40GHz Pentium M laptop with 1GB ram. > > I have a simple spreadsheet consisting of three columns > > A B C >1 action change running total >2 ------------------------------- >3 get paid +100 100 >4 buy apples -8 92 > ... > > where the running total in row n is computed automatically by > SUM(B1:Bn). I'm finding that Calc is sluggish when I have about one > hundred rows. For example, inserting a blank row in the middle takes > several seconds. > Try these formulas (note the numbers i added to your rows). c3 =b3 c4 =c3+b4 Then drag c4 down the column. That should be quicker as each calculation of cX only looks up two cells. Your current method look up increasing numbers of cells for each calc. -- Michael Those that can, do; those that can't, teach. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
