Error message: ... not a valid formula

Error message: ... not a valid formula

Posted by: stefan.schell on 7 February 2018, 9:34 pm EST

• 

  stefan.schell

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 February 2018, 9:34 pm EST

  Hi.
  
  I have migrated to Spread 11 and get an error when I am setting a formula for a cell:

  Error Message: ‘Round(R[0]C3-R[0]C4)’ is not a valid formula
  
  Error offset: 0

  I have changed the syntax to Round(RC3-RC4) but the same.
  
  Any idea’s what to do?
  
  Thans Stefan

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 February 2018, 12:39 am EST

  Hi Stefan,

  Please make sure that you have set the reference style for Spread sheet to R1C1.

  fpSpread1.Sheets[0].ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;

  Thanks,
  
  Deepak Sharma

• 

  stefan.schell

  • Post Options:
  • Link
    Copy

  Posted 4 March 2018, 7:07 pm EST

  Hi Deepark Sharma.
  
  Thanks for your reply. I had allready set this property. Could you please send me a project with function examples for .net. The Windows Forms .NET 4.0 Samples Explorer has a symbol for Fx Functions examples but there is nothing displayed.
  
  Thanks Stefan

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2018, 1:40 am EST

  Hi Stefan,

  Please refer to the attached demo sample application which contains the formula demo. I have also attached an XML file showing use of Round() formula with R1C1 reference style.
  
  Let me know in case you face any issues.

  Thanks,
  
  Deepak Sharma

  SpreadWinDemo.zipRoundFormula.zip