[Libreoffice-bugs] [Bug 131562] Cannot concatenate number and space+dot from VBA macro

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to himajin100000 from comment #2)
> * "1." is valid string that can be converted to number
> 
> * assigning to cells evaluates the string "1.", and if the string is a
> number, then the cell value is set to that number. In this case, namely 1
> 
> * if the cell formats for the cells are set to Text instead of Number before
> the script is run, you will see the expected results when your code is run.

The question is, if digit + space + decimal separator is a number, just as
digit plus decimal separator. By the way, in case of e.g. ru-RU locale, it's
space plus comma that wouldn't work here.

Entering the "1 .1" (assuming dot as decimal separator) in the Calc's formula
bar, it's obvious that Calc ignores the space here. The question is: is this
expected? Does Calc consider the space thousand separator maybe (and allows in
in wrong place)?

-- 
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/20200616/1a912744/attachment-0001.htm>