[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

--- Comment #1 from Uwe Auer <uwe at franke-auer.de> ---
(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. 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).

However: "yes" - the construct worked in 5.4.7.2, 6.2.8.2, 6.3.6.2 and does
*not* work in: 

repro 

Version: 6.4.7.2
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

repro

Version: 7.0.5.2
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

repro

Version: 7.1.1.2 / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

-- 
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/04e39cc3/attachment.htm>