Format problem on paste

English
#1

I have used CALC for several years and LOVE IT !
I also use DITTO as clipboard manager and LOVE IT !
After the latest update to 7.5.03, there is a problem (FRUSTRATING) when pasting from Ditto (latest version)
Some of the time, (maybe 1/3) the data that is pasted appears very small and left oriented.
I have to go and re-format those cells, not a HUGE deal, but annoying.
The whole column has been formatted; Centered (H & V), 18pt, Liberation Sans a couple of times.

Any ideas ?
Thank you,
⌡im [THE BookMan]

#2

Probably the usual, the clipboard “manager” is rather a clipboard destroyer in that it fiddles with available target formats, not offering the Calc internal clipboard format if pasting content copied in Calc, or prioritizing a different format. If on Linux, you could inspect offered target formats of the current clipboard content with

xclip -selection clipboard -o -t TARGETS

For content copied in Calc it should list ~25 targets, among them application/x-libreoffice-internal-id-123456 (where 123456 is the soffice.bin process ID). For content copied from elsewhere you’d hopefully see what Ditto offers and what Calc could pick as a preferred format maybe. If the pasted text is much smaller than regular plain text then there’s probably some RTF or HTML involved. You could see and choose from Calc’s Paste Special (button) list.

#3

Use cell styles!

#4

EDIT -► PASTE SPECIAL -► PASTE UNFORMATTED TEXT

This works !

⌡im [THE BookMan]
920.265.5966

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.