Issue 96767 - chaining multiple operations
Summary: chaining multiple operations
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO300m9
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-12-01 18:30 UTC by pfeffer2de
Modified: 2013-12-15 09:19 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

demo of the bug (9.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-12-01 18:35 UTC, pfeffer2de
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pfeffer2de 2008-12-01 18:30:24 UTC
if two multiple operations (german "Mehrfachoperation") are using the same 
formular and the output of the first multiple operation is the input for the 
second strange behavior can happen. Pressing F9 in order to force a 
recalculation toggles the result of the first multiple operation between 
"err:522" and the correct value. The second multiple operation always stays at 
"err:522" which is not correct, because no circular exists.

Only tested on Pc in Windows XP, but as it's not an ui-issue, I guess it 
effects all platforms.

This bug may be in some correlation to a bug reported here: http://
Comment 1 pfeffer2de 2008-12-01 18:35:21 UTC
Created attachment 58431 [details]
demo of the bug
Comment 2 pfeffer2de 2008-12-02 14:18:55 UTC
changed subcomponent to "ui" because I cannot provide the causing code segment. 
(I thought before "programming" means programming in calc).
Comment 3 pfeffer2de 2009-01-09 03:34:55 UTC
maybe the reason for this behavior is the same as in
issues/show_bug.cgi?id=72718 ?
Comment 4 Edwin Sharp 2013-03-29 14:27:25 UTC
What is the function MULTIPLE.OPERATIONS in attachment?
Comment 5 Regina Henschel 2013-03-29 16:01:42 UTC
See section 6.14.10 MULTIPLE.OPERATIONS in

In AOO the function is not in the function wizard, but has its own wizard in menu 'Data'. You need not use the wizard (I don't like the wizard), but you can write the function manually, same as for all other functions.

In short, is calculates the result using a formula-template with one or two variables. The first parameter is a reference to the formula-template. The second parameter names the cell, which is the variable in the formula-template and the third parameter is the actual value for this variable. The forth and fifth parameter together define the second variable; they are optional.

The actual value of the variable must not depend on any cell in the formula-template, neither direct nor indirect.

Comment 6 Edwin Sharp 2013-03-30 16:57:11 UTC
(In reply to comment #5)
> See section 6.14.10 MULTIPLE.OPERATIONS in

Thank you!
Comment 7 Edwin Sharp 2013-12-15 09:18:42 UTC
Confirmed per comment 5.