Joe- Thanks for following up on this:
On 2025-10-25 14:31, Java Joe wrote:
I'm not qualified to explain why both Named Ranges and Database Ranges exist,
but I've used both of them extensively in some fairly complex spreadsheets.
If you have used both extensively, can you recall why you used Named Ranges? [I
have always named Database Ranges to have a way to refer to a table organizing
some data used by the spreadsheet operation, and can't think of any other
reason to name a table of data.]
I just did a quick test, and there is a relatively simple way to change the
name of a DatabaseRange; by using a Macro (Basic Code).
Enter the following subroutine in one of the document's Basic modules (create one if none exist), replace the
"WrongRange" and "CorrectName" text with what your range is currently named and what you
want it to be named (but retain the quotation marks), then execute it (F5). There is no visual indication
anything happened, but on my version 25.2.0.3 (Debian 12 OS) this does indeed rename the range, and
attempting to execute it a second time results in a "No Such Element" error.
``` Basic
Sub RenameDatabaseRange
ThisComponent.DatabaseRanges.getByName("WrongRange").setName("CorrectName")
End Sub
```
By itself, that does not change any references using "WrongRange", does it? - or any
sorts or filters using "WrongRange"? IOW, doesn't Regina's bug stand as filed on this?
This indicates that the ability to rename a range exists, it's just not
implemented in the GUI.
Beware that this code is for a Database Range, a Named Range is accessed in an
entirely different manner in Basic code.
Interesting.
Thanks, John
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
