Function buildBugsNotesSheet

scripts/createExcelSheet.mjs:32–58

(workbook)

];

function buildBugsNotesSheet(workbook) {
  let sheet = workbook.addWorksheet('Bugs & Notes');

  sheet.columns = [
    {width: 25},
    {width: 18},
    {width: 50},
    {width: 18},
    {width: 15},
    {width: 50},
    {width: 25}
  ];
  sheet.getColumn(3).alignment = {wrapText: true, vertical: 'top'};
  sheet.getColumn(6).alignment = {wrapText: true, vertical: 'top'};

  let header = sheet.addRow(BUGS_NOTES_HEADER);
  header.font = {bold: true};

  let priorityValidation = {
    type: 'list',
    allowBlank: true,
    formulae: [`"${PRIORITY_OPTIONS.join(',')}"`]
  };
  for (let i = 2; i <= 500; i++) {
    sheet.getCell(`B${i}`).dataValidation = priorityValidation;
  }
}

function buildReleaseNotesSheet(workbook, {v3PRs, s2PRs, racPRs, otherPRs, offPRs}) {
  let sheet = workbook.addWorksheet('Release Notes');