Accessibility checklist¶
The tables below indicate your accessibility responsibilities when publishing statistics in spreadsheets. It is based on the Analysis Function checklist of the basics and heavily inspired by the a11ytables documentation.
Note
The tables show which checklist items are automatically met by
gptables. This applies to workbooks created using the default gptheme
and may not apply if custom themes or additional formatting are used.
Table¶
Description |
Essential? |
Status |
Explanation |
---|---|---|---|
Mark up tables |
Essential |
Implemented |
Tables in a |
Give tables meaningful names |
Desirable |
Partially implemented |
Pass a meaningful name to the |
Remove merged cells, split cells and nested tables |
Essential |
Implemented |
Merged cell, split cells and nested tables are not supported by gptables. |
Remove blank rows and columns within tables |
Essential |
Partially implemented |
Blank rows or columns in a column will raise an error. User should remove them and any apply any desired additional formatting. |
All tables should have one tagged header row |
Essential |
Implemented |
The column names in a |
Wrap text within cells |
Essential |
Partially implemented |
Using |
Avoid adding filters and freeze panes |
Desirable |
Implemented |
Filters and freeze panes are not supported by gptables. |
Only leave cells with no data empty in certain circumstances |
Essential |
Partially implemented |
If cells are null or whitespace, users are prompted to explain why in the
|
Avoid hiding rows or columns |
Desirable |
Implemented |
Hiding rows or columns is not supported by gptables. |
Footnotes¶
Description |
Essential? |
Status |
Explanation |
---|---|---|---|
Do not use symbols or superscript to signpost to notes |
Essential |
Implemented |
Notes marked with |
Use the word ‘note’ when referring to footnotes |
Desirable |
Implemented |
As mentioned above, notes are formatted as |
Avoid putting note markers in specific cells |
Desirable |
Partially implemented |
The |
Put note text in a notes table on a notes worksheet |
Desirable |
Implemented |
If users provide a |
Formatting¶
Description |
Essential? |
Status |
Explanation |
---|---|---|---|
All written content needs to meet the accessibility guidelines |
Essential |
Not implemented |
It is the package user’s responsibility to make sure that text follows the Analysis Function guidance on making written content accessible. |
Links must be accessible |
Essential |
Partially implemented |
Users should provide descriptive hyperlink text using the
|
Format text to make it accessible |
Desirable |
Implemented |
The default theme meets the accessibility guidance on formatting text. |
All worksheets should have descriptive titles which are properly tagged and formatted |
Essential |
Partially implemented |
Provide descriptive titles to the |
Avoid using symbols in general |
Desirable |
Partially implemented |
An error will be raised if table cells only contain symbols. It is the user’s responsibility to make sure symbol use within text is appropriate. |
Do not use headers and footers, floating text boxes or floating toolbars |
Essential |
Implemented |
These components are not supported by gptables. |
Do not use visual devices to divide data regions |
Desirable |
Implemented |
Using gptables without additional formatting does not use such visual devices. |
Do not use a background fill |
Desirable |
Implemented |
The gptables default theme does not apply a background fill. |
Do not use colour as the only way to convey a message |
Essential |
Implemented |
The default theme without additional formatting does not apply colour. |
When using colour for emphasis check the contrast |
Essential |
Not implemented |
If using colour via additional formatting or a custom theme, it is the user’s responsibility to check the colour contrast. |
Avoid images in spreadsheets |
Desirable |
Implemented |
Adding images is not supported by gptables. |
Remove macros |
Desirable |
Implemented |
Macros are not supported by gptables. |
Structure¶
Description |
Essential? |
Status |
Explanation |
---|---|---|---|
Give worksheets unique names or numbers |
Essential |
Implemented |
Worksheet names come from the |
Remove blank worksheets |
Essential |
Implemented |
Blank worksheets are not supported by gptables. |
Use cells in column A wisely |
Essential |
Implemented |
|
Position tables against the left-hand edges of each sheet |
Essential |
Implemented |
gptables writes tables starting in column A. |
Avoid putting content below a table |
Desirable |
Implemented |
Writing content below a table is not supported in gptables>=1.0.0. |
Avoid worksheets with multiple tables |
Desirable |
Implemented |
Writing multiple tables per sheet is not supported in gptables. |
Before publishing¶
Description |
Essential? |
Status |
Explanation |
---|---|---|---|
Run a spelling and grammar check |
Essential |
Not implemented |
gptables does not check spelling and grammar, this is the user’s responsibility. |
Use the accessibility checker |
Desirable |
Not implemented |
gptables does not have a built-in accessibility checker. Whilst all efforts have been taken to make outputs accessible, the final responsibility sits with the user. |
Add document information |
Essential |
Not implemented |
gptables does not add title or language information to the document, this responsibility sits with the user. Note: the document properties available depend on the user’s operating system and may not meet the standard required for webpages. |
Ensure the cursor is in cell A1 of the first worksheet when doing your final save |
Essential |
Implemented |
Workbooks written using gptables will have the cursor in the first cell. Note: if the workbook is subsequently opened and saved, it is the user’s responsibility to check that the cursor has not been moved. |