Qtablewidget like Excel

**advseo32** · 10th August 2013, 23:21

thanks a lot

is this the optimized methode ??

you have an idea about how MS excel calculate results ?

**Lykurg** · 11th August 2013, 11:04

Originally Posted by advseo32

is this the optimized methode ??

Yes, I think so.

you have an idea about how MS excel calculate results ?

Well, it does not use Qt, but the general approach is the same: detect value change, recalculate, update with new value (if needed). How could one optimize that?

**advseo32** · 11th August 2013, 14:45

Originally Posted by Lykurg

Yes, I think so.

Well, it does not use Qt, but the general approach is the same: detect value change, recalculate, update with new value (if needed). How could one optimize that?

don't worry about this , i want only to get advices from professionals, and correct my errors

thank's for helping

**ChrisW67** · 13th August 2013, 03:36

I imagine that Excel creates a dependency tree between cells in much the same way that make does for builds. When a cell is changed the downstream recalculation flows by simply following the dependency tree. This approach allows for early detection of circular references.

C++ GUI Programming with Qt 4 (Second Edition) walks through a simple spreadsheet application. The same example may be in the first edition (which can be had for no money). http://www.qtrac.eu/marksummerfield.html