Spread 11 - SetValue with formula on cell

Spread 11 - SetValue with formula on cell

Posted by: petri.rasanen on 6 June 2018, 7:43 pm EST

• 

  petri.rasanen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 June 2018, 7:43 pm EST

  Hi!

  Setting value with SetValue method (Sheets[sheetNo].SetValue(row, col, value) now with Spread 11 overrides formula on sheet. In Spread Windows Forms version 9.35 the formula and it’s value remained on cell even if SetValue was used. Is this a bug or is this changed on purpose ?

  Br,
  
  Petri

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 7 June 2018, 4:49 pm EST

  Hi Petri,

  This is not a bug but looks like a design behavior knowingly made in V11.
  
  The SetValue method will assign a value to the cell overriding the formula in it. The same thing happens when we paste in a formula cell. Or you directly type anything in the cell.

  Thanks,
  
  Deepak Sharma