[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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ming.v.hua at qq.com

--- Comment #2 from Ming Hua <ming.v.hua at qq.com> ---
(In reply to Uwe Auer from comment #1)
> (In reply to Sebastien COGEZ from comment #0)
> 
> > When I put ="("&-9&")" in a cell, which can be a number value with a special
> > notation, I can't use this value as a number.
> 
> I won't expect that to work: ="("&-9&")" is a text and from my perspective
> you correctly get a "Wrong data type" error.
I concur.  The old behavior seems wrong and I consider the change of behavior a
bugfix rather than a regression.

> If you want numbers appear the
> way you did through formula ="("&-9&")", use cell formats (e.g in your case:
> format code: "(0.##);(-0.##)" or similar).
In addition, if you would like more automation, there is the TEXT() function.

-- 
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/20210316/190e9770/attachment-0001.htm>