(ORG-7937)
Sample OPJ to download to try: Copy Paste Formula and Column Label Rows.opj
We have introduced more options 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
To perform the operation,
- Select one or multiple worksheet column(s)
- Right-click on the worksheet column, there are context menu items available under Copy
- Choose the desired option
- Select the worksheet column(s) in the same worksheet or other worksheets.
- Right-click on the worksheet column(s) and choose Paste from the shortcut menu
The following image is an example which show you how to copy formula from selected columns on a worksheet and paste to another to convert Cartesian coordinates to Polar coordinates
