While trying to format some string values to numbers using Format Subrutine i get strange result.
The code:
Code: Select all
Dim A as String
A = "1.1"
Dim B as String
B = Format(A, "0.0")
Print B
I tried on OpenOffice 3.2.0 and Apache OpenOffice 4.1.11. Same results.
On LibreOffice 7.0.6.2 runing the same code B = 11,0. Wrong too.
Meaby a bug?