[Libreoffice-bugs] [Bug 141057] New: Calc : can't operate number text as "("&-9&")" and a number
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Tue Mar 16 09:14:56 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=141057
Bug ID: 141057
Summary: Calc : can't operate number text as "("&-9&")" and a
number
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: sebastien.cogez at ac-montpellier.fr
Description:
Hello,
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.
It worked with anterior versions of LibreOffice, so, I think thats a bug.
Steps to Reproduce:
1. in A1 cell ="("&-9&")"
2. in B1 cell =A1+3
Actual Results:
#VALUE! result
Expected Results:
-6
Reproducible: Always
User Profile Reset: No
Additional Info:
Version : 6.4.7.2 (x64)
Build ID : 639b8ac485750d5696d7590a72ef1b496725cfb5
Threads CPU : 8; OS : Windows 10.0 Build 19042; UI Render : par défaut; VCL:
win;
Locale : fr-FR (fr_FR); Langue IHM : fr-FR
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/31c3329b/attachment.htm>
More information about the Libreoffice-bugs
mailing list