Hi, I have an UltraGrid with more than 100 rows, and 3 or more groups, and each group with 3 or more columnas, 2 of those columns has a formula. So i put the CalcFrecuency = Manual and i use an UltraButton to do the calculations. In the button i use : this.ucalcXXX.ReCalc(). I dont know if its ok, i want to know if there is another better way to do this, because:
1. Before the calculations, when i scroll down in the grid, the render is slow like little pauses. But when i use SuspendCalc() the scroll down is normal.
2. When i press the button and the calculations are done, only the cells that are visible in that moment are filled with the calculate data, if i scroll down the grid, the other cells are in blank and i have to press the button to calculate again for those rows. i'm doing something wrong?
3. A formula in a column apply to all the cells in that column, but there is any flag or method to avoid the calculation in some cells inside that column?
Lois.Best Regards
Hi Lois,
linksolutions said:1. Before the calculations, when i scroll down in the grid, the render is slow like little pauses. But when i use SuspendCalc() the scroll down is normal.
I'm not sure why this would be. What version of the grid are you using? Do you have the latest Hot Fix? There were some known performance issues related to formulas in grid's using OutlookGroupBy that were fixed a while ago.
linksolutions said:2. When i press the button and the calculations are done, only the cells that are visible in that moment are filled with the calculate data, if i scroll down the grid, the other cells are in blank and i have to press the button to calculate again for those rows. i'm doing something wrong?
By default, the grid is set up to calculate the visible cells first. This is intended to provide a better user experience when the calculations are being done asynchronously. But it doesn't make sense in your case. What you need to do is set DeferredCalculationsEnabled to false (on the UltraCalcManager) so it doesn't do this.
linksolutions said:3. A formula in a column apply to all the cells in that column, but there is any flag or method to avoid the calculation in some cells inside that column?
You can't do this directly, but you could probably get the behavior you want like so:
Hi,
Thanks for the answers.
1. Im using the UltrGrid Version : 8.3.20083.1009. Can u plz tell me the name of the hot fix ?, im pretty sure that we installed all of them. I really want to fix this, because sometimes the number of rows are more than 500!.
2. Fixed :D
3. I was using an Unbound Column for the calculations so i guess i only need to set DBNull for those cells that dont need the calculation. Thank you very much :D.
linksolutions said:1. Im using the UltrGrid Version : 8.3.20083.1009. Can u plz tell me the name of the hot fix ?, im pretty sure that we installed all of them. I really want to fix this, because sometimes the number of rows are more than 500!.
500 is really not a lot of rows. You can get the latest Hot Fix here: My Infragistics Keys and Downloads - Download Anything and Everything You Own
If that does not help, you should Submit an incident to Infragistics Developer Support and include a small sample project demonstrate the problem.