Mar-06-2020, 10:58 AM
Excuse me buran, but it seems that you have not understood my question. When you delete A5 certainly you shorten column A, but this is irrelevant here. What is relevant is that there are no filled cells in row 5. This is what the user sees, but openpyxel does not. And still further.
There are two ways to erase A5. You can select the cell and delete it, or yo can selecte another empty cell, for instance A6, and drag the cross in the the lower right corner to A5. There are 4 rows in both cases. Openpyxl detects the second case, but not the first. This is an anomally that could amount to a bug.
I am not able to determine the exact cause, but I guess it could come either from a cache efect, or from the different inner workings of excel in both cases. It could be also dependent from the excel version. Mine is 2006.
Hope I have made myself clear.
There are two ways to erase A5. You can select the cell and delete it, or yo can selecte another empty cell, for instance A6, and drag the cross in the the lower right corner to A5. There are 4 rows in both cases. Openpyxl detects the second case, but not the first. This is an anomally that could amount to a bug.
I am not able to determine the exact cause, but I guess it could come either from a cache efect, or from the different inner workings of excel in both cases. It could be also dependent from the excel version. Mine is 2006.
Hope I have made myself clear.