https://bugs.documentfoundation.org/show_bug.cgi?id=101583
GerardF <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
CC| |[email protected]
Resolution|NOTABUG |---
Ever confirmed|0 |1
--- Comment #4 from GerardF <[email protected]> ---
(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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
