Merging Calc's label range functionality with named range.
erack at redhat.com
Thu Jul 18 05:09:31 PDT 2013
On Wednesday, 2013-07-17 20:29:06 -0400, Kohei Yoshida wrote:
> I'd like to merge Calc's label range functionality (which you can
> find in the menu at Insert - Names - Labels) with named range
> functionality. The named range functionality is found at Insert -
> Names - Define/Manage/Insert. Also, the Create menu item in the same
> menu sub-tree is also a part of the named range functionality.Here,
> what I basically mean by "merging" is to remove this functionality
> and provide some rudimentary mapping to the named range when
> importing legacy documents that use this functionality.
As I see it the Label functionality currently can't be replaced by named
* The actual label name displayed is taken from a cell's content,
formula expressions using a label automatically change their display
label names whenever that cell content is changed.
* This is not possible with named ranges.
* One label names exactly one row or one column, expressions or
multi-column/row ranges are not possible.
* The named expressions dialog could restrict that though.
* The label name can include spaces and other arbitrary characters that
in a formula expression would have special meanings, using such a name
in an expression is possible by enclosing the entire label name in
single quotes. A label name can even be a string that otherwise would
be a cell reference.
* A named range currently has to consist of alphanumeric+underscore
characters and can't resemble a cell reference.
* ODFF does provide means to store usage of such non-simple names
though with $$SingleQuoted but we need to implement that in the
formula compiler (anyway), see
Furthermore we probably could use exactly the Label functionality for
the GSoC "Enhanced Database Ranges" Table feature when it comes to
in-Table formula expressions adressing the Table's rows or columns.
Actually it would be necessary to support identical label names for
different Tables (ranges) within one sheet, again this is not possible
with named ranges.
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key ID: 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A
For key transition see http://erack.de/key-transition-2013-01-10.txt.asc
Support the FSFE, care about Free Software! https://fsfe.org/support/?erack
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 836 bytes
Desc: not available
More information about the LibreOffice