Re: [libreoffice-users] Renaming a Calc range

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: users+unsubscribe@global.libreoffice.org
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