I'm doing some excel sheet Python automation using openpyxl and I'm having an issue when I try to insert columns or rows into my sheet. 
I'm modifying an existing excel sheet which has basic formula in it (i.e. =F2-G2) however when I insert a row or column before these cells, the formula do not adjust accordingly like they would if you would perform that action in excel. 
For example, inserting a column before column F should change the formula to =G2-H2 but instead it stays at =F2-G2...
Is there any way to work around this issue? I can't really iterate through all the cells and fix the formula because the file contains many columns with formula in them.
openpyxl is a file format library and not an application like Excel and does not attempt to provide the same functionality. Translating formulae in cells that are moved should be possible with the library's tokeniser but this ignores any formulae that refer to the cells being moved on the same worksheet or in the same workbook.
Maintaining Formulae when Adding Rows/Columns