odswriter
odswriter copied to clipboard
mmulqueen
A pure-Python module for writing OpenDocument spreadsheets (similar to csv.writer).
odswriter was not working for me, the Formulas would not be interpreted by Libreoffice 6.4.7. But removing the code that wraps the cell references in brackets and add a dot...
I added code to format the cells as follows: 1. Cell width should approximate the size of the data in the row with the largest data for that column 2....
Formulas can contain quoted strings, which can contain text that might look like a cell reference. The quoted text must be preserved verbatim. Double quoting still needs to be done...
Formulas can contain unicode strings, too. This is needed e.g. for [`HYPERLINK`][1]. 1: https://help.libreoffice.org/Calc/Spreadsheet_Functions#HYPERLINK