[Libreoffice-ux-advise] Sheet local range names in Navigator

[Christoph Noack]

Grrr, sorry for re-sending that - it seems that my "Ctrl+V" (incl. lazy
release of Ctrl) and the "Enter" afterwards led to sending the email.
So, next try ...

Hi Markus, hi Kohei!

Am Montag, den 04.07.2011, 01:47 +0200 schrieb Markus Mohrhard:
> Hello Christoph,
>         
>         
>         Could you please give me a hint what Excel version you are
>         referring to?
[...]
 
> I'm refering to Excel 2007.

For the record, here is some documentation how Excel handles that:

http://www.dummies.com/how-to/content/managing-range-names-in-excel-2007.html

http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007/0120__Formula/NameManagerFilterOptions.htm


> I think we separated adding and viewing
> too. For viewing we thought of Insert->Names-Insert and for defining
> Insert->Names->Define.

Well, it is a bit different ... the "Insert - Names - Insert" (what an
insane menu item) inserts a (list of) range name(s) into the worksheet.
As far as I know, that functionality isn't available in Excel. I'm
curious if it has been introduced, since Calc (today) lacks a good
overview what range names are within the document.

However, the main issue in our dialog is to make crystal clear:
      * if a range gets added by the user, where it will be added
        (scope)
      * if a range gets changed, how to keep a clear link between the
        range list and the cell range (e.g. if you change the cell range
        for a given range name, then the dialog lacks information
        whether the change has been applied - today the user has "to
        know".
      * what ranges are available within the document (--> this will
        also help to solve the Navigator issue we've started with)
      * how to take care of print ranges etc.

By the way, it can be seen that the Microsoft team also did not find a
really good solution. It seems that adding/editing the full range is
done via a separate (small) dialog - but there is another range input
line in the name manager (incl. Checkmark / Cross) buttons. A bit
awkward, isn't it?

> I know that the insert dialog is not perfect yet, for example in my
> opinion it misses the information which range is the target of a range
> name, but these are some improvements for the future.

Sorry, I don't (fully) get that ... could you please provide an example?

[...]

And Kohei, could you please explain what of the today's functionality
might be changed / dropped - are you aware of any non-use? There are a
lot of options in the dialog ...

Cheers,
Christoph