Matt Dray

Thank you for this package and congrats on CRAN. I've used it a number of times for converting to PDF and I've started to put a gif of my slides...

To note: this is something that the gptables team would also like to solve, but is also proving difficult in Python given the limits of the xlsx-related packages being wrapped.

At least for now, could we do something like: ``` system("libreoffice --headless --convert-to ods output-file.xlsx") ``` Which requires LibreOffice to be installed, of course. Surely this is better than nothing?

Also suggested by Jan: https://github.com/JanMarvin/openxlsx2/discussions/574#discussioncomment-5552573

@DIPAD-Fran-Bryden pointed out [a `convert_to_ods()` function in {dftutils}](https://github.com/department-for-transport-public/dftutils/blob/main/R/convert_ods.R) (thank you!); could add documentation to {a11ytables} to suggest using this approach.

One option might be cell width. The package currently uses a set width and doubles it if a certain character count is met by the table contents. Might be good...

Thanks for getting in touch, Jack. This is a great question and I like the idea. We'd need to detect whether a given spreadsheet was created: 1. With {a11ytables} or...

Another approach: use Fran's package [{odsTableReadr}](https://github.com/department-for-transport-public/odsTableReadr) to identify each of the tables in such a workbook and then extract meta-information from cell A1 to the row just above the start...

Thanks @phil-hall-moj, this is something we've been thinking about in our own publications as well. I'm yet to explore the full functionality of {openxlsx} and I'm hoping that this sort...

Thanks for highlighting this. You're right, you can do it with {openxlsx} using `numFmt`. For my own benefit I've prepared an example below; you may find it useful too. Click...