Bug 122681 - LineStyle can't be read and set using VBA
Summary: LineStyle can't be read and set using VBA
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2019-01-12 21:10 UTC by Gunnar
Modified: 2022-04-11 11:03 UTC (History)
2 users (show)

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

test file (7.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-10 05:25 UTC, raal
Help About LibreOffice (155.19 KB, image/png)
2022-04-11 11:03 UTC, Gunnar

Note You need to log in before you can comment on or make changes to this bug.
Description Gunnar 2019-01-12 21:10:58 UTC
Formatting a worksheet using VBA fails when using the LineStyle property.
Whatever linestyle, reading the property always return the value 1.
Setting the property doesn't change the linestyle.
Example: Range("B2").Borders(xlEdgeBottom).LineStyle = xlContinuous
Comment 2 raal 2019-01-13 09:33:18 UTC

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
Thank you
Comment 3 QA Administrators 2020-02-26 02:47:07 UTC Comment hidden (obsolete)
Comment 4 Gunnar 2020-02-26 12:04:15 UTC
Try this code (nothing happens):

sub Test
	Range("B2:C4").Borders(xlEdgeBottom).LineStyle = xlContinuous
End Sub
Comment 5 QA Administrators 2020-02-27 02:46:42 UTC Comment hidden (obsolete)
Comment 6 raal 2020-04-10 05:25:58 UTC
Created attachment 159463 [details]
test file
Comment 7 raal 2020-04-10 05:28:52 UTC
confirm with Version:
Build ID: 95dbfd517240666e5b9a9fd7ac1d47d799235a62
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Comment 8 QA Administrators 2022-04-11 03:31:09 UTC Comment hidden (obsolete)
Comment 9 Gunnar 2022-04-11 11:03:54 UTC
Created attachment 179456 [details]
Help About LibreOffice

The bug is not fixed