AddComment generates two output comments
NR-Main opened this issue · 1 comments
In the resulting output you can see there are two comments for cell B22.
Resulting output:
<comment ref="B22" authorId="0"> <text> <d:r xmlns:d="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <rPr> <sz val="11" /> <rFont val="Calibri" /> </rPr> <t xml:space="preserve">Comment test</t> </d:r> </text> </comment> <comment ref="B22" authorId="0"> <text> <d:r xmlns:d="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <rPr> <sz val="11" /> <rFont val="Calibri" /> </rPr> <t xml:space="preserve">Comments test</t> </d:r> </text> </comment>
There are two cells which are merged, Epplus adds two comments, but that does not sit well with Excel. Have to find a way to set comment only to one cell and it will work properly.