SpreadsheetSetCellFormula NOT honored by Excel
January 28, 2022
SpreadsheetSetCellFormula NOT honored by Excel
January 28, 2022
Newbie 1 posts
Followers: 0 people

HELP!!!!   Upgraded CF to 2021 from 10.0.  Up to date on CF patches (#3).

The following was working for YEARS until we updated CF.  NO CODE WAS CHANGED FOR UPGRADE, WE ASSUMED CODE SHOULD REMAIN SAME.

  1. IN CF, open spreadsheet
  2. USE “SpreadsheetSetCellFormula” to set formula in given cell
  3. Write spreadsheet
  4. Open sheet in Excel.  NO CF calculations are auto-calculated (Again,  this was working perfectly for years).  In Excel, we see the CF formula properly.
  5. ONLY solution is for user to control-alt-F9 to circumvent this.

HELP!  We MUST have this function working properly as we rely on Excel/CF interface for company business.

Is this known bug?

LMK

All Comments
Sort by:  Most Recent