[Libreoffice-bugs] [Bug 81295] Name Scope Handling is Incorrect

[bugzilla-daemon at bugs.documentfoundation.org]

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

Albrecht Müller <albrecht.mueller at astrail.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|NOTABUG                     |---
     Ever confirmed|0                           |1

--- Comment #5 from Albrecht Müller <albrecht.mueller at astrail.de> ---
So the problem is still there and I am not the only one who fell into this
trap.
I think an important part of this problem is that by checking Tools > Options >
LO Calc > Calculate, "Automatically find column and row labels" you allow
LibreOffice to silently apply persistent changes to the semantics of your
formulas.

This behaviour comes quite unexpected as searching usually is thought to be
non-destructive. Therefore from a users point of view this behaviour may cause
many sorts of trouble as correct formulas are lost and spreadsheets will
deliver wrong results.

When you turn on this option you get no warning that alerts you to this
problem. The help information contains no hint either. I don't know the default
value of this option but I think this feature should be off by default and
should issue a warning if you turn it on.

Maybe changing the implementation of this option such that is actually does a
"find" only and not an unexpected "find & replace" would be a better solution.

-- 
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/20200121/bf2a98d9/attachment-0001.htm>