a11ytables
a11ytables copied to clipboard
co-analysis
R package: generate best-practice stats spreadsheets for publication
`a11ytables::generate_workbook(example_a11ytable)` Produces `Error in nchar(x) : 'nchar()' requires a character vector` Using version 0.2.0
In the section referring to other tools, mention [{rapid.spreadsheets}](https://github.com/RAPID-ONS/rapid.spreadsheets), which is less focused on the Analysis Function's 'releasing statistics in spreadsheets' guidance.
Hi Matt, Thanks very much for this package. I saw your talk at EARL2022 on `{a11ytables}` but didn't get the opportunity to ask the following. We often use UK government...
There has been a request to: > ...implement comma separated thousands format in the workbook, using [openxlsx::createStyle(numFmt = “COMMA”)](https://rdrr.io/cran/openxlsx/man/createStyle.html) as per [the guidance](https://gss.civilservice.gov.uk/policy-store/releasing-statistics-in-spreadsheets/). (Also, this is a reminder to look...
{a11ytables} is intentionally simple in its interface. This is to make user's lives easier and to make sure that [the best practice guidance](https://analysisfunction.civilservice.gov.uk/policy-store/releasing-statistics-in-spreadsheets/) is followed. However, there are certain legitimate...
Test the content of `as.list(my_workbook)` against what would be expected from the a11ytables-class object that went into creating the Workbook-class object.
'Simple' changes: * Reorganise scripts in `R/` for clarity (inc simplify utils) * Simplify functions (there probably only needs to be one `.get_start_row_*()` function with an argument to specify which...
The guidance says that sheet titles should be header H1. I can't see how to do this in {openxlsx}. Also not sure if Excel can actually distinguish between simply adding...
Via DH. Error in `setColWidths()` when `create_a11y_wb()` is run: ``` > my_wb2
I'm exporting rounded and suppressed numbers and am getting the 'number stored as text' error in all of my numeric columns, even for columns where there are **no** rounded or...
Metadata
Owner
Metadata
R package: generate best-practice stats spreadsheets for publication