Error merging cells if the span includes the Z and AA column

[RafaPolit]

Thanks for this wonderful tool!

I am seeing a very weird issue:

• if I merge more than 2 cells in a span that includes the Z and AA columns (either with cells before the Z column, after the AA column or both), only Z and AA columns are merged, and all the others are kept with the original text but not merged.

To test this, a simple line will do:

• ws.Cell(5, 25, 5, 28, true).String('Problem')

You will see that the Y cell has the text and remains unmerged, then columns Z and AA are merged, and then column AB will be unmerged again and hold the text individually.

Thanks for any solution,

Best regards,
Rafael Pólit.

[natergj]

Hello RafaPolit,
Thanks for letting me know about this issue. it turned out to be an error in my sort function for sorting an array of Excel references that would put AA ahead of Z. This has been resolved and the updated package pushed to npmjs.com.

[RafaPolit]

Fantastic swift response! It's a pleasure working with your library and to see such dedication. Thanks.