Posted 8 September 2017, 2:30 pm EST
I set the formular for the cell [0,2] ,code as following
this.fpSpread1_Sheet1.Cells[0, 2].Formula = "R1C1 + R1C2";
After I execute the code fpSpread1.SaveExcel("C:\\ddd.xls", FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly);
the spread export to excel, but I find that the fomular in cells[0,2] is =R3C1+R3C2 ,But I wish it is R1C1+R1C2,
What I can do, Thanks for your help.
when i used fpSpread1.SaveExcel("C:\\ddd.xls"); the result is right