'openpyxl formula not change with insert or delete operation

def insert_cols(self, idx, amount=1):
    """
    Insert column or columns before col==idx
    """
    self._move_cells(min_col=idx, offset=amount, row_or_col="column")

After i use the insert function in openpyxl, the original formula in the excel file will still keep the same, for example, for one cell, its formula is "=A1", after i insert one column at col=1, i think this formula should be auto changed to "B1"， but it still keep "A1", how could i make it changed followed the excel col or row information changed by using openpyxl?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'openpyxl formula not change with insert or delete operation

Sources

Related Questions