[Libreoffice-ux-advise] Merging Calc's label range functionality with named range.

pierre-yves.samyn at laposte.net pierre-yves.samyn at laposte.net
Thu Jul 25 02:57:17 PDT 2013

Hello All

> Message du 23/07/13 19:46
> And the original goal of my post was to figure out whether there are 
> people who use it, and if yes, what proportion of users (roughly), and 
> whether or not their use cases could be possibly fulfilled by either 
> named ranges or database ranges. Somehow I'm not getting any feedback 
> on that front.

I do user support and training for (thirty) years.
I've never met one user of this feature.

However, and this goes against the opinions already given, 
I found that the "automatic find label" option *is* used.

Two concrete use cases (where the find label option has an advantage 
over "named ranges"):

1. Managing the expansion of the range.

The formula =SUM('Sales'), where 'Sales' is the header column, 
will update if you add amounts. To achieve the same result with 
a "named range" you must either use a "dynamic" name (calculated) 
or plan ahead more than is actually filled range.

2. Adaptation of References

A table with two columns: "purchases" (column A) and "sales" (column B)
C1 =SUM('Purchase')
Copy C1 to D1 provides automatically =SUM('Sales') in D1

This can not be obtained directly if "Purchase" is a named range
(and if the "find label option" is deleted/disabled).

Do not get me wrong: I do not defend at all costs to maintain 
this feature. I only see it is used and benefits.

Thank Kohei for all its improvements and optimization research.

Best regards

Une messagerie gratuite, garantie à vie et des services en plus, ça vous tente ?
Je crée ma boîte mail www.laposte.net

More information about the LibreOffice mailing list