In a Calc Basic Macro how do I pass a named Formula as a parameter

[MikeMcClain46]

mike@RPI4b3:~> uname -a
Linux MikesPI 6.1.0-rpi7-rpi-v8 #1 SMP PREEMPT Debian 1:6.1.63-1+rpt1 (2023-11-24) aarch64 GNU/Linux

Version: 7.4.7.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: x11
Locale: en-US (C); UI: en-US
Raspbian package version: 4:7.4.7-1+rpi1+deb12u8
Calc: threaded

In a Calc Basic Macro how do I pass a named Formula as a parameter?
I can create a named formula but when trying to pass it to another macro to assign to a cells formula I either get plain text or nothing, or sometimes just ‘=’.
Pointers would be appreciated.
Thanks,
Mike

[Zizi64]

@MikeMcClain46

In a Calc Basic Macro how do I pass a named Formula as a parameter?

Do you want to pass the result of a Named Formula, or you want to call the Named Formula from a Starbasic Macro?

How to call LO Calc functions from a LO Basic function (macro)?

If you already have a cell object you can check for the properties .Type and .FormulaResultType. If you passed a cell reference to the formula in Calc and your user function does not specify a type for the respective parameter, the parameter gives access to a Variant variable which you can can ask for its actual type with the help of the Basic function TypeName(). Any subroutine (even running for a non-Calc compoinent) can create a service for calling Calc functions. To call a function you ne…

[MikeMcClain46]

Good morning Mr. Kovacs.
I can pass a formula string to a routine to set the formula of a range of cells but my thinking is, and I may be wrong, that if I pass a named formula, when it comes time to update that formula, I’ll only have to update the named formula content which will be echoed to all cells whose formula contains that named formula.
Therefore it is the named formula I wish to pass to another routine.
If I’m headed in the wrong direction feel free to point that out, I’m still learning named formulas/ranges and have a way to go. So far I’ve not found a discussion of the various ways to use such, only bits and pieces here and there, mostly related to named ranges.
If you call it a “Starbasic Macro” you’ve been doing this for a while. I’ve just recently started to try to use named formulas and not yet tried to use a named range though I’ve a few columns in my spreadsheet where they might be used if I understood how to use them.

Be Well,
Mike

[Zizi64]

@MikeMcClain46

you’ve been doing this for a while

I often combine the “Macro routines/functions” and the “Standard cell functions”, and the “Named cell ranges”. But I never used the “Named expressions” in my tasks.

[Zizi64]

@MikeMcClain46

If you call it a “Starbasic Macro”

The letter “s” in the names “scalc.exe”, “swriter.exe”, “sdraw.exe”, “simpress.exe”, etc… was inherited from the StarOffice:

LibreOffice

[MikeMcClain46]

With a bit of exploring I’ve come up with this:
namedDemo.ods (12.8 KB)
which creates named ranges and formulas and applies them and then ends by changing the formula inside the named formula.

Enjoy,
Mike