JanKallman/EPPlus

ExcelErrorValues written to XLSX file are saved as text instead of ExcelErrorValue

jochenwezel opened this issue · 0 comments

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.Div0

When reading again that XLSX file and reading the cells,
sheet.Cells(1, 1).Value is of type String instead of OfficeOpenXml.ExcelErrorValue