In Paste Menu (via customize) you can paste Number, Txt, Formulae, BUT NOT the Format of the cell separately. If it's not a bug then it's a request for the future.
User Profile Reset: No
This paste special feature already is provided:
1). In Calc module
2). From source sheet copy the cells with any formatting desired.
3). On new target sheet, select a cell (with space to hold the selection).
4). With '<Ctrl>+<Shift>+v' (or from context menu Paste Special) open the 'Paste Special' dialog.
5). On the 'Paste Special' dialog, clear all check boxes, and make a check box selection of 'Formats'
6). OK to paste _just_ the cell formatting.
Windows 10 Home 64-bit en-US with
Version: 188.8.131.52 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
To Mr Stuart Foote:
What you described I already know, of course.
It is a method that takes far too much time if
you only want to copy and paste cell formats
that is why I hope for an improvement.
Open Tools Customize Go to the Paste Options
You see Paste only Text, Paste only Numbers, Paste only Formula
but NOT Paste only Format.... For that I have to be in that
horrible inefficient Paste Special menu. Why?
I would like to see such an extra Paste format option
for the future. Possible or not? Thank you.
Commands to be added as customization require wrapping into a .uno control. That does not exist--the Paste Special -> Formats is an element of the PasteSpecial control.
Not clear there is a valid use case for creating a stand alone .uno command to paste just the 'Formats'
IMHO => WF
But we'll send it through the UX-advise process.
For what I understand, the request is not to introduce a new UNO command but to enhance the quick access section from the paste special dialog (it has today the options: Values, Values & Formats, and Transpose).
(In reply to V Stuart Foote from comment #3)
> Not clear there is a valid use case for creating a stand alone .uno command
> to paste just the 'Formats'
Me too, also because we have many functions to format cells. So Ton, why don't you work with cell styles or conditional formatting?
Dear Mr Heiko,
I never have used cell styles or conditional formatting because I do not understand them and things I do not understand I don't use: I am always running into trouble...
I copy and paste a lot of external data (snippets) with my clipboard manager into LO. By doing so I loose the cell formatting, I fix this with the Special Paste Menu but then I have to untick two boxes and tick one. When you have to do that 1000 x a year over and over again then you start wondering why I am doing this and if there is no better solution.
I send you a link to my Dropbox account holding a screenshot of the cell context menu of LO. I made modifications (in Dutch) to it like this:
but not Formats because it is not present in the Options Customize menu and I do not understand why. Okay if it is not possible because of technical software problems, then rest my case. But it would already be a great improvement if the user can decide in the Paste Special menu which boxes he wants ticked or unticked and save it.
Okay here is the link:
Thank you and best regards, Ton
(In reply to Ton from comment #5)
> I never have used cell styles or conditional formatting because I do not
> understand them
https://documentation.libreoffice.org/assets/Uploads/Documentation/en/CG4.1/PDF/CG4104-StylesAndTemplates.pdf (in general, the documentation team put a lot of effort into these documentations)
> I copy and paste a lot of external data (snippets) with my clipboard manager
> into LO. By doing so I loose the cell formatting, I fix this with the
> Special Paste Menu but then I have to untick two boxes and tick one. When
> you have to do that 1000 x a year over and over again then you start
> wondering why I am doing this and if there is no better solution.
There is also the autoformat feature https://help.libreoffice.org/6.3/en-US/text/scalc/01/05110000.html?&DbPAR=CALC&System=UNIX
> ... not Formats because it is not present in the Options Customize menu and
> I do not understand why.
The reason is there are plenty of better alternatives. Way better. Please try it first, I bet you save more time than with any UI hack.
Point why I hesitate to agree with your proposal is, if we introduce a new function it should add benefit for many users. For example, "Paste Format" could be mistaken as "Paste Formatted". It also takes space meaning you cannot glace over a few paste options but have to read all - of course not a result of one function but it adds up. Not to speak about maintenance at the code.
Well, as usual I found my own solution: the Paste Special Menu starts with 3 brown buttons at the top and the middle one says Values & Formats. With that option I at least can copy the format of an empty cell to an other empty cell on a sheet without having to handle the tick boxes. I wonder if there are more (hidden) surprises in the Paste Special Menu. Have a nice day.