FORMULA CELL SEPARATOR SPREAD 9

Posted by: danilomario on 8 September 2017, 3:21 pm EST

  • Posted 8 September 2017, 3:21 pm EST

    Hi
    in the old version the formula =SUM(A1,A2) was correct
    Now in version 9 run only =SUM(A1;A2) AND NOT =SUM(A1,A2)
    WHY ??????????
    I cannot change all the source ......
  • Replied 8 September 2017, 3:21 pm EST

    Hi,

    This code works for me with the current Spread Win 9.

    FpSpread1.Sheets(0).Columns(0).CellType = New FarPoint.Win.Spread.CellType.NumberCellType()
    FpSpread1.Sheets(0).Cells(3, 0).Formula = "SUM(A1,A2)

    Are you using different language settings?

    -Gina
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels