Description: Presently there are four presets in Paste Special dialog in LibreOffice Calc: Values only, Values & Formats, Formats Only, and Transpose All. A fifth preset for pasting only formulas would be a great addition to the available presets. Steps to Reproduce: Since this is not a bug but a feature request, there are no steps to reproduce it. Actual Results: Presently the presets in Paste Special dialog in LibreOffice Calc are Values only, Values & Formats, Formats Only, and Transpose All. Expected Results: A fifth preset for pasting only formulas would be added to Paste Special dialog in LibreOffice Calc. Reproducible: Didn't try User Profile Reset: No Additional Info: There is no other information.
Thanks for the suggestion, Andrei. Have you noticed that this option is already available in the context menu? right-click > Paste special > Formulas
Dear Andrei Dragomirescu, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Andrei, we wait some feedback here. You made a suggestion, but you get another one, see comment 2.
Regarding Stéphane's comment, yes, I have noticed that the option requested is already available in the context menu. However, you should consider that this makes the paste dialog very inconsistent, which is rather unpleasant, especially for people who prefer using the keyboard more and the mouse less. For a consistent and productive user interface, my suggestion would be to replace the submenu "Special paste..." in the context menu with the "Special paste window". It is rather strange to have a "Special paste" option in a "Special paste..." submenu.
Ok, let's see others opinion here. UX Team -- please take a look at this enhancement. Thanks!
The Paste Special pop-up dialog has the 4 presets in the UI. Don't see much call for the 5th for "Formulas", and it is already available via context menu paste and from the pop-up dialog via check-box. -1
Dear Stuart, The GUI's inconsistency remains and affects the user experience. On the other hand, a quick way to paste formulas would be very useful for those like me who need to check and correct many sheets prepared by others, where pasting corrected formulas should not affect the formatting.
(In reply to Andrei Dragomirescu from comment #7) > Dear Stuart, > > The GUI's inconsistency remains and affects the user experience. On the > other hand, a quick way to paste formulas would be very useful for those > like me who need to check and correct many sheets prepared by others, where > pasting corrected formulas should not affect the formatting. You can customize your LibreOffice to have a quicker access. The command is "Paste Only Formula" (that is .uno:PasteOnlyFormula). You can add/move it top level of a menu, to a toolbar, define a shortcut key for it or add/move it to top of the context menu. There is no need to change the default UI.
Well, thank you.