Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi Kohei,

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
expressions (ranges):

* 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
    
http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#__RefHeading__1017964_715980110

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.

  Eike

-- 
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

Attachment: pgpA55AfwRdvy.pgp
Description: PGP signature


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.