https://bugs.documentfoundation.org/show_bug.cgi?id=101583
GerardF <gerard.farg...@orange.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
CC| |gerard.farg...@orange.fr
Resolution|NOTABUG |---
Ever confirmed|0 |1
--- Comment #4 from GerardF <gerard.farg...@orange.fr> ---
(In reply to m.a.riosv from comment #1)
> I think you have enable the option:
> Menu/Tools/Options/LibreOffice calc/General - Expand references when new
> columns/rows are inserted.
> Disabling it works as you expect.
>
> Resolved as not a bug, please if you are not agree, reopen it.
Sorry, but I disagree with this.
With option unchecked, no change in named range. That's OK
With option checked, ranges must be expanded but not this way :
Insert column should expand named range *only if named range had 2 or more
columns*.
So Fruit_LUT sould expand to A7:C9, while Fruits (A7:A9, only une column)
should *not* be expended.
Same for insert row, only named range with several rows must be expended.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs