[Libreoffice-bugs] [Bug 118983] New: inserting columns will change global named ranges on different sheets

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118983
           Summary: inserting columns will change global named ranges on
                    different sheets
           Product: LibreOffice
           Version: 5.4.7.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 143810
  --> https://bugs.documentfoundation.org/attachment.cgi?id=143810&action=edit
namedranges_expand_ref_demo.ots

inserting columns on a sheet will extend global named ranges defined 
on other sheets, if option:
LibreOffice Calc/General
[x] Expand references when new columns/rows are inserted

is enabled.

this does not happen with LO 4.4.7.2/AOO 4.1.5.

steps to reproduce:
- open attached spreadsheet
- check named range "TEST" - it will point to $Test.$A$3:$D$7
- select [InsertColumns with ExpandReferences enabled]
  (the macro will insert 3 columns at named range B_X and copy
   range B_CPY into the inserted ranges.)
- check namedrange "TEST" - it will now point to $Test.$A$3:$G$7

i would expect, that inserting columns on sheet "Demo" will not
change named ranges on other sheets.

steps to reproduce with ExpandReference disabled:
- open attached spreadsheet
- check named range "TEST" - it will point to $Test.$A$3:$D$7
- select [InsertColumns with ExpandReferences disabled]
- check namedrange "TEST" - it will still point to $Test.$A$3:$D$7

-- 
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/20180729/e7cc3482/attachment.html>