I want keep CurrencyGroupSeparator

Posted by: maze0117 on 8 September 2017, 2:03 pm EST

  • Posted 8 September 2017, 2:03 pm EST

    Value of a Cell "123,456" becomes "123456" after focus and focus out.


    And the CurrencyDecimalDigits of cell assigned as "0", but I can enter value like "456.789"


    How can I keep the celltype of a cell??

  • Replied 8 September 2017, 2:03 pm EST

    Hello, 

    I'm not able to reproduce the problem. I used the following code to set the CellType as CurrencyCellType for  the Cell[0,0] and it shows the thousand seperators all the time, as well as does not accept any decimal digits.

    private void Form1_Load(object sender, EventArgs e)

    {

    FarPoint.Win.Spread.CellType.CurrencyCellType currcell = new FarPoint.Win.Spread.CellType.CurrencyCellType();

    currcell.Separator = ",";

    currcell.ShowSeparator = true;

    currcell.DecimalPlaces = 0;

    fpSpread1.ActiveSheet.Cells[0, 0].CellType = currcell;

    Please test this at your end, and let me know your observations. Or, if you are using differently, please share the code.

    Thanks,

    ~Jacob 

  • Replied 8 September 2017, 2:03 pm EST

    I've already try that, but it's useless....
  • Replied 8 September 2017, 2:03 pm EST

    Is it possible to attach a sample app/code to reproduce this problem?
Need extra support?

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

Learn More

Forum Channels