I don't find how to use cell ranges with functions. I vainly searched some examples. I wrote the following test. I get "Object variable not set" error on both "for" lines (one is without "RangeA...

I'm trying to test some algorithms in LibreOffice Calc and I would like to have some global variables visible in all cell/sheets. I searched the Internet and all the posts I have seen are so crypti...

I am using LibreOffice 3.5.4.2. I would like to change the background color of cells based on various conditions. As a minimal example, I have the following macro/function defined: function bgcolo...