T O P I C R E V I E W |
AKazak |
Posted - 08/27/2020 : 11:31:14 AM OriginPro 2021 (64-bit) Beta 4 9.8.0.138 Windows 7 Pro x64 SP1
Greetings!
I copy several text strings to clipboard and want to paste them on a worksheet in such a way that each text string goes to a separate cell. However, if I paste to a worksheet Origin automatically splits the string using spaces as delimiters.
Is there a way to disable this automatic separation?
--- Andrey |
4 L A T E S T R E P L I E S (Newest First) |
AKazak |
Posted - 08/28/2020 : 02:31:17 AM quote: Originally posted by cpyang
Set @PST=1 to disable, and I can see Excel default paste keep spaces in such case, so we will improve this, adding new
Paste (Keep Spaces)
to cell right-click menu. Otherwise people will never find out about this system variable.
https://originlab.jira.com/browse/ORG-22465
CP
Great! Thank you.
--- Andrey |
cpyang |
Posted - 08/27/2020 : 3:14:10 PM Set @PST=1 to disable, and I can see Excel default paste keep spaces in such case, so we will improve this, adding new
Paste (Keep Spaces)
to cell right-click menu. Otherwise people will never find out about this system variable.
https://originlab.jira.com/browse/ORG-22465
CP
|
AKazak |
Posted - 08/27/2020 : 2:39:10 PM quote: Originally posted by lkb0221
You can double click on a cell to enter the edit mode, and then paste. This will put all contents from the clipboard into this single cell.
OK, but this is not what I need. I need that each string line pasted to a separate cell in the column.
--- Andrey |
lkb0221 |
Posted - 08/27/2020 : 2:21:22 PM You can double click on a cell to enter the edit mode, and then paste. This will put all contents from the clipboard into this single cell. |