Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Dan Cerub
80
Excel like formula in grid cell.
posted

Hi,

I am trying to evaluate if there is any sample of knowledge base around this. We are looking to implement a feature that allows the user to add a column at runtime. Within this column the user can specify a formula for each cell on the grid similar to excel.

Example - in the cell the user can specify "=sum(100 + 200)" and the cell value should be "300".

Similarly, the user should be able to base a calculation on the basis of other cells in that grid. Example - "=sum((Column 1 - Row 5) + (Column 2 - Row 1)).

Thanks in advance, any pointers will be helpful.

Parents
No Data
Reply
  • 469350
    Offline posted

    Hi Dan,

    The UltraCalcManager component allows you to apply formula in the grid, but you can only apply a formula to an entire column (or summary). There is no support for formulas on a single cell.

    There is a sample included with NetAdvantage called "Formula Builder Runtime" which shows you how you can allow the user to display the FormulaBuilder at run-time and apply that formula to an entire column.

Children