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

[Christoph Noack]

Hi Christoph (that's me), all the others!

Just some correction to some statements I've made below ... I had the
chance to check with Excel 2007 today.

It is indeed possible to "Paste Names..." in Excel 2007 - this equals
our "Insert". What I totally do not understand is the location of this
entry - it is part of the "Use in Formula" menu. Weird.

Another thing I've noticed - the filter in the Name Manager doesn't
provide any feedback if the filter is activated. The content is just
filter and that's it ... weird #2.

So, I think we can do better ...

Sadly, I will be on a (likely to be exhausting) business trip tomorrow,
so I won't be able to contribute anything to Calc (Markus, André, Kohei)
or Writer (Cedric, Cor) for another one or two days. Sorry for that!

Cheers,
Christoph


Am Sonntag, den 10.07.2011, 22:28 +0200 schrieb 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
> 
> _______________________________________________
> Libreoffice-ux-advise mailing list
> Libreoffice-ux-advise at lists.freedesktop.org
> http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise