Re: [libreoffice-users] Renaming a Calc range

Hi Regina,

On 2025-10-24 17:35, Regina Henschel wrote:
> Waltr schrieb am 24.10.2025 um 19:18:
> > . . .
> > If it's in a spreadsheet sheet, you can rename the ranges used there by going to Sheet tab, 
> > dropping down to
> >
> > Named Ranges and Expressions...Manage as Mike suggested.
>
> The question was not about menu Sheet > Named Ranges and Expressions but about menu Data > Define Range. "Named Range" 
> and "Database Range" are two very different kind of "ranges".

This is an extremely important point, because it is fundamental yet not well known to people who have used OO/LO Calc 
for years. Since starting this thread (in complete ignorance of this point), I have been trying to understand the 
motivation for, and use of, "Named Ranges" (as opposed to "Database Ranges") - even why they are 
managed via the Insert and Sheet menus rather than the Data menu - and I'm still struggling with that. I don't find 
this distinction clarified by either the Calc Guide or Calc Help. At least the Navigator collects both entity types; 
otherwise they seem to have no connection. Johnny Rosenberg's post distills my confusion, showing how even the most 
experienced and conscientious user can be confused.

Thanks for your constant, patient help,
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