openpyxl incorrect delete rows

[VladislavM]

When I delete lines through openpyxl, they are not deleted correctly. In some places they even stay. Need to delete rows completely, as excel does. Thank you.

import openpyxl

this_book = openpyxl.open( "example.xlsx" )
this_book.active = 1

def result_i():
    return 10

i = result_i()

if i < 255:
    this_book.active.delete_rows(i, 255-i)

this_book.save("result.xlsx")
this_book.close()

Example:
https://drive.google.com/file/d/1KINvDVn...sp=sharing

[buran]

Not sure what the problem is (i.e. what you consider problem). It works as expected - it's visible also from your [poor] screenshot. it removes line 10-254 and in the result line 10 is the former line 255. However it does not change the formulas in columns H:W (as expected)

[VladislavM]

Not sure what the problem is (i.e. what you consider problem). It works as expected - it's visible also from your [poor] screenshot. it removes line 10-254 and in the result line 10 is the former line 255. However it does not change the formulas in columns H:W (as expected)

[buran]

Please, explain in writing exactly what the problem is.
As I said

it removes line 10-254 and in the result line 10 is the former line 255. However it does not change the formulas in columns H:W (as expected)

[VladislavM]

Please, explain in writing exactly what the problem is.
As I said

it removes line 10-254 and in the result line 10 is the former line 255. However it does not change the formulas in columns H:W (as expected)

The cell A2 doesnt make smaller, despite I'm using rows removal.

[buran]

The cell A2 doesnt make smaller, despite I'm using rows removal.

But you are deleting rows 10-254, why would that affect A2 or any of the rows 1-9???

[VladislavM]

The cell A2 doesnt make smaller, despite I'm using rows removal.

But you are deleting rows 10-254, why would that affect A2 or any of the rows 1-9???

Because Microsof Office detele merged cell. I understand my wrong, thank you.