Bug 58097

Summary: automatic recalculation works only partly
Product: [Applications] calligrasheets Reporter: Ferdinand Gassauer <gassauer>
Component: generalAssignee: 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
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