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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Jul 29 08:51:21 UTC 2018


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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #1 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
just noticed:

to reproduce *without* macro:
- open attached spreadsheet
- *enable* option:
  LibreOffice Calc/General
  [x] Expand references when new columns/rows are inserted
- select column headers E:G
- context menu "Insert columns left"
- check namedrange "TEST" - it will now point to $Test.$A$3:$G$7

btw: "B_CPY" will expand cause the inserting position
is at the edge of the range. this is correct.

-- 
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/29939c33/attachment.html>


More information about the Libreoffice-bugs mailing list