SET the symbol and the decimal for currency cell

Aspose.Cells Product Family
1

Hi,

Thank you for all the help that you gave us for several issues.

To make a cell in the “Currency” format we use this simple code :

Style st = cell.getStyle();
st.setNumber(5);//or “6”,“7”,"8"
cell.setStyle(st);

but with this solution we can’t modify the “Symbol” used ($,£…) or adjust the “Decimal Places” in order to make our own currency.

I know that we can use the custom format to implement dynamically the currency that we want but that solution is not acceptable for our client.They want to export the data in the cells having the format “Currency”.

Is there any solution to use the “Currency” format and also access to the “Symbol” and the “Decimal places” parameters and change them ?

Thanks.
2

Hi,


Well, in MS Excel, Numbers, DateTime and Currency formattings are based on the regional/ locale and language settings of your OS, so you may either try to set Custom numbers formatting or try to set the relevant Regional and language settings of your OS in control panel.

Thank you.