Videos
Blogs
January 28, 2022
SpreadsheetSetCellFormula NOT honored by Excel
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.
- IN CF, open spreadsheet
- USE “SpreadsheetSetCellFormula” to set formula in given cell
- Write spreadsheet
- 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.
- 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
Similar Blogs
Upcoming Events