XCeed Workbooks .NET - TimeSpan when using Culture without point as decimal separator
When working under Culture, which uses something else than a point as a decimal separator, assigning TimeSpan value to a cell results in a broken spreadsheet. The numerical value inside the xml is written with the decimal separator from the current culture, but Excel needs it to be a point.
Here is a short snippet for reproduction
var spanish = CultureInfo.CreateSpecificCulture("es");
Thread.CurrentThread.CurrentCulture = spanish;
var workbook = Workbook.Create(new MemoryStream());
var sheet = workbook.Worksheets[0];
sheet.Cells[0, 0].Value = TimeSpan.FromSeconds(8162);
workbook.SaveAs(@"C:\files\xceedCultureBug.xlsx");
I could temporarily assign point as a decimal separator for the current Culture, but I would have to remember to always use it and switch it back wherever I'm saving changes to the spreadsheet.