[Libreoffice-bugs] [Bug 113896] EDITING: Formula should be extended to a newly inserted row/ column

[bugzilla-daemon at bugs.documentfoundation.org]

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

Kevin Suo <suokunlong at 126.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |suokunlong at 126.com
         Resolution|---                         |WORKSFORME

--- Comment #3 from Kevin Suo <suokunlong at 126.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171127/2997d842/attachment-0001.html>