https://bugs.documentfoundation.org/show_bug.cgi?id=113896
Kevin Suo <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |[email protected]
Resolution|--- |WORKSFORME
--- Comment #3 from Kevin Suo <[email protected]> ---
There is an option in:
Tools - Options - LibreOffice Calc - General - Expand reference when new
columns/rows are inserted.
Check is option and then try the steps in your original bug report, it works
perfect.
That option is not checked by default, because when it is checked, the formula
may change (expand) if new columns/rows are inserted, thus it's dangerous at
some point - only enable this option when you know what you are doing.
Close as WORKSFORME.
--
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
