ExcelErrorValues written to XLSX file are saved as text instead of ExcelErrorValue
jochenwezel opened this issue · 0 comments
jochenwezel commented
After writing to a sheet with e.g. following code
WorkSheet.Cells(1, 1).Value = OfficeOpenXml.ExcelErrorValue.Values.Num
WorkSheet.Cells(2, 1).Value = OfficeOpenXml.ExcelErrorValue.Values.Div0When reading again that XLSX file and reading the cells,
sheet.Cells(1, 1).Value is of type String instead of OfficeOpenXml.ExcelErrorValue