[Libreoffice-bugs] [Bug 123662] New: EDITING: matrix formula fails if filter is applied

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: oliver.brinzing at gmx.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190223/26c677ab/attachment.html>