Bug 40019 - Editing: Named Cellmatrices are no more recognized as reference
Summary: Editing: Named Cellmatrices are no more recognized as reference
Status: RESOLVED DUPLICATE of bug 39333
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.2 release
Hardware: Other Windows (All)
: high major
Assignee: Not Assigned
Depends on:
Reported: 2011-08-11 09:33 UTC by Ulrich.HB.Wittmann
Modified: 2011-08-12 09:09 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Ulrich.HB.Wittmann 2011-08-11 09:33:05 UTC
In LibO Calc 3.3 it was possible to name a cluster of cells, say C2:E5, and use it as a reference in a formula. E.g., if C2:E5 is named "Totals", this reference can be used in =SUM(Totals) instead of SUM(C2:E5).

In LibO 3.4.2 this feature does not work anymore. It returns an error with "#NAME?"

3.4.2 is supposed to be a functional stable version. This is bad and will turn off many people.
Comment 1 Markus Mohrhard 2011-08-11 19:24:06 UTC
Sure that you don't mix it with database ranges which does not work in 3.4.2 but should work again in 3.4.3?

You'll find named ranges at Insert->Names->Define whereas database ranges are at Data->Define Range.
Comment 2 Markus Mohrhard 2011-08-12 09:09:48 UTC

*** This bug has been marked as a duplicate of bug 39333 ***