I'm using openpyxl to write a formula to an Excel workbook. The formula generates the error Formula Omits Adjacent Cells. It does omit the adjacent cells, but that is intentional. How do I use openpyxl to ignore the error?
I see there's an error module an https://openpyxl.readthedocs.io/en/latest/api/openpyxl.worksheet.errors.html but I don't know how to use it.
Simplified example:
ws["A1"].value = "=sum(C1:E1)"