Apache OpenOffice (AOO) Bugzilla – Issue 67405
Changed-Flag will be set by automatically calculated change
Last modified: 2017-05-20 11:11:25 UTC
I have a spreadsheet containing cells calculated via formulas from other cells and the result values of calculation are depicted in a chart diagram. When I open this document, it is set to changed. So when I close it again without any further changes, I will be asked whether to save my changes or discard them. This does not happen, if the cells displayed in the chart contain values, instead of formulas. It also does not happen, when the calculated values are not put to a chart. I did not make any experiments, whether the behaviour depends on the formulas used, the formula is =ZÄHLENWENN(INDIREKT(bereichRef);F$23) (should be =COUNTWHEN(INDIRECT(bereichRef);F$23) in English version?), where bereichRef contains a cell range ($C$10:$C$15). I would expect a document to be unchanged after opening it. This is the desired behaviour. See attachment for example.
Created attachment 37786 [details] example spreadsheet
I checked with "2.0.2 German version WIN XP: [680m5(Build9011)]" and can confirm the reported effect. All the same with "1.1.4 (German) WIN XP: [645m52 (Build 8824)]". There isn't any entry in the UNDO-list and also the "Save-Button" is not active, but when I want to save the document without any change, I will be asked whether I want to save the document when I want to close it. This will only happen as long as the formula in 'F24:F26' are active AND the spreadsheet contains a diagram AND property "calulate cell contents automatically" is set. I see the same effect in a self created spreadsheet containing a 'now()' statement.
Created attachment 37795 [details] another document showing the same effect
Hi Rainer, a NOW() function returns the current Date and time and therefore the changed flag must be set on loading as the result of the cell changes. Frank
Hi Niklas, please have a look at this one. Maybe related to Issue 65582 ? Frank
.
@Frank: I knowingly checked with "now()", because it seemed to me a similar "enforced cell calulation" as with "=ZÄHLENWENN(INDIREKT(bereichRef);F$23)" The changed flag only will be set if the spreadsheet contains a chart (I did not check what data must be shown in diagram to effect the reported behaviour). The request to save will not occur if I open and close a similar spreadsheet containing only "now()" without any chart.
Hi, a short remark on the "Save-Button" is not active topic from rainerbielefeld Sun Jul 16 09:34:04 -0700 2006: I observed the same, but when clicking to some cell, the "Save-Button" will become active.
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
Reset assigne to the default "issues@openoffice.apache.org".