(ORG-7937)
Sample OPJ to download to try: Copy Paste Formula and Column Label Rows.opj
We introduce have introduced more copy column options in Origin 9.1, including copy/paste formula. It allows user to repeat column calculation on other selected columns in the same worksheet or other worksheets.to the Copy context menu for columns:
The options include
- Copy (Formula): Copy Set Column Value settings
- Copy (Label Rows): Copy the column label rows without data
- Copy (Including Label Rows): Copy the column label rows with data
- Copy (Formula and Label Rows): Copy both Set Column Value Settings and Label Rows
...