printErrors property

CellErrorPrintOptions printErrors
getter/setter pair

Represents the values to be printed insead of cell errors in the worksheet.

final Workbook workbook = Workbook();
final Worksheet sheet = workbook.worksheets[0];
sheet.getRangeByName('A1:D3').text = 'Hello';
sheet.getRangeByName('B4').number = 987;
sheet.getRangeByName('C4').number = 5678;
sheet.getRangeByName('D4').formula = 'ASIN(B4:C4)';
sheet.pageSetup.printErrors = CellErrorPrintOptions.dash;
final List<int> bytes = workbook.saveAsStream();
saveAsExcel(bytes, 'printErrors.xlsx');
workbook.dispose();

Implementation

late CellErrorPrintOptions printErrors;