Since 3.6. there is in Calc Insert fields .. in the context menu, but only in Editing mode. IMO it would be good to allow the same action when a cell is Selected. Opinions?
initial commit: http://cgit.freedesktop.org/libreoffice/core/commit/?id=d6d4d00114e267142145f0d6bb80a66dd4bca990 thanks cloph!
For me this sounds good. I see no reason why it should not be available at this stage, because probably many users do not know these functions in the Edit Mode or think that such functions could be available in the Edit Mode. And comments can also be inserted in the context menu. The current way that is only selectable in the Edit Mode seems for me to be not very intuitive.
As inserting fields isnt a regularly used function, having it in every selection mode context menu wouldnt be useful IMHO. It would be useful to have those insert field options in the Insert menu, where it is missing.
(In reply to Jay Philips from comment #3) > As inserting fields isnt a regularly used function, having it in every > selection mode context menu wouldnt be useful IMHO. It would be useful to > have those insert field options in the Insert menu, where it is missing. To insert these fields in the INSERT menu would be a very good and even better solution, because I agree that these inserting fields are not regularly used (not only because maybe many are not aware of them). Therefore, I would agree to Jay's proposal, that it would be good to add these fields options to the INSERT menu. Thanks, Jay, for your feedback! @Cor: What do you think about this?
We're replacing our use of the 'ux-advise' component with a keyword: Component -> LibreOffice Add Keyword: needsUXEval [NinjaEdit]
What is the use case? "...would be good..." is not good. Guess you have consistency and detectability of functions in mind. What should happen when the field contains data? Guess it should be overridden. What happens in case of multi selection? Maybe disable the function. Why is this type of interaction needed anyway since Calc works with functions. For instance it could be =INFO("SheetName"). (OT: Put this onto the agenda for the design meeting.)
(In reply to A (Andy) from comment #4) > To insert these fields in the INSERT menu would be a very good and even > better solution, because I agree that these inserting fields are not > regularly used (not only because maybe many are not aware of them). > Therefore, I would agree to Jay's proposal, that it would be good to add > these fields options to the INSERT menu. Thanks, Jay, for your feedback! > > @Cor: What do you think about this? fine for me too
The topic has been discussed in the design meeting with the decision to resolve it as wontfix. One argument is that context menus are cluttered right now. The other issue is the unclear situation when multiple cells are selected. Unfortunately we are restricted to ODF and cannot introduce the "=INFO()" solution.
Insert fields added to Insert menu https://gerrit.libreoffice.org/#/c/41953/