<br>Hello Christoph,<br><div class="gmail_quote">2011/6/30 Christoph Noack <span dir="ltr"><<a href="mailto:christoph@dogmatux.com">christoph@dogmatux.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi Markus!<br>
<br>
Thanks for your mail ... I quickly had a look at it and got stuck within<br>
the dialog. So the Navigator has to wait a bit :-)<br>
<br>
Am Dienstag, den 28.06.2011, 21:28 +0200 schrieb Markus Mohrhard:<br>
<div class="im">> Hello Christoph,<br>
><br>
> we added local range names as a new feature for 3.4 and are trying to<br>
> get rid of all bugs for 3.5.<br>
<br>
</div>So, where to start? I had a look at the "Define Names" dialog and -<br>
besides the fact that I was able to add some local range names - found<br>
the following issues:<br>
* broken natural workflow: if an area is selected, and if the<br>
"Define Names" dialog is opened, and the "Scope" is changed,<br>
then it drops the "Assigned to" and Name entries --> so if<br>
people want to add a local range name, they have to enter it<br>
after opening the dialog<br></blockquote><div> </div><div>Ok, will add this to fdo#38565<br><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
* the scope dropdown lists "Document (Global)" - so the user has<br>
to guess that the other items are meant to be "(Local)"<br></blockquote><div><br>This is nearly the same behaviour as in Excel and I think after the entry Global I wouldn't expect any more global entries. But if you propose a better naming scheme I will change it.<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
* The name "Scope" is technically correct (computer science) but<br>
might be misleading for users. It (I presume this) acts both as<br>
a filter (to filter the name selection) and a selector (create<br>
global / local ranges).<br></blockquote><div><br>Same as above. I can live with this name but wea re able to change it if you make a better suggestion.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
* the naming "Assigned to" is now affected as well - since it<br>
might also refer to the table the range is defined in (but I'm<br>
not a native English speaker, so I might simply not know ...)<br>
* the new item "Scope" uses different grouping and is not aligned<br>
with the other controls in the dialog<br>
* Technical question: Is it intended that I can create a local<br>
range (e.g. on Sheet1) by referring to another table (e.g.<br>
Sheet3)?<br></blockquote><div><br>Yes. The idea is that you can create a name that refers to any range but the name is only visible to this sheet. Some nice results are for example: You have a global name that refers to a range and only on one sheet you have a local name with the same name. Now only on this sheet you refer to a different range but your formulas are exactly the same.<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I think most of the stuff can be revised easily ... I just don't know<br>
how ;-) I'm still thinking about it and had a look how recent versions<br>
of MSO handle that. A bit different, so to say. But, they use the term<br>
"Scope" - a bit surprising to me.<br></blockquote><div><br>I think MSO just started to use local range names too. So I think we don't need to keep that much of compatibility there, but I might be wrong here.<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Is there any description available (non-code) that summarizes how our<br>
new dialog is intended to work? Maybe I just stumbled across weird bugs,<br>
so I don't know what's intended and what not.<br></blockquote><div><br>Except for the limited scope, local and global range names should work the same way. The only minor difference is that local range names have a higher priority than global range names. All other difference I can imagine now are bugs or just not yet implemented but I would like to reach the point where there is no difference any more.<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Would be great if you could shed some light on it! After knowing more,<br>
it should be easy to discuss the Navigator issue.<br>
<br>
Have nice evening,<br>
<font color="#888888">Christoph<br>
</font><div><div></div><div class="h5"><br></div></div></blockquote><div><br>So just add every bug or change you would like to see in this area to my nice bug <a href="https://bugs.freedesktop.org/show_bug.cgi?id=38565">https://bugs.freedesktop.org/show_bug.cgi?id=38565</a> . Every notice in a mail gets lost with the time but I will close the bug only if i think that all issues mentioned are resolved ;)<br>
<br>Markus<br></div></div>