https://bugs.freedesktop.org/show_bug.cgi?id=67394
Priority: medium
Bug ID: 67394
Assignee: [email protected]
Summary: Macros: csng and cdbl does not convert negative
exponent numbers
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: BASIC
Product: LibreOffice
Problem description:
csng and cdbl return Error 13 if the number has negative exponent.
Tested on Ukrainian and USA standards/interface
Steps to reproduce:
1. Open LibreOffice Calc and it's IDE
2. Paste the following example. The following comments shows current answers:
Sub Example
Print val("-3.14e2") '-314
Print val("-3.14e-2") '-3,14E-02
Print cdbl("-3,14e2") '-314
Print cdbl("-3,14E-2") 'Inadmissible value or data type.
'Data type mismatch
End Sub
3. Replace all commas by Your local decimal separator. It is very important!
4. Run it
Current behavior:
The answers are shown in comments:
-314
-3,14E-02
-314
Inadmissible value or data type. Data type mismatch
Expected behavior:
-314
-3,14E-02
-314
-3,14E-02
The LibreOffice forum contains thread:
en.libreofficeforum.org/node/5702
The proposed workaround is to use val. It works only on point separated numbers
so it cannot be used on localized numbers.
With best regards.
Viktor.
Operating System: Ubuntu
Version: 4.1.0.4 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
