GrapeCity Forums

Hi,

 In my SS, I have 3 columns. The 3rd one is a product of the 1st two and hence I have set a formula for the 3rd column. However, the user would like to be able to edit the data after the calculation. Currently, if the user edits the data in the formula column it is immediately overwritten by the formula value for the cell.

Specifically, I have a rate and a unit column and the amount is the product of the two and should be allowed to be overwritten by the user.

 Thanks, Mala

Hello Mala, 

You may set the ClientAutoCalculation to false to disable automatic re-calculation on the client-side data. 

Regards, 

Hello Harish,

If we set ClientAutoCalculation to false then the column will no longer calculate the column. What we need to have is the column to still calculate but have the ability to override the calculated value. 

 Mala

Mala,

I applied a formula on column3 and set the ClientAutoCalculation to false, this column is still evaluating the applied formula on pressing the Update button from command bar.

Thanks

Hi,

Our users want to enter a rate(Col1) and a unit(Col2) and have amount(Col3) calculated as they tab out of the Col1 or Col2  fields. I dont think we can have the users click the Update button on every calculation...this is a data entry screen. How can we make Col3 calculate and allow it to be overridden w/o asking user to go click Update button etc.

Thanks, Mala

Mala,

If you set this formula on a column basis, then the only way for the client to change the text in the calculated field is to change the formula. To put text in the cell, you can use the T function. You can put the following in the cell to change the text to the word "Hello".

=T("Hello")