Summary: | automatic recalculation works only partly | ||
---|---|---|---|
Product: | [Applications] calligrasheets | Reporter: | Ferdinand Gassauer <gassauer> |
Component: | general | Assignee: | Stefan Hetzl <shetzl> |
Status: | RESOLVED FIXED | ||
Severity: | grave | ||
Priority: | NOR | ||
Version: | 1.2.90 | ||
Target Milestone: | --- | ||
Platform: | unspecified | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | ||
Sentry Crash Report: | |||
Attachments: | a proposed patch |
Description
Ferdinand Gassauer
2003-05-04 10:34:31 UTC
Hi! Example A4=sum(a1:a3) or a4=a1+a2+a3 cut/past a2 to b2 and vice versa a4 is not recalculated automatically, have to press f9 IMHO at least "grave" because it differs from other spreadsheets automatic recalculation is ON IMHO the behavior is not consitent because entering a number via keyboard in a2 (+ ENTER) recalculates a4 cu ferdinand Subject: Re: automatic recalculation works only partly Works for me, maybe I didn't understand it correctly.. I did the following: A B 1 2 2 3 5 3 4 4 * 5 * : =A1+A2+A3 A4 = 9 Copy B2, paste A2 -> A4 is 11 now. Same works with sum(A1:A3) Can you confirm this, so that I can close the bug report? yes and no A 1 2 2 4 3 6 A4=A1+A2+A3=12 cut a2 paste b2 A4=8 now enter a number in A2 - nothing happens F9 recalculates I have the same problem with version 1.2.93. Changing one of the values of a summed series of cells does not automatically reaclculate the sum. Moving to the cell that contains the SUM and pressing ENTER does update the sum. Oh, sorry, I was confused. It was version 1.2.1 that I was using... Created attachment 2947 [details]
a proposed patch
This patch fixes the bug by preserving the DependingOnMe list of cells when
necessary.
I have sent a (non-complete) variant of this patch to koffice-devel a while ago
but got no response. Please tell me if it is ok to commit.
Yes I think this "depend on me" works now. Although I experienced 1 case where it didn't work, but I can't reproduce - have to try more situations. Subject: koffice/kspread CVS commit by shetzl: fix automatic recalculation by preserving the DependingOnMe list of cells on deletion when necessary CCMAIL: 58097-done@bugs.kde.org M +49 -0 kspread_cell.cc 1.525 M +7 -0 kspread_cell.h 1.161 M +47 -14 kspread_cluster.cc 1.18 M +6 -4 kspread_cluster.h 1.13 M +12 -8 kspread_sheet.cc 1.520 M +12 -2 kspread_sheet.h 1.251 Subject: Re: automatic recalculation works only partly Not sure example A1=1 A2=2 A3=3 A4=4 B4=A2+A3 now cut the range A3:b4 and past it into b3 C4=A2+A3 but should be A2+B3 may be this is bug http://bugs.kde.org/show_bug.cgi?id=58094 |