Support Board
Date/Time: Mon, 25 Nov 2024 20:36:26 +0000
Post From: Use ASCIL to insert spreadsheet formula in Column O
| [2024-02-11 23:03:56] |
| PeteB - Posts: 17 |
|
Hi, Is there any way in ASCIL to insert formulas into spreadsheets, for example, insertion of =ID0.SG4@3>=5500 into the O3 cell of a spreadsheet defined to the Spreadsheet System/Alert study? When I insert using the aptly-named sc.SetSheetCellAsString, it is interpreted as a string, even after recalculation, and even with the leading equal sign. The string is recognized as a formula when I manually edit the cell, change nothing, and press OK. I know I can make this work with the EvaluateFormula functions, or with Spreadsheet Formula study, but these are not my preference. Thanks
|