.net - String formatting of cell comments EPPLUS library -
is possible format comments when creating .xlsx file using epplus? far know method is:
excelcomment addcomment(string text, string author);
are there other known limitation comments library?
if yes there better alternative in .net ?
as turns out wrong in deciding prematurely epplus limited
comment format
the addcomment method created object , returns it. way edit objects using richtextcollection inside excelcomment
this example puts in bold part of cell comment:
excelcomment commento = witem.addcomment(null, "sys"); commento.richtext.removeat(0); excelrichtext ert = commento.richtext.add(dataitem.commento[0]); ert.bold = true; ert = commento.richtext.add(dataitem.commento[1]); ert.bold = false;
truncation
as truncation wasn't visible @ first because of dimension of comment bubble.
used autofit property
witem.comment.autofit = true;
Comments
Post a Comment