Page 1 of 1
Another issue when deleting rows: merged cells remain
Posted: Thu Jan 18, 2018 11:03 am
by bturcs
Unfortunetaly I found another issue while deleting rows in an excel sheet. If I use merged cells and delete a range of rows (including the merged cells), they will not get deleted and remain in the document. The result is unsatisfactory because the remaing rows are affected.
Example screenshot:
Here I deleted rows 0 to 4 (index). The merged cell isnt deleted and disturbs the remaining document.
Re: Another issue when deleting rows: merged cells remain
Posted: Mon Jan 22, 2018 1:25 pm
by larsa
Hello
This is fixed in update 6.00.26
Re: Another issue when deleting rows: merged cells remain
Posted: Wed Jan 24, 2018 8:59 am
by bturcs
While I can confirm that it works for:
It does not work for:
- thw row and formatting is deleted but the merged cell is moved to row 4.
The merged cell remains, even if I delete row 5.
Re: Another issue when deleting rows: merged cells remain
Posted: Mon Jan 29, 2018 12:14 pm
by larsa
Hello
There is a new update for this now.
Re: Another issue when deleting rows: merged cells remain
Posted: Wed Jan 31, 2018 3:10 pm
by bturcs
I installed the updated components and can confirm that it is working now.
Re: Another issue when deleting rows: merged cells remain
Posted: Wed Feb 07, 2018 3:05 pm
by bturcs
I'm sorry, but I discovered another problem with merged cells and deleted rows.
Following example:
On the left side, you see the original file. Here, I delete rows from index 21 to index 28 (marked yellow). The result is in the middle: merged cells remain at row index 14 and merged cells are missing on row 23. On the right hand side is the result if I delete the rows manually in Excel. This worken in XLSSUIT4.
Code:
Code: Select all
try
LDoc := TXLSReadWriteII5.Create(nil);
LDoc.Filename := LSource;
LDoc.Read;
LDoc.DeleteRows(0, 21, 28);
LDoc.Filename := LTarget;
LDoc.Write;
finally
freeAndNil(LDoc);
end;
Re: Another issue when deleting rows: merged cells remain
Posted: Wed Feb 28, 2018 3:41 pm
by bturcs
Thank you for your bugfix. With the latest version
6.00.30, I can report that deleting rows works and nice XLS documents are created!
