Hi,
I am new to WinGrid and ultraCalcManager.
I am developing a windwos application in VB.net and using the grid in one of my forms. There are 4 columns in the grid. User enters the amount manually and i would like WinGrid calculates the VAT and the total by using the formula. i have added UltraCalcManager to the form and also writen my math function which is a normal adding.
when i set the grid datasource, i get an error message "NullReferenceException was unhandlled". if i set CalcFrequnecy to Manual, the error message goes away and formula does not work. If I set it to the other options, it throws the above error message.
Could you please help in this matter?
Many thanks
Kamal
Hi Kamal,
It's impossible to guess without more information. Where is the error occurring? Can you post the call stack? What does your formula look like? Whta are you applying the formula to? Is this is a summary or are you putting a formula into a column?
Hi Mike,
I was away for few days, so sorry for not replying back to your questions.
The error occurs when i try to bind data. Initially, the value is zero for all columns. There are 3 columns; Amount, Vat, Total. The user enter a value into Amount column and this formula should fire up to calculate VAT:
(Amount * 17.5) / 100
and this formula is for Total column:
Amount + Vat
I found out that i can not use Formula in the Bind column, so I hidden my bind column and added two unbound column. I am putting the formula into these unbound columns.
thanks for your help.