Bug 122681 - LineStyle can't be read and set using VBA
Summary: LineStyle can't be read and set using VBA
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2019-01-12 21:10 UTC by Gunnar
Modified: 2019-08-29 21:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

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
Hello,

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?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you