[Libreoffice-bugs] [Bug 134876] New: RECHERCHEV() parameters badly generated by formula editor

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134876

            Bug ID: 134876
           Summary: RECHERCHEV() parameters badly generated by formula
                    editor
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: david.vantyghem at infolib.re

Created attachment 163130
  --> https://bugs.documentfoundation.org/attachment.cgi?id=163130&action=edit
The formula editor

I use formula editor to create a RECHERCHEV() formula.
In the formula, the editor doesn't add $ in the matrix.
Example :

It would be better to write 
=RECHERCHEV(A8;$Feuille2.$A$1:$B$40;2;0) instead of 
=RECHERCHEV(A8;$Feuille2.A1:B40;2;0)
because after, when you copy-paste the formula in other cases, the range A1:B40
becomes A2:B41, A3:B42... instead of staying A1:B40

Could you modify the formula editor in order to add $ in the matrix ?

-- 
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/20200716/38058ecb/attachment.htm>