https://bugs.documentfoundation.org/show_bug.cgi?id=123662
Bug ID: 123662
Summary: EDITING: matrix formula fails if filter is applied
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 149545
--> https://bugs.documentfoundation.org/attachment.cgi?id=149545&action=edit
autofilter edit matrix formula
steps to reproduce:
- open attached spreadsheet:
cell range "D3:D8" contains matrix formula {=C3:C8-B3:B8} and
autofilter hides some rows, cell C3 is selected
- press Ctrl+/ (/ from numeric pad) to select the matrix formula
- press F2 to edit the matrix formula
- change formula: =C3:C8-B3:B8+1 and press Shift+Ctrl+Enter
-> error msg: This function cannot be used with multiple selections.
seems like Ctrl+/ selects the view and not the data range:
MRI shows selection: "AbsoluteName string $Tabelle1.$D$3:$D$5"
btw: no problem if some rows are hidden manually without an autofilter applied
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
