Description: Right now comments are in a weird position as they work, but are sometimes awkward and not intuitive to use. The suggestions as listed below are thought to improve on problems I encountered through the years. Steps to Reproduce: None (feature request) Actual Results: Comments do not have those options and controls or are spread out into different places. Expected Results: The improvements on comments are expected to improve the working with them and making it more intuitive to use. (Intuition is of course a bit an arbitrary way of thinking) Reproducible: Always User Profile Reset: No Additional Info: For details on the suggestion please see the included files and explanations for them Version: 25.8.2.2 (X86_64) / LibreOffice Community Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f CPU threads: 12; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: de-AT (de_AT.UTF-8); UI: de-DE Flatpak Calc: threaded
Created attachment 203660 [details] CALC - feature request - cell comment UI suggestion A suggestion / design study on how the comment filed could look like. For details in changes see next file and description.
Created attachment 203661 [details] CALC - feature request - cell comment UI suggestion-description The description for the suggestion / design study: Layout: - The UI buttons are grouped by similarity, but spread out if they do something entirely different if clicked (eg. 'harmless' edit on the top right, but delete on the bottom right) - The UI button would have do visual description, but display a name and a description in a tooltip if you hover over it with you mouse - Old thing in a new place: So change for the sake of change, right? - No, not at all. Currently the options are found in more than one place making it harder to learn to use the feature for new users and time consuming for regular and power users. - Hotkeys would be wonderful to have (especially for power users) UI buttons: - always display comment: Does the same as the current right click option does and will always keep the comment displayed (nothing new, the old thing in a new position) - open edit mode: this would open the edit mode that you kinda enter when you right click the cell and click to constantly display the comment. The use is to make editing the comment easier without it closing on you. - copy comment: Something that I wanted to have for *years* is to be able to copy *just the comment* without the need to copy the entire cell. If you have modified the cell in any way (eg. size) you will know why "copy comment text and paste in comment of new cell" is not enough (text is only clear to separate it from the red text above) - delete comment: Does again the same as the current right click option does and will delete the comment (nothing new, the old thing in a new position) - lock comment: This will lock the comment from being modified. So if you clear the cell with 'Delete' the comment is kept. If you copy a call with a comment into the current cell, the comment is not replaced. Just a QoL implementation if you do not want the cell comment to be changed.
Created attachment 203662 [details] CALC - feature request - cell comment edit bar There currently is this bar at the top to edit comments (where the buttons could also be placed, to have them collected in _one_ place) However: The bar only shows up when you right clicked the cell to always display the comment. So you have to take extra steps to even get to it and getting to it is not very obvious (I for example use have been using LibreOffice and comment in calc for years and I only noticed that this bar even exists today)
Created attachment 203663 [details] CALC - feature request - cell comment right click menu The new UI would remove the option to always show and there the comment from the right click menu as they are collected in one place.
Created attachment 203664 [details] CALC - feature request - cell comment rotation The current comment implementation also has an option to rotate it. I have no idea why and where you could need this, but on the other side: Why not? However, it does not seem to work. No matter what I do, I can't rotate the field.
For users looking to enhance their comments or cell content with stylish or unique fonts, you can try https://texttoolz.com/tools/whatsapp-font-generator. This free online tool allows you to generate a variety of creative font styles that can be copied and pasted into documents or spreadsheets, which could improve readability and add a fun touch to your CALC experience.
Wouldn't add those (icon-only) buttons to the control but as floating mini-toolbar as known from MS Word and requested in bug 87040. Excel works currently the same as Calc, by the way.
(In reply to Heiko Tietze from comment #7) > Wouldn't add those (icon-only) buttons to the control but as floating > mini-toolbar as known from MS Word and requested in bug 87040. > > Excel works currently the same as Calc, by the way. The mini-icons are just an example (even though I would be fine if it was implemented that way - just a little larger) Ideas behind this: - The bar to edit the comment is really obvious. The comment field does not really say "Hey, BTW: You can customise me!". I used comments for years before even noticing it. Thereby a *only* having the options at the top is something that is may not as effective as it could be. - The icons next to the window (or as mini-toolbar) is something that tells the user right away that they can do more with their comments. This could get into people's workflow, so you should be able to turn it off. - I (who considers himself has advanced user) would be more than likely use hotkeys as much as possible. So I wouldn't be happy if there was only the edit bar at the top or the floating mini-toolbar. Yet I can understand that new users (or maybe even experienced ones) won't know or are not willing to hunt in the documentation for features. That Calc currently works the same as Excel (or Excel works currently the same as Calc) is not something I would take in account for such a feature. For file saving as *.xlsx you would have to, but not as general rule to copy or keep out what Excel does or doesn't do ("The great should not be constrained by the small").