Merging Calc's label range functionality with named range.

Kohei Yoshida kohei.yoshida at suse.de
Wed Jul 17 17:29:06 PDT 2013


Hi there,

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.

What the label ranges provide can be pretty much achieved by named 
ranges, and with named ranges you can do much much more. The UI for 
label ranges is very clunky, unattractive, and hard to use.  Rather than 
trying to maintain and improve this almost duplicated functionality, we 
should just drop it and encourage users to use named ranges instead.  
Dropping this functionality would also help clean up the implementation 
and make it easier for us to improve the formula engine going forward. 
So, I would passionately love to see that happensince the presence of 
this functionality currently is making it harder to maintain the formula 
engine code, much less improve it.

Excel also had similar functionality but dropped it in Excel 2007, and 
steered the users toward using named ranges. So, there is no concerns 
with regard to interoperabilityeither.

Best,

Kohei

-- 
Kohei Yoshida, LibreOffice Calc hacker, SUSE.



More information about the LibreOffice mailing list