Posted 8 September 2017, 1:16 pm ESTI spoke with Rob and asked a question regarding binding...the question was, "Can I bind to the formula property of the spread for winforms component instead of the value property?" He replied with the following....
"Regarding your question about binding to formulas instead of data, if the operations you need to complete are simple it seems like your best option would be to not use Spread formulas. Instead, you could use DataColumn.Expression to perform the operations
DataColumn.Expression can be used to create a DataColumn that shows a calculated value based on the other field values in the record. But it is limited to the syntax supported by the Expression property, and doesn't use our calc engine. It has the same end result in simple cases though, with much less code since you don't have to create unbound columns or set formulas, as would be required for using Formulas in Spread along with bound data."
So I have a few questions...
1. I am trying to find documentation on this object (DataColumn) to learn how to use it's property (Expression) and I am not having much luck. Can you direct me somewhere?
2. Assuming I can figure out how this DataColumn.Expression works, will this expression property allow me to use cell references in the spreadsheet as arguments that will be evaluated?
Thanks in advance.