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 before cell references in the Formula class fixed the problem.
# DO NOT Wrap cell refs in square brackets.
# s = re.sub(r"([A-Z]+[0-9]+(:[A-Z]+[0-9]+)?)", r"[\1]", s)
# DO NOT Place a . before cell references, so for example . A2 becomes .A2
# s = re.sub(r"([A-Z]+[0-9]+)(?!\()", r".\1", s)