https://bugs.documentfoundation.org/show_bug.cgi?id=167013
Bug ID: 167013
Summary: Multiple Operations dialog puts resulting formulas on
wrong sheet, when formula is on a different sheet
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
1. In a new spreadsheet, put "1" in Sheet1.A1, "1" in Sheet1.A2; put "=A1+A2"
to Sheet1.B1.
2. Create Sheet2; there, put "2" to Sheet2.A2, "3" to Sheet2.A3; put "2" to
Sheet2.B1, "3" to Sheet2.C1.
3. On Sheet2, select A1:C3, and start Data->Multiple Operations.
4. In the dialog:
4.1. Click the "Shrink" button of "Formulae" box, navigate to Sheet1, and click
on B1, click "Shrink" button again;
4.2. Click the "Shrink" button of "Row input cell" box, click on Sheet1.A1,
click "Shrink" button again;
4.3. Click the "Shrink" button of "Column input cell" box, click on Sheet1.A2,
click "Shrink" button again.
5. Without returning to Sheet2, click OK.
=> The formulas will appear in Sheet1.B2:C3; and they will refer to cells on
Sheet1 in arguments 3 and 5, which is *not* the cell range selected on step 3.
The dialog must remember the sheet on which it was started.
--
You are receiving this mail because:
You are the assignee for the bug.
