Datacolumn.Expression

Posted by: adonohue on 8 September 2017, 1:16 pm EST

  • Posted 8 September 2017, 1:16 pm EST

    I 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.

    Aaron
  • Replied 8 September 2017, 1:16 pm EST

    It seems funny possibly answering my own post, but after some research I may have a better understanding of what you were recommending...

    I initially thought you were referring to a DataColumn object that Farpoint had created not realizing that you were probably referring to .NET's DataColumn object.  After putting 2 and 2 together I found the following documentation...

    http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression(VS.80).aspx

    Now that the pieces are comming together I realize that "no", I will not be able to use cell references in this expression.

    It's been a long day...
    Aaron


  • Replied 8 September 2017, 1:16 pm EST

    Aaron,


    This is correct. Hopefully today will be shorter for you so you can enjoy a long weekend.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels