Insert Row + Merged Cells

[Nicolas.P]

When I want to modify an excel file, using the VI: Insert Row VI (Owning Palette: Utilities) will break all the merged cells below it. 

I have attached a short example where the column 4 and the comment section will be not merged anymore after running the VI

I have tried to find a workaround but I am stuck.

Any help on this subject?

Nicolas

[JensG69]

Hello Nicolas,

sorry for the late reply.

This is a known issue of the underlying NPOI library, to be exact the method "ShiftRows".

Is seems that this has been fixed recently in the code base of NPOI, but there is no official relase yet that incorporates that bug-fix. In addition - since we add a few features for XLR8 to work faster - we are not always releasing a new XLR8 version together with NPOI changes.

As of now I have no workaround for you.

But we keep your bug report in mind - we will keep you updated if there is a new release of XLR8 available.

Sorry for the inconvenience.

Regards,

DATA AHEAD