Libreoffice Calc Macro - How to capture selected ranges

Asked

Viewed 76 times

0

I am creating a macro in Libreoffice Calc and need a way to select some non-consecutive cell ranges, and capture which are these selected ranges. For example, I want to select the ranges "A1:A10", "C5:C13", "H7:H9" and be able to capture these three strings, so I can apply some action where I selected. I already created the macro below, so I can make a "replace" in the selected cells, but it only works in a single interval. I appreciate any hint.

https://pastebin.com/4BtGjuVc

2 answers

1


0

Calc does not select multliplas selections, make 3 macros. and interlink them.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.