When copying from DITTO to CALC I suspect that there are non-printing characters that are being copied that change the formatting of the cell to which the data is being copied.
Can I show the non-printing characters and filter them out ?
Thank You,
⌡im
Attach an example demonstrating the issue.
What “non-printing characters” would you want to “show” if you not even feel sure there are soime? And non-printing characters can’t vbe shown due to their nature. They first would need to be replaced.
If it is about so-called whitespace characters, it should help to use the TRIM() function. In other cases REGEX() can be needed. The RegEx [\u0000-\u001F] should find any single ASCII control character, e.g. (and some chars in addition).
BTW: DITTO seems to be a clipboard manager. I never used software of the kind.
There is usually no hex-preview or similiar in LibreOffice.
.
For single values you may try to paste first in an editor like Notepad++ on Windows, to analyze/change the contents of the clipboard.
.
On the other side: You may get a dialogue for the import. You are aware of the possibility to change the type of the column there? Often importing numbers of different locale result in text/string like copy 1,000,000 to german locale (where 1.000.000 would be expected).
.
The other problem was already named by @Lupp A clipboard manager may change the list of available types for Calc.
To see whether there even are unexpected characters, assuming your pasted content is in A1:
Select/mark cell range B1:L1 (or however long enough for your A1 cell content), then (with the active cell still being B1) enter
=UNICODE(MID($A1;COLUMN()-1;1))
and close the input with Alt+Enter. That distributes the formula over the selected cell range and outputs one Unicode character code value in each cell. Extraneous (selected range longer than cell content) display Err:504, ignore those. To convert back for easier investigation you could do similar with a selected cell range B2:L2 and in B2 the formula
=UNICHAR(B1)
again closing with Alt+Enter.