Trying to get a clear understanding of namedRange and namedFunction by reading ask.LibreOffice questions and answers is like assembling a puzzle missing pieces.
Is there some place a discussion giving a more complete definition of these things and their general uses?
In general looking at their methods in Xray really tells me what it’s called but not what the method does nor how it’s used. Likewise, I don’t always understand the implications of their properties.
Any help will be appreciated.
Mike
represents a named range in a spreadsheet document.
In fact a named range is a named formula expression. A cell range address is one possible content of a named range.
What do you mean by namedFunction?
I meant named formula . As I say, I’m confused.
Sub AddNamedFunction()
’ from OOME 4
’ Listing 447. Create the AddLeft named range.
In the narrow sense, a named range is a fully absolute reference. When you selected A1:B12 on Sheet1, absolute $Sheet1.$A$1:$B$12 is what you get automatically when you type a valid name into the name box left of the formula bar.
However, anything you can enter into a cell can be a “named range”, therefore “named formula” would be a better term.
- a constant number or text
- a formula with absolute, relative and mixed references
Demo:
ask123464.ods (26.6 KB)
Sir I appreciate that you’re trying to help but there is not a macro anywhere that I could see. My guess is that you did all that through the menus in Calc though I admit to not knowing how and haven’t a clue what FORMULA(I3) is.
Maybe I wasn’t clear initially so I’ll ask if you know where I might find a document explaining how to create and use named ranges and formulas in basic macros.
Thanks again for trying.
Be well,
Mike
The Named Ranges and Expressions are not related to the macros directly. It is a feature of the Calc application. Of course you can handle the Named Ranges by you macros. For example you can get the referred cell range by your macro, and yo can get the values from the referred cells.
where I might find a document explaining how to create and use named ranges and formulas in basic macros.
I suggest you to download and study Andrew Pitonyak’s free macro books:
“In a macro, a named range is accessed, created, and deleted using the NamedRanges property of a Calc document. Use the methods hasByName(name) and getByName(name) to verify and retrieve a named range. The method getElementNames() returns an array containing the names of all named ranges. The NamedRanges object supports the method addNewByname, which accepts four arguments; the name, content, position, and type.”
https://www.pitonyak.org/database/
https://www.pitonyak.org/database/Calc_As_A_Simple_Database.odt
and:
https://www.pitonyak.org/oo.php
and:
https://forum.openoffice.org/en/forum/viewtopic.php?t=75811