| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
 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 |
|
|
lkb0221
China
497 Posts |
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. |
 |
|
|
AKazak
Russia
1205 Posts |
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 |
|
|
|
cpyang
USA
1406 Posts |
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
Russia
1205 Posts |
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 |
|
|
| |
Topic |
|
Disabling auto separation on paste from clipboard