Styling cells with macro

Question

I'm new with OO Calc macros. With this code I can style cells on F13:F16 range

REM  *****  BASIC  *****
Option Explicit

Sub Main
oDoc = ThisComponent
osheets = odoc.getSheets()
osheet = osheets.getByIndex(0)
oCells = oSheet.getCellRangeByName("F13:F16")
NewBorder = oCells.BottomBorder
NewBorder.OuterLineWidth = 3
oCells.BottomBorder = NewBorder
End Sub

How can I edit this code so I can style cells I currently selected with mouse, instead of specifying them in the code?

Jim K · Accepted Answer · 2022-06-22 12:19:01Z

0

Working with selected cells is a bit complex because either a single cell, a cell range, or multiple cell ranges may be selected.

Code that handles all of these possibilities is explained in the essential Andrew's Macro Document under section 6.5.1. Simple example processing selected cells.

answered Jun 22, 2022 at 12:19

Jim K

14.1k2 gold badges26 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

H3coder Over a year ago

Jim is referring to the link at the very top of the URL he sent. Andrew Pitonyak also has a complete book link further down below called "OpenOffice.org Macros Explained.odt V4". In that book, the reference chapter is 15.8.1. Selected cells.

Collectives™ on Stack Overflow

Styling cells with macro

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related