[Libreoffice-ux-advise] [Bug 91820] Reorganization of the menu bar for Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=91820

--- Comment #13 from Eike Rathke <erack at redhat.com> ---
Coming back to this one..
(In reply to Cor Nouws from comment #12)
> > >   * Names Cells
> > >     * Was in the Insert menu as Names.
> > >     * The new name "Names Cells" doesn't make sense; if we change the
> > >       name then to "Named Expressions", but not to Names Cells.
> 
> @eike: why 'Named Expressions'? 

In the dialog you can name a cell area (range) but also enter a formula
expression. Within the dialog we use "range or formula expression" as
label for the edit field. A reference is a subexpression (can be used as
part of a formula), the unifying term for all you can enter there is
"named expression".


> > >     * It is very unfortunate to move the Tools' Protect Document menu
> > >       entry that had a submenu with Document and Sheet away from the
> > >       Tools menu AND split it up and scatter over two different menus
> > >       AND rename the entries. Imagine how confused users will be who
> > >       want to use the functionality. Already I was when I wanted to
> > >       unprotect a document..
> > 
> > Yes it would be a change for users who have already know where things have
> > been, but that is the case with any change. Better organized menus help both
> > old and new users.

I don't consider this situation to be better organized though..

> > So is it better for a user to find protect sheet under Tools > Protect
> > Document > Sheet or Sheet > Protect Sheet? Of course i would assume most
> > users would simply use the sheet tab context menu for this rather than
> > digging into menus.

You would be surprised how many users don't use context menus at all or
don't even know/recall it does exist and offers different choices for
different, well, contexts..

> > Should protecting the contents of a spreadsheet from being changed be
> > considered a tool or simply an edit function similar to tracking the changes
> > being make to a spreadsheet? The tools menu has been known to be a dumping
> > ground for functions that didnt seem to go into other menus rather than them
> > truly being tools.
> 
> The big disadvantage, mentioned by Eike too, is that now protecting is split
> over Sheet and Edit.

That's my point. It's not only a disadvantage, it makes working with the
UI a bad experience.

> For such a situation, using Tools makes sense maybe?
> Similar with Pivot Tables...
> Now we have Insert > Pivot Table and Data > Pivot Table > .. 
> Shrug.
> Maybe it's better to have that in Data, where it is now.

And also move all Protect actions there. At the end you want to protect
your data.

-- 
You are receiving this mail because:
You are on the CC list for the bug.