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

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

0 Comments
Add Comment