[Libreoffice-bugs] [Bug 122394] New: changing named ranges content via vba macro will not update cell formula

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122394
           Summary: changing named ranges content via vba macro will not
                    update cell formula
           Product: LibreOffice
           Version: 6.1.4.2 release
          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 147909
  --> https://bugs.documentfoundation.org/attachment.cgi?id=147909&action=edit
test vlookup changed range vba

i noticed the problem while investigating issue
https://bugs.documentfoundation.org/show_bug.cgi?id=122378

- open attached "test_vlookup_changed_range_vba.ods"
- press button
- named range "Region" content is changed via:
  ThisWorkbook.Names("Region").RefersTo = "=Sheet1!$A$9:$B$11"
- but vlookup formula's in A2:A4 will not update
- a full hard recalc will not work
- the document keeps unmodifed

- to force a recalc, e.g. cell A2
  - select A2
  - press F2
  - press space
  - enter

btw.:
the problem does not happen if named ranges content is changed via lo api,
see "test_vlookup_changed_range.ods"

-- 
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/20181231/204c94c1/attachment.html>