https://bugs.documentfoundation.org/show_bug.cgi?id=141057
Ming Hua <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #2 from Ming Hua <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
