Description: Please add a Paste special mode for number formats only without additional formatting. Actual Results: Currently copy/paste of the formatting also pastes all the font and other formatting Expected Results: Only number format should be copied. Reproducible: Always User Profile Reset: No Additional Info: -
Thanks for the suggestion, Massimo! UX/Design team, is that something that can be accommodated or is it going too far in the breakdown of options? Reminds me of bug 151111, although I appreciate one specific thing is requested here.
(In reply to Stéphane Guillou (stragu) from comment #1) > I appreciate one specific thing is requested here. Bug focus has its benefits, but this immediately begs the question: What should and shouldn't be offered as a Paste option? What's the criterion?
When doing a CTRL+Shift+V for Paste Special, that dialog currently provides [x]Formats which include all formats like frames, font style and number format. I would like to see separate items like [] Formats [ ] Number format [ ] Font style [ ] Frame style ... You could show that as a tree while [ ] Formats would also (de-)select all children.
The number format is an attribute of the cell style along with font, alignment, border (guess this is what you have in mind with frame style), background, etc. Picking one leaves always room for greed and users ask to have all those above. It would be Formats [x] All [ ] Number [ ] Font ... bloating the dialog quite a lot. And I wonder what omitting the numbering format means. Is it to be detected, eg. 10% becomes 0.1 (but the other formatting remains unlike today).
IMHO omitting the number format should not fiddle at all with the existing number formats of the target area, e.g. pasting a 10% (0.1) value would be displayed with whatever format was applied to the target cell, similar to pasting values only.
We discussed the topic in the design meeting. Besides all concerns raised in the comments it is a functionality users know from Excel: paste "Formulas and number formats" or alternatively "Values and number formats" [1]. Since we allow to select values and/or formulas the option needs to be a checkbox under "Options" labeled "[ ] Number format" disabled if "[x] Format" is checked (and otherwise allowing to overwrite the target number format). [1] https://support.microsoft.com/en-us/office/paste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad