I have copied a list and pasted it into CALC.
All entries on the list are now in one cell.
I would like them to each be in thier own cell.
How to convert ?
TNX, THE BookMan
920.265.5966
Where from? (What are the preformated properties? What are the line separator characters? (“Enter” or “Shift-Enter”)?
You probably entered the cell / placed it into edit mode / double clicked / hit F2, before pasting the list. Don’t. Just paste onto a cell instead of into, and a text import dialog should appear.
Just pasting didn’t work.
Either nothing happened … or a picture was entered. (framed list)
Might it help to know that I use DITTO as clipboard manager?
Thanks, just the same,
⌡im [THE BookMan]
920.265.59663
Might break things, specifically that inserting as image is a known broken “clipboard manager” aka destroyer behaviour. Disable it.
DITTO is most useful and I am loathe to disable it.
Do you recommend another ?
⌡im [THE BookMan]
920.265.5966
I do not recommend any because most of them break clipboard features.
With only the default Windows clipbaord, if you copy a list (just a bunch of items on separate lines) in Notepad then you can paste it directly into Calc, and Calc will present the Text Import dialog, which will split the list into separate rows on the sheet.
However, if you look at the clipboard contents, the only data flavor available will be Unicode Text. If you then request that flavor with clipboard.getContents().getTransferData(selectedFlavor), it will paste into a single cell and not present the Text Import dialog.
I’ve attached a very rough macro that will let you pick the format then paste into a selected region. It is just for experimentation, since you have to have selected exactly the correct number of cells for the paste. If there is any interest, I can have it adjust the region automatically. The idea would be to put a completed version of this macro in your Standard My Macros and then assign a keystroke to it if it works.
This macro might work with your clipboard manager since it expects only CR/LF separated items.
Again, if you get an error messagebox, double check that you have pre-selected exactly the number of items in the list (and not any unnoticed empty lines as well, which might show up “at random” from HTML sources).
Also: Have you tried Ctrl+Alt+Shift+v?
ClipBoardParsing.ods (12.4 KB)