GridDataBoundGrid & FormulaCell using a real time Datasource

Hello,

Let me explain my problem:

- I'm using a GridDataBoundGrid with default settings.
- The linked datasource object is a DataTable.
- The DataTable contains only columns which accept System.String values.
- Each row contains string values (e.g. "1500", "100", "480", etc.) and also strings which represent formulas (e.g. "=B3-C2", "=B4-D2", etc.).
- I've a timer which update every 500 ms the DataTable (only string values are updated, neither rows nor columns are added or deleted).

Then, when I launch my application, all formulas are well generated, values are present, but the grid isn't updated correctly.

Moreover, when I click in cells, some formulas are moved or duplicated without any reason, and I often encounter the "circular reference" error when formulas are copied over values cells.

I'll soon create a test sample to illustrate what I just described, but maybe you could help me on this point without such stuff.

Regards,

Romain


1 Reply

JA Jay March 1, 2008 03:35 AM UTC

Here is a KB on how to use formula cells in a GDBG:

http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=104


Loader.
Up arrow icon