Issue 96767 - chaining multiple operations
Summary: chaining multiple operations
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
demo of the bug (9.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-12-01 18:35 UTC, pfeffer2de 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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://
ubuntuforums.org/showthread.php?t=121043
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 http://www.openoffice.org/
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 http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.html

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.

For nested MULTIPLE.OPERATIONS see https://tools.oasis-open.org/issues/browse/OFFICE-1911
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.