Delete rows but translate remaining rows

[Brian Murrell (Brian J. Murrell)]

I want to delete a series of rows:

ws.delete(10, 10)

But then I want any formulas in the remaining rows' cells to be translated to account for the fact they have been moved up 10 rows.

Any thoughts on the best way to go about this?

[Michel MARTIN]

Hey Brian,

Did you read this page?

Inserting and deleting rows and columns, moving ranges of cells — openpyxl 3.1.3 documentation

     Michel

[Brian Murrell (Brian J. Murrell)]

Are you referring to the block of text that reads:

Note Openpyxl does not manage dependencies, such as formulae, tables, charts, etc., when rows or columns are inserted or deleted. This is considered to be out of scope for a library that focuses on managing the file format. As a result, client code must implement the functionality required in any particular use case.

?

If so, it's a good thing I went ahead and did implement my own functionality for that.  :-)