BUG Cells unmerged when press delete key lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- Tavr · 2021-06-03 07:47 When I press DELETE key in merged cells - cells unmerged. In addition, another problem, when editing merged cells Editor shown only in first cell of merged cells (EditorLineMode=elmMultiLine) Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i procedure TsWorksheet.EraseCell(ACell: PCell; AKeepFormat: Boolean = false);var  r, c: Cardinal;begin  if ACell <> nil then begin    r := ACell^.Row;  c := ACell^.Col;     // Unmerge range if the cell is the base of a merged block    if IsMergeBase(ACell) then      UnmergeCells(r, c); ---------------------------------------------------------------------- wp · 2021-06-03 10:05 Quote from: Tavr on June 03, 2021, 09:47:03 amWhen I press DELETE key in merged cells - cells unmerged. I modified the EraseCell method so that the KeepFormat parameter is respected also for merged cells. Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i procedure TsWorksheet.EraseCell(ACell: PCell; AKeepFormat: Boolean = false);...    // Unmerge range if the cell is the base of a merged block    if IsMergeBase(ACell) and not AKeepFormat then      UnmergeCells(r, c);... Quote from: Tavr on June 03, 2021, 09:47:03 amIn addition, another problem, when editing merged cells Editor shown only in first cell of merged cells (EditorLineMode=elmMultiLine)This is by design. I always was confused by Excel treating all cells of a merged block equally although only the left/upper cell can be modified and carries the format of the block.