Is there a way to set a Default Currency (different than regional setting)

Is there a way to set a Default Currency (different than regional setting)

Posted by: kevin.keller on 20 May 2019, 6:18 am EST

• 

  kevin.keller

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 May 2019, 6:18 am EST

  I am looking for a way to set a default currency symbol, default separator, default decimal symbol, for a Sheet that would be stored with the sheet and not impact other sheets.

  In the spread for com there were spreadsheet properties for all of these values which do not exist in this version.

  FloatDefCurrencyChar
  
  FloatDefDecimalChar
  
  FloatDefSepChar

  I am looking for something similar or equivalent to do in Spread for WinForms 12.xx this would be a property so that when new rows or columns are created these properties would be set correctly for the current sheet.

  Thanks,

  Kevin

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 21 May 2019, 10:54 pm EST

  Hello,

  There is no property available in Spread12. net corresponding to these properties. However, you can use CellType to set the format of the cell. Please refer to the following link for the more information:
  
  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#spwin-setcelltypes.html

  Thanks.