[Libreoffice-ux-advise] [Bug 116261] CALC FORMATTING changing the format of some characters of a text cell (interpreted as formula?)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needsUXEval
                 CC|                            |erack at redhat.com,
                   |                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org,
                   |                            |stephane.guillou at libreoffic
                   |                            |e.org

--- Comment #12 from Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> ---
reproduced in recent master build:

Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: f4c24da1e7f11664e0d2f688d2531f068e4a3bc0
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

However, as you assumed correctly, this is due the contents of the cell being
understood as a formula ("=" is usually used, but "+" and "-" can also do
that).

It is true that it is awkward that the formatting can be kept until the
"formula" is modified.
It is also possible to format a formula starting with "=", but it shouldn't be
visible when finished editing because it usually displays the results (or an
error).

Eike an UX team, kind of related to the confusion in bug 132026 and bug 129369,
there's the bigger question: why doesn't a formula that starts with +/- behave
more like a formula starting with "=", i.e. either giving the result of the
formula or errorring if it's invalid?

-- 
You are receiving this mail because:
You are on the CC list for the bug.