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


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@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise



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.