I ask so many noob questions, like an hobby. Here is a newer one.
I'm trying to make independent functions with help of macros.
For example, I'm trying to make a "=FILE PICKER()" formula.
And that's why I'm trying to figure out how to make a makro to give a cell's address where it is written.
I know that I can do this without a makro, this is something calc can do it self, but as I have mentionned, I will use this information for other makros.
Please excuse me if this is something simple and I could not find an answer in website.
Here below, is a pseudo code that I made up. It can write "address(row();column();4)" anywhere it is written. But gets written as string not as a formula.
Code: Select all
function thysformula()
thysformula= "=address(row();column();4)"
end function