[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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
(In reply to Mike Kaganski from comment #4)
> The question is, if digit + space + decimal separator is a number

No, it's not a number and shouldn't be.

> Entering the "1 .1" (assuming dot as decimal separator) in the Calc's
> formula bar, it's obvious that Calc ignores the space here.

wtf.. I'd consider that a bug.

> The question is:
> is this expected? Does Calc consider the space thousand separator maybe (and
> allows in in wrong place)?

No, if the locale doesn't say the group separator is space then a space is not
ignored as such (and a group separator followed by a decimal separator is
invalid). But apparently the number parser tries to skip spaces at one too many
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/20200618/8a060854/attachment.htm>