[Libreoffice-bugs] [Bug 141050] New: CCur does not accept negative strings

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141050
           Summary: CCur does not accept negative strings
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: andreas.heinisch at yahoo.de

Description:
Consider the following code snippet from
https://ask.libreoffice.org/en/question/298480/can-function-ccurs-accept-negative-string-like-100/:

Sub Main

dim c as currency
c = CCur("100")
Print c ' result: 100
c = CCur("-100") ' result: Inadmissible value or data type. Data type mismatch.

End Sub

Steps to Reproduce:
Tools->Macros->Organize Macros->Basic
Copy the snippet and hit run.

Actual Results:
Inadmissible value or data type. Data type mismatch.

Expected Results:
The value of c should be -100.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 347878c717f317e6eb608ca242739fc9e6cc6d78
CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL

-- 
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/20210315/c9d3e996/attachment.htm>