Bug 58097 - automatic recalculation works only partly
Summary: automatic recalculation works only partly
Status: RESOLVED FIXED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (show other bugs)
Version: 1.2.90
Platform: unspecified Linux
: NOR grave
Target Milestone: ---
Assignee: Stefan Hetzl
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-04 10:34 UTC by Ferdinand Gassauer
Modified: 2003-11-07 16:39 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:

Attachments
a proposed patch (13.12 KB, patch)
2003-10-31 12:34 UTC, Stefan Hetzl 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Ferdinand Gassauer 2003-05-04 10:34:31 UTC 
Version:           1.2.90 (using KDE 3.1.9)
Compiler:          gcc version 3.3 20030226 (prerelease) (SuSE Linux)
OS:          Linux (i686) release 2.4.20-4GB

Hi
Have to press F9 to recalculate
IMHO changed sums are not recognized as changed and dependend cells are not recalculated automaticaly.
cu
ferdinand
Comment 1 Ferdinand Gassauer 2003-07-08 05:17:30 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
Comment 2 Norbert Andres 2003-09-27 13:32:01 UTC 
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?
Comment 3 Ferdinand Gassauer 2003-09-28 17:57:44 UTC 
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
Comment 4 Dik Takken 2003-10-22 21:45:41 UTC 
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.
Comment 5 Dik Takken 2003-10-22 21:47:21 UTC 
Oh, sorry, I was confused. It was version 1.2.1 that I was using...
Comment 6 Stefan Hetzl 2003-10-31 12:34:20 UTC 
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.
Comment 7 Ferdinand Gassauer 2003-11-01 10:25:45 UTC 
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.
Comment 8 Stefan Hetzl 2003-11-07 16:39:08 UTC 
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
Comment 9 Ferdinand Gassauer 2003-11-07 18:34:41 UTC 
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