I’m working with a project that supports multiple currencies and formats. This project uses style.Custom formatting, and seems to work well with “,” as the thousand separator and the “.” for the decimal separator (#,##0.00). Though when #.##0,00 is being passed the data being entered is being formatted incorrectly. It’s like it’s applying ###0.000 with decimal point being the decimal separator, causing the input values to be 1000 time the correct values. I’ve looked into “style.NumberType = NumberType.Currency”, but haven’t found the correct formatting I need.
Where NumberFormat is “#.##0,00”
/// Set alignment on top row total cell
style = sheet.Cells[0, maxCol].GetStyle();
style.HorizontalAlign = HorizontalAlign.Right;
style.Custom = NumberFormat;
style.Font.Bold = true;