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