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


    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)


    <span class="Apple-tab-span" style="white-space:pre;"> </span>FarPoint.Win.Spread.CellType.CurrencyCellType currcell = new FarPoint.Win.Spread.CellType.CurrencyCellType();

    <span class="Apple-tab-span" style="white-space:pre;"> </span>currcell.Separator = ",";

    <span class="Apple-tab-span" style="white-space:pre;"> </span>currcell.ShowSeparator = true;

    <span class="Apple-tab-span" style="white-space:pre;"> </span>currcell.DecimalPlaces = 0;

    <span class="Apple-tab-span" style="white-space:pre;"> </span>fpSpread1.ActiveSheet.Cells[0, 0].CellType = currcell;

    </end of code>

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



  • 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