Bug 131555 - Cannot set cell borders from VBA macro
Summary: Cannot set cell borders from VBA macro
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2020-03-25 08:07 UTC by NISZ LibreOffice Team
Modified: 2022-03-26 16:27 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Example file from Excel (11.01 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2020-03-25 08:07 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc after running the macro. (82.14 KB, image/png)
2020-03-25 08:08 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-03-25 08:07:22 UTC
Created attachment 158969 [details]
Example file from Excel

Attached file contains a simple macro to set cell borders.
This call does not work in Calc:

Range("A3:B6").Borders.LineStyle = xlContinuous

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

Actual results:
In Excel the cells A3:B6 are filled with “Hello World” text and a border is set around them. In Calc the text appears but not the border.

Expected results:
Border is set for cells.

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 happens in
LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Comment 1 NISZ LibreOffice Team 2020-03-25 08:08:01 UTC
Created attachment 158970 [details]
Screenshot of the original document side by side in Excel and Calc after running the macro.
Comment 2 Xisco Faulí 2020-03-25 15:57:47 UTC
Reproduced in

Version: 7.0.0.0.alpha0+
Build ID: 9163755e9f64a0b1dd5f2090e0702c19e31c12c9
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 3 QA Administrators 2022-03-26 03:35:55 UTC Comment hidden (obsolete)
Comment 4 Roman Kuznetsov 2022-03-26 16:12:37 UTC
Still repro in

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 51fb84829afbc1c0957fd1a489085613ad199f1a
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL Jumbo