Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Set Column Value Improvements (ORG-9021)

Formula column label row (ORG-6669)

Right click workbook title and choose View: F(x ) to turn on/off the formula label row. Then type formula directly using the same syntax as used in Set Column Values dialog. E.g. col(B)-col(A), sin(col(A)), i*2, etc.

You can use Set Column Values dialog as before to set formula. The formula label row will update. 

An Options menu has been added to Set Values dialog, where you can control whether direct editing of the formula in the label row should be permitted or not. The Formula Text menu item can be used to enter explanatory text for the formula, which will instead be displayed in the fomula label row.

...