Summary

Several type definition has been fixed. Details:

• Worksheet.lastColumn can beundefined for an empty worksheet, asWorksheet.lastRow can beundefined.
• date1904 should be an optional property for bothCellFormulaValue andCellSharedFormulaValue.
• CellFormulaValue.result andCellSharedFormulaValue.result should includeboolean.
• CellFormulaValue.result andCellSharedFormulaValue.result should includeCellErrorValue, not{ error: CellErrorValue }, becauseCellErrorValue itself is already an interface witherror as its property.
• Protection should have ahidden property, as is recorded in the documentation.
• dashed should be a valid value forBorderStyle, as is documented in ISO/IEC 29500-1:2016 18.18.3 ST_BorderStyle (Border Line Styles).

Test plan

Related to source code (for typings update)

• exceljs/index.d.ts

  Lines 1188 to 1191 inec92cb3

  	/**
  	* Get the last editable row in a worksheet (or undefined if there are none)
  	*/
  	readonlylastRow:Row|undefined;

• exceljs/lib/xlsx/xform/sheet/cell-xform.js

  Lines 95 to 99 inec92cb3

  	caseEnums.ValueType.Formula:
  	if(options.date1904){
  	// in case valueType is date
  	model.date1904=true;
  	}

• exceljs/lib/xlsx/xform/sheet/cell-xform.js

  Lines 354 to 355 inec92cb3

  	}elseif(this.t==='b'){
  	model.result=parseInt(model.value,10)!==0;

• exceljs/lib/xlsx/xform/sheet/cell-xform.js

  Lines 356 to 357 inec92cb3

  	}elseif(this.t==='e'){
  	model.result={error:model.value};

• exceljs/lib/xlsx/xform/style/protection-xform.js

  Lines 42 to 45 inec92cb3

  	constmodel={
  	locked:!(node.attributes.locked==='0'),
  	hidden:node.attributes.hidden==='1',
  	};