27:null 28:["$","title",null,{"children":"A wee attempt to get \"XLSX Accessibility Checker\" into a shape that I can turn into an ES6 module | James Trimble's ONS work | Observable"}] 2d:T34f7,class XlsxWorkbook { constructor(z, workbook) { this.z = z; this.workbook = workbook; } async computeResults() { let stylesXml = await this.z.file("xl/styles.xml").text(); let workbookXmlDoc = XlsxWorkbook.parseXml( await this.z.file("xl/workbook.xml").text() ); let documentTitle = await this.computeDocumentTitle(); let sheets = await this.getSheets(workbookXmlDoc); let untitledHyperlinks = await this.getUntitledHyperlinks(sheets); let activeCellsNotA1 = this.getActiveCellsNotA1(sheets); let workbook = this.workbook; let tables = await this.getTables(workbook, sheets); let heading1CellsInfo = await this.getHeading1CellsInfo(stylesXml, sheets); let mergedCells = this.getMergedCells(workbook); let sheetsWithEmptyCellA1 = this.getSheetsWithEmptyCellA1(workbook); let possiblyBlankWorksheets = this.getPossiblyBlankWorksheets(workbook); let sheetToTables = this.makeSheetToTablesLookup(workbook, tables); let sheetsWithContentBelowTables = this.getSheetsWithContentBelowTables( workbook, sheetToTables ); let sheetsWithoutColumnATable = this.getSheetsWithoutColumnATable( workbook, sheetToTables ); let sheetsWithoutTables = this.getSheetsWithoutTables( workbook, sheetToTables ); let sheetsWithHiddenContent = await this.getSheetsWithHiddenContent(sheets); let workbookHasFrozenContent = await this.doesWorkbookHaveFrozenContent(); let workbookHasHeadersOrFooters = await this.doesWorkbookHaveHeadersOrFooters(); let workbookHasSuperscript = await this.doesWorkbookHaveSuperscript(); return { documentTitle, sheets, untitledHyperlinks, activeCellsNotA1, tables, stylesXml, workbookXmlDoc, heading1CellsInfo, mergedCells, sheetsWithEmptyCellA1, possiblyBlankWorksheets, sheetToTables, sheetsWithContentBelowTables, sheetsWithoutColumnATable, sheetsWithoutTables, sheetsWithHiddenContent, workbookHasFrozenContent, workbookHasHeadersOrFooters, workbookHasSuperscript, workbook }; } async computeDocumentTitle() { let coreDoc = XlsxWorkbook.parseXml( await this.z.file("docProps/core.xml").text() ); let titleFields = coreDoc.getElementsByTagName("dc:title"); if (titleFields.length === 0) return ""; return titleFields[0].textContent; } async getSheets(workbookXmlDoc) { let workbookRelsXmlDoc = XlsxWorkbook.parseXml( await this.z.file("xl/_rels/workbook.xml.rels").text() ); let sheetFilenames = {}; let rels = workbookRelsXmlDoc.getElementsByTagName("Relationship"); for (let i = 0; i < rels.length; i++) { let rel = rels[i]; sheetFilenames[rel.getAttribute("Id")] = rel.getAttribute("Target"); } let sheets = workbookXmlDoc.getElementsByTagName("sheet"); let result = []; for (let i = 0; i < sheets.length; i++) { let sheet = sheets[i]; result.push({ rId: sheet.getAttribute("r:id"), filename: sheetFilenames[sheet.getAttribute("r:id")], name: sheet.getAttribute("name") }); } return result; } async getUntitledHyperlinks(sheets) { let result = []; for (let sheet of sheets) { let sheetFileName = "xl/" + sheet.filename; if (this.z.filenames.includes(sheetFileName)) { let sheetDoc = XlsxWorkbook.parseXml( await this.z.file(sheetFileName).text() ); let hyperlinks = sheetDoc.getElementsByTagName("hyperlink"); for (let i = 0; i < hyperlinks.length; i++) { let hyperlink = hyperlinks[i]; let title = ""; if (hyperlink.hasAttribute("display")) title = hyperlink.getAttribute("display"); if (title.startsWith("http")) { result.push({ sheet: sheet.name, title }); } } } } return result; } getActiveCellsNotA1(sheets) { let result = []; for (let sheet of sheets) { let sheetFileName = "xl/" + sheet.filename; if (this.z.filenames.includes(sheetFileName)) { let sheetDoc = XlsxWorkbook.parseXml(this.z.file(sheetFileName).text()); let selections = sheetDoc.getElementsByTagName("selection"); // If freeze panes are switched on, there may be multiple active cells. // If there are no active cells A1, we assume there is an issue. let activeCellA1 = false; let otherActiveCells = []; for (let i = 0; i < selections.length; i++) { let selection = selections[i]; if (selection.hasAttribute("activeCell")) { let activeCell = selection.getAttribute("activeCell"); if (activeCell === "A1") { activeCellA1 = true; } else { otherActiveCells.push(activeCell); } } } if (!activeCellA1 && otherActiveCells.length > 0) { result.push({ sheet, activeCell: otherActiveCells[0] }); } } } return result; } async getTables(workbook, sheets) { let result = []; for (let sheet of sheets) { let relsFiles = this.z.filenames.filter((f) => f.endsWith(sheet.filename.replace("worksheets/", "_rels/") + ".rels") ); if (relsFiles.length === 0) continue; let relsDoc = XlsxWorkbook.parseXml( await this.z.file(relsFiles[0]).text() ); let relationships = relsDoc.getElementsByTagName("Relationship"); for (let rel of relationships) { if ( rel.getAttribute("Type") === "http://schemas.openxmlformats.org/officeDocument/2006/relationships/table" ) { let target = rel.getAttribute("Target"); target = target.replace("..", "xl"); let tableDoc = XlsxWorkbook.parseXml( await this.z.file(target).text() ); let tableElem = tableDoc.getElementsByTagName("table").item(0); let tableName = tableElem.getAttribute("name"); let tableRef = tableElem.getAttribute("ref"); result.push({ sheetName: sheet.name, tableName, tableRef, range: XLSX.utils.decode_range(tableRef), hasEmptyCells: XlsxWorkbook.rangeHasEmptyCells( workbook, sheet.name, XLSX.utils.decode_range(tableRef) ), hasFilterButtons: XlsxWorkbook.tableHasFilterButtons(tableDoc), hasDefaultName: new RegExp("^Table_?[0-9]*$").test(tableName), hasHeaderRow: tableElem.hasAttribute("headerRowCount") && tableElem.getAttribute("headerRowCount") === "0" }); } } } return result; } async getHeading1CellsInfo(stylesXml, sheets) { let heading1XfId = null; let stylesDoc = XlsxWorkbook.parseXml(stylesXml); let cellStyles = stylesDoc.getElementsByTagName("cellStyle"); for (let i = 0; i < cellStyles.length; i++) { let cellStyle = cellStyles[i]; let name = cellStyle.getAttribute("name"); let xfId = cellStyle.getAttribute("xfId"); if (name === "Heading 1") { heading1XfId = xfId; } } if (heading1XfId == null) return null; let heading1Styles = {}; // a set of style numbers let cellXfs = stylesDoc .getElementsByTagName("cellXfs") .item(0) .getElementsByTagName("xf"); for (let i = 0; i < cellXfs.length; i++) { let xf = cellXfs[i]; if (xf.getAttribute("xfId") === heading1XfId) { heading1Styles["" + i] = 1; } } let result = []; for (let sheet of sheets) { let sheetFileName = "xl/" + sheet.filename; if (this.z.filenames.includes(sheetFileName)) { let sheetDoc = XlsxWorkbook.parseXml( await this.z.file(sheetFileName).text() ); let hasA1Heading1 = false; let otherHeading1 = false; let cells = sheetDoc.getElementsByTagName("c"); for (let i = 0; i < cells.length; i++) { let cell = cells[i]; if ( cell.hasAttribute("r") && cell.hasAttribute("s") && cell.getAttribute("s") in heading1Styles ) { if (cell.getAttribute("r") === "A1") { hasA1Heading1 = true; } else { otherHeading1 = cell.getAttribute("r"); } } } let problems = ""; if (!hasA1Heading1) problems += "(Cell A1 does not have Heading 1 style)"; if (otherHeading1) problems += " (At least one cell other than A1 has Heading 1 style: cell " + otherHeading1 + ")"; if (problems) result.push({ sheet, problems }); } } return result; } static tableHasFilterButtons = function (tableDoc) { let autoFilterElems = tableDoc.getElementsByTagName("autoFilter"); if (autoFilterElems.length === 0) return false; let filterColumnElems = tableDoc.getElementsByTagName("filterColumn"); if (filterColumnElems.length === 0) return true; for (let i = 0; i < filterColumnElems.length; i++) { let col = filterColumnElems[i]; if ( !col.hasAttribute("hiddenButton") || col.getAttribute("hiddenButton") != "1" ) { return true; } } return false; }; getMergedCells(workbook) { let result = []; for (let sheet of workbook.SheetNames) { if ("!merges" in workbook.Sheets[sheet]) { for (let range of workbook.Sheets[sheet]["!merges"]) { result.push(sheet + "!" + XLSX.utils.encode_range(range)); } } } return result; } getSheetsWithEmptyCellA1(workbook) { let result = []; for (let sheet of workbook.SheetNames) { if (!("A1" in workbook.Sheets[sheet])) { result.push(sheet); } } return result; } getPossiblyBlankWorksheets(workbook) { let result = []; for (let sheet of workbook.SheetNames) { if ( !("!ref" in workbook.Sheets[sheet]) || XLSX.utils.decode_range(workbook.Sheets[sheet]["!ref"]).e.r < 2 ) { result.push(sheet); } } return result; } getSheetsWithoutTables(workbook, sheetToTables) { return workbook.SheetNames.filter((d) => sheetToTables[d].length === 0); } getSheetsWithoutColumnATable(workbook, sheetToTables) { function hasAColumnATable(tables) { for (let table of tables) { if (table.range.s.c === 0) return true; } return false; } let result = []; for (let sheet of workbook.SheetNames) { if (sheetToTables[sheet].length === 0) continue; if (!hasAColumnATable(sheetToTables[sheet])) { result.push(sheet); } } return result; } getSheetsWithContentBelowTables(workbook, sheetToTables) { let result = []; for (let sheet of workbook.SheetNames) { let tables = sheetToTables[sheet]; if (tables.length === 0) continue; let lastTableRow = -1; for (let table of tables) { lastTableRow = Math.max(lastTableRow, table.range.e.r); } for (let cell in workbook.Sheets[sheet]) { if (cell.startsWith("!")) continue; if (XLSX.utils.decode_cell(cell).r > lastTableRow) { result.push(sheet); break; } } } return result; } async getSheetsWithHiddenContent(sheets) { let result = []; for (let sheet of sheets) { let sheetFileName = "xl/" + sheet.filename; let xml = await this.z.file(sheetFileName).text(); if (xml.includes('hidden="true"')) result.push(sheet); } return result; } async doesWorkbookHaveFrozenContent() { for (let filename of this.z.filenames) { if (filename.startsWith("xl/worksheets/")) { let xml = await this.z.file(filename).text(); if (xml.includes('state="frozen"')) return true; } } return false; } async doesWorkbookHaveHeadersOrFooters(z) { for (let filename of this.z.filenames) { if (filename.startsWith("xl/worksheets/")) { let xml = await this.z.file(filename).text(); if ( xml.includes("") && !xml.includes("") ) return true; if ( xml.includes("") && !xml.includes("") ) return true; } } return false; } async doesWorkbookHaveSuperscript(z) { return (await this.z.file("xl/sharedStrings.xml").text()).includes( 'val="superscript"' ); } makeSheetToTablesLookup(workbook, tables) { let result = {}; for (let sheet of workbook.SheetNames) { let tt = []; for (let table of tables) { if (table.sheetName === sheet) { tt.push(table); } } result[sheet] = tt; } return result; } static rangeHasEmptyCells(workbook, sheetName, range) { let sheet = workbook.Sheets[sheetName]; for (let r = range.s.r; r <= range.e.r; r++) { for (let c = range.s.c; c <= range.e.c; c++) { let cellRef = XLSX.utils.encode_cell({ c, r }); if (!(cellRef in sheet) || sheet[cellRef] === "") { return true; } } } return false; } static parseXml(xmlString) { return new DOMParser().parseFromString(xmlString, "text/xml"); } }2e:[] 2b:{"id":"adbbe075ff92f356","slug":null,"title":"A wee attempt to get \"XLSX Accessibility Checker\" into a shape that I can turn into an ES6 module","thumbnail":"d2194270595aa5432a3d93d1c7e76eac456c088e579c09cf9f7964c2abbb4fad","access_level":"public","create_time":"$D2023-03-28T19:43:48.991Z","update_time":"$D2023-04-18T10:36:02.442Z","view_time":null,"first_public_time":"$D2023-03-28T19:43:48.991Z","has_unpublished_edits":null,"fork":{"id":"3c45b6f263fa88dc","slug":"xlsx-accessibility-checker","title":"XLSX Accessibility Checker","owner":{"id":"30965c406219b62a","login":"jtrim-ons","name":"James Trimble's ONS work"}},"stars":0,"starred":false,"owner":{"type":"team","id":"30965c406219b62a","login":"jtrim-ons","name":"James Trimble's ONS work","avatar_url":"https://avatars-next.observableusercontent.com/5c661298568698f51736e0dabf77961904e0e40d91facf41b6d85eb71d6ea3df","tier":"starter_2024"},"version":1123,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"72cc4aad069a0c71","login":"jtrim-ons","name":"James Trimble's ONS work","avatar_url":"https://avatars-next.observableusercontent.com/5c661298568698f51736e0dabf77961904e0e40d91facf41b6d85eb71d6ea3df","tier":null}],"members":[{"type":"individual","id":"72cc4aad069a0c71","login":"jtrim-ons","name":"James Trimble's ONS work","avatar_url":"https://avatars-next.observableusercontent.com/5c661298568698f51736e0dabf77961904e0e40d91facf41b6d85eb71d6ea3df","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"A wee attempt to get \"XLSX Accessibility Checker\" into a shape that I can turn into an ES6 module","cells":[{"id":0,"value":"# A wee attempt to get \"XLSX Accessibility Checker\" into a shape that I can turn into an ES6 module\n\nThis is an attempt to check some of the rules in [this checklist for accessible spreadsheets](https://gss.civilservice.gov.uk/policy-store/making-spreadsheets-accessible-a-brief-checklist-of-the-basics/). It's not complete and may give some false positives and false negatives.\n\nTo use the checker, click the \"Browse\" button below to upload an XLSX file from your computer.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":30,"value":"**Choose an XLSX file:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"viewof file = Inputs.file()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":586,"value":"## Tables","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":73,"value":"### Mark up tables","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":79,"value":"{\n if (results.sheetsWithoutTables.length < results.workbook.SheetNames.length) {\n let result =\n '

✓ Looks goodThe following tables were found:

${s}: ${tables.map(\n (d) => \" \" + d.tableName\n )}

\";\n return html`${result}`;\n } else {\n return html``;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"{\n console.log(\n results.sheetsWithoutTables.length,\n results.workbook.SheetNames.length\n );\n if (\n results.sheetsWithoutTables.length === results.workbook.SheetNames.length\n ) {\n return html`

Changes are neededNo tables were found in the workbook. Some of the following checks rely on tables being marked up. See the guidance for instructions.

`;\n } else if (results.sheetsWithoutTables.length) {\n return html`

Changes may be neededNo tables were found in the following sheets: ${results.sheetsWithoutTables.join(\n \", \"\n )}.

`;\n } else {\n return html``;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":514,"value":"### Give tables meaningful names","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":518,"value":"{\n let tablesWithDefaultNames = results.tables.filter((t) => t.hasDefaultName);\n if (\n results.sheetsWithoutTables.length === results.workbook.SheetNames.length\n ) {\n return html`

Not checkedNo tables were found.

`;\n } else if (tablesWithDefaultNames.length === 0) {\n return html`

✓ Looks goodNo tables with default names were found

`;\n } else {\n let result =\n '

Changes are neededThe following tables should be given descriptive names:

${t.tableName}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"### Each table should have a header row","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":656,"value":"{\n let tablesWithoutHeader = results.tables.filter((t) => t.hasHeaderRow);\n if (\n results.sheetsWithoutTables.length === results.workbook.SheetNames.length\n ) {\n return html`

Not checkedNo tables were found.

`;\n } else if (tablesWithoutHeader.length === 0) {\n return html`

✓ Looks goodTables have header rows

`;\n } else {\n let result =\n '

Changes are neededThe following tables do not have header rows:

${t.tableName}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"### Remove blank rows and columns","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":151,"value":"{\n let tablesWithEmptyCells = results.tables.filter((t) => t.hasEmptyCells);\n if (\n results.sheetsWithoutTables.length === results.workbook.SheetNames.length\n ) {\n return html`

Not checkedNo tables were found.

`;\n } else if (tablesWithEmptyCells.length === 0) {\n return html`

✓ Looks goodNo tables with empty cells were found

`;\n } else {\n let result =\n '

Changes may be neededTables should have no blank rows or columns, and there should be no blank cells in the header row. However, cells with no data may be left empty if certain conditions are met.

The following tables have at least one empty cell:

${t.tableName} in sheet ${t.sheetName}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"### The first table on each sheet should use column A","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":390,"value":"{\n if (\n results.sheetsWithoutTables.length === results.workbook.SheetNames.length\n ) {\n return html`

Not checkedNo tables were found.

`;\n } else if (results.sheetsWithoutColumnATable.length === 0) {\n return html`

✓ Looks goodNo problems detected.

`;\n } else {\n let result =\n '

Changes are neededSheets without a table in column A:

${s}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":452,"value":"### Tables should have filter buttons switched off","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":462,"value":"{\n let tablesWithFilterButtons = results.tables.filter(\n (t) => t.hasFilterButtons\n );\n if (\n results.sheetsWithoutTables.length === results.workbook.SheetNames.length\n ) {\n return html`

Not checkedNo tables were found.

`;\n } else if (tablesWithFilterButtons.length === 0) {\n return html`

✓ Looks goodNo tables with filter buttons were found

`;\n } else {\n let result =\n '

Changes are neededThe following tables appear to have filter buttons switched on:

${t.tableName} in sheet ${t.sheetName}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":788,"value":"### Avoid putting any information below a table","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":792,"value":"{\n if (\n results.sheetsWithoutTables.length === results.workbook.SheetNames.length\n ) {\n return html`

Not checkedNo tables were found.

`;\n } else if (results.sheetsWithContentBelowTables.length === 0) {\n return html`

✓ Looks goodNo problems detected.

`;\n } else {\n let result =\n '

Changes may be neededThe following sheets may have content below a table:

${s}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":590,"value":"## Worksheets","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":157,"value":"### Remove blank worksheets","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":161,"value":"{\n if (results.possiblyBlankWorksheets.length === 0) {\n return html`

✓ Looks goodNo blank sheets were found

`;\n } else {\n let result =\n '

Changes are neededBlank worksheets:

${s}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":548,"value":"### Each sheet should have its title in cell A1","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":551,"value":"{\n if (results.sheetsWithEmptyCellA1.length === 0) {\n return html`

✓ Looks goodCell A1 is non-empty in each sheet

`;\n } else {\n let result =\n '

Changes are neededCell A1 is empty in the following sheets:

${item}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"### Cell A1 should use Heading 1 style","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":182,"value":"{\n if (results.heading1CellsInfo == null) {\n return html`

Changes are neededNo cells using the Heading 1 style were detected.

`;\n } else if (results.heading1CellsInfo.length === 0) {\n return html`

✓ Looks goodCell A1 in each sheet uses the Heading 1 style.

`;\n } else {\n let result =\n '

Changes are neededChanges may be required on the following sheets:

${item.sheet.name} ${item.problems}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":484,"value":"### A1 should be the active cell in each sheet","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":488,"value":"{\n if (results.activeCellsNotA1.length === 0) {\n return html`

✓ Looks goodA1 is the active cell in each sheet

`;\n } else {\n let result =\n '

Changes are neededThe cursor should be moved to A1 in these sheets:

${item.sheet.name} (currently cell ${item.activeCell})

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"### Rows and columns should not be hidden","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":190,"value":"{\n if (results.sheetsWithHiddenContent.length === 0) {\n return html`

✓ Looks goodNo hidden content was detected.

`;\n } else {\n let result =\n '

Changes are neededThe following sheets may have hidden rows or columns.

${item.name}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"### Avoid adding freeze panes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":212,"value":"{\n if (!results.workbookHasFrozenContent) {\n return html`

✓ Looks goodNo frozen rows or columns were detected.

`;\n } else {\n return html`

Changes may be neededThe workbook may have frozen rows or columns. If this feature is needed, make sure the sheet has instructions for turning freeze panes off.

`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"### Do not use headers and footers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":238,"value":"{\n if (!results.workbookHasHeadersOrFooters) {\n return html`

✓ Looks goodNo headers or footers were detected.

`;\n } else {\n return html`

Changes are neededThe workbook may have headers or footers.

`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":100,"value":"### Remove merged cells","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":103,"value":"{\n if (results.mergedCells.length === 0) {\n return html`

✓ Looks goodNo merged cells were found

`;\n } else {\n let result =\n '

Changes are neededMerged cells:

${c}

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":610,"value":"## Cell contents","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":221,"value":"### Do not use superscript to signpost to notes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":225,"value":"{\n if (!results.workbookHasSuperscript) {\n return html`

✓ Looks goodNo superscript text was detected.

`;\n } else {\n return html`

Changes are neededThe workbook may have superscript text. (This sometimes gives false positives.)

`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":533,"value":"### Make hyperlink text descriptive","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":537,"value":"{\n if (results.untitledHyperlinks.length === 0) {\n return html`

✓ Looks goodNo plain-URL hyperlink descriptions were found. (Hyperlink text should also be checked manually for descriptiveness.)

`;\n } else {\n let result =\n '

Changes are neededThe following links may not have descriptive text. (This check sometimes gives incorrect results!)

${item.title} (on ${item.sheet})

\";\n return html`${result}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"## Workbook","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":502,"value":"### The workbook should have a title","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":506,"value":"{\n if (results.documentTitle !== \"\") {\n return html`

✓ Looks goodThe workbook has the following title: ${results.documentTitle}

`;\n } else {\n return html`

Changes are neededThe workbook needs a title (in Excel: File > Info).

`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":575,"value":"### The first worksheet should be open when the workbook is saved","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":579,"value":"{\n let firstSheetActive = results.workbook.Workbook.WBView[0].activeTab === 0;\n if (firstSheetActive) {\n return html`

✓ Looks goodThe first sheet is open.

`;\n } else {\n return html`

Changes are neededThe first sheet is not open. Click on cell A1 of the first sheet, then save the workbook.

`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":711,"value":"## Things to check manually\n\nThe following list covers many, but not all, of the [checklist](https://gss.civilservice.gov.uk/policy-store/making-spreadsheets-accessible-a-brief-checklist-of-the-basics/) items that have not been checked above.\n\n- See the Footnotes section of the checklist.\n- See the Formatting section of the checklist, most of which is not covered by this spreadsheet checker.\n- Ensure all text is visible and clearly spaced out.\n- The cell in column A directly below the title should describe the contents of the worksheet.\n- Run Excel's spelling and grammar checker and accessibility checker.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"---\n\n## Appendix\n\nEverything below this point can be ignored.\n\n---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":14,"value":"XLSX = require(\"xlsx@0.17.4/dist/xlsx.full.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":958,"value":"results = new XlsxWorkbook(\n await file.zip(),\n await XLSX.read(new Uint8Array(await file.arrayBuffer()), { type: \"array\" })\n).computeResults()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"$2d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2e","stdlib":"1","titling":"auto"}} 2c:"$2b:body"