I’m doing something like this:
cell.Style.Custom = “#.##0,00 “kW””;
But when I view the created Excel file, the format of a cell reads
I.e. the comma “,” was removed and the dot “.” was converted to a comma “,”.
My environment is German (german .NET Framework, german Excel). In Germany, the dot “.” is the 1000-separator and the comma “,” is the decimal separator whereas in the English language it is just the other way.
Am I running into culture problems here or is this related to something different?