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@lists.freedesktop.org
Reporter: libreoff...@nisz.hu
CC: nem...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
