https://bugs.freedesktop.org/show_bug.cgi?id=41915
Christoph <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |christoph.spamforme@dogmatu | |x.com --- Comment #14 from Christoph <[email protected]> 2011-11-06 15:20:04 PST --- (In reply to comment #13) > I'm not sure that this is really a bug. The feature correctly is called "Named > Expression" because can not only assign ranges to them but also formula parts. > The question is if it really makes sense to highlight named expressions. Thank you, Markus. I think the feature would work much better if ... If the formula contains a named expression, then ... * If the named expression is a named range, then highlight the named range both in the formula (color coding) and the document (boundary around cells). * If the named expression is a named formula, then don't use highlighting. (Note: In future version we might be more clever and show the formula via e.g. a tool tip) I think the hardest part is that the normal cell ranges that get highlighted get a small "handle" in the lower right, so that the user can easily resize the cell range. I assume that this is close to impossible for Named Ranges, so that we need to omit that "handle" ... or think about a clever substitute. However, although we might not offer everything, I think that the description (if case) above might already help a lot for the default use case of naming cell ranges. But, I might not be aware of any side issues like "Tools - Detective". Furhtermore, I assumed that Calc can correctly differentate between real cell references and named ranges (please see the last paragraph of comment #0). Hope this helps. Christoph -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
