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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131562
           Summary: Cannot concatenate number and space+dot from VBA macro
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org
            Blocks: 108908

Created attachment 158973
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158973&action=edit
Example file from Excel

Attached file contains a simple macro to concatenate a number in cell plus a “
.” (space dot) sequence.

This call (with m1 being a loop variable) does not work in Calc:

Cells(3, m1) = m1 & " ."

However if some more characters are added to the concatenation, it works:

Cells(4, m1) = m1 & " .cat"

Using only a dot does not work in Excel either, and using only spaces works in
Calc too.

Steps to reproduce:
1.      Open attached xlsm file
2.      Run the macro in Excel and Calc

Actual results:
In the third row Excel concatenates the number and the space-dot sequence, Calc
does not.
In the fourth row the concatenation works as expected.

Expected results:
Calc concatenates a space and dot to the numbers in row 3.

LibreOffice details:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: bc898e2c2784e36ad4d4cdf6d962e39069d2c82d
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

Also in:
LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
[Bug 108908] [META] Visual Basic for Applications (VBA) macro issues
-- 
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/20200325/e8803946/attachment.htm>