exceljs wrapText doesnt work on merge cell

Question

 workSheet.getCell(`B7`).alignment = {
    vertical: 'middle', horizontal: 'left',
    wrapText: true // autoHeight
  };

its only work on 1 cell B7

if i tried to merge cell on B7 and F7 the text doesnt wrap.

i have tried logic with get height after wrapText then merge cell then set height but in first condition i never set height so the value would undefined where the documentation tell the height default is 15 and always undefined if we didnt set/init on first.

  const rowHeight = workSheet.getRow(7).height;
  console.log(`height before merge ${rowHeight}`); // i know this undefined 
  workSheet.mergeCells(`B7`, `D7`);
  const rowAfterMerge = workSheet.getRow(7).height;
  console.log(`height after merge ${rowAfterMerge}`);

i tried to initialize before execute code on above with workSheet.getRow(7).height = 15;

but the value always 15 on get height after on wrapText.

anyone have solution for wrapText on cell where the cell is merge cell ( B7 - F7 ). always got ellipsize blank text.

Answer 1

try to

Unmerge() => Merge()