<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> changed <a class="bz_bug_link bz_status_NEW " title="NEW - Cannot concatenate number and space+dot from VBA macro" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131562">bug 131562</a> <table border="1" cellspacing="0" cellpadding="8"> <tr> <th>What</th> <th>Removed</th> <th>Added</th> </tr> <tr> <td style="text-align:right;">CC</td> <td> </td> <td>erack@redhat.com </td> </tr></table> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Cannot concatenate number and space+dot from VBA macro" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131562#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Cannot concatenate number and space+dot from VBA macro" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131562">bug 131562</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>(In reply to Mike Kaganski from <a href="show_bug.cgi?id=131562#c4">comment #4</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>