[Libreoffice-bugs] [Bug 141057] Calc : can't operate number text as "("&-9&")" and a number

[bugzilla-daemon at bugs.documentfoundation.org]

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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #3 from m.a.riosv <miguelangelrv at libreoffice.org> ---
It assumes the '(9)' as a negative number so '(-9)' it is not a number, or it
is a double negative with different formats.

(9)     ="("&9&")"
-8      =+A1+1
-9      ="-9"
-8      =+A3+1

I think it's fine so.
And LibreOffice has become less permissive with strings considered as a number
over the time.

-- 
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/20210317/e38adf8e/attachment.htm>