FIX3.00.00 · Released 6 July 2016
FIXfinPOWER Connect
Released in
3.00.00
6 July 2016
  1. Opened25 May
  2. Closed25 May
  3. Released6 Jul
Article 13860 Job J017445

Excel Workbooks; ISExcelCell.Formula does not work

The ISExcelCell.Formula property in an Excel Workbook does not work - the formula is never set.

Note, the Cell's formula must start with an equals symbol, e.g. "=A1+A2". In addition, formula's do not calculate the resulting value. However, when you open a file in MS Excel, formula results will be calculated automatically - alternatively set the Cell value rather than its formula.