Hi,
private static String [] columnText =
{
/* campaign decomp */ "This column addresses whether the variable being measured is representative of the total campaign or only a part or decomposition of the total.",
/* campaign var */ "The aspect of the campaign being measured. Typically it is an individual creative or audience part, broken out by an attribute previously determined in the SOW.",
/* net dollar eff */ "Measures the net dollars spent on the brand among each confirmed category purchase occasion.\n\nThe higher the number, the better the variable is performing relative to all the other variables. If the number is above 100, the variable is performing better than the average of all variables.",
/* current % distr */ "This column, reported as a percent, indicates the current distribution of impressions being received by NCS and counted in InFlight for each variable as a percent of the total distribution. ",
/* impress deliv */ "The values in this column report the number of impressions observed for each variable within the exposure window between the start and end dates indicated in the fifth and sixth rows of the report, and the total number of impressions delivered over the life of the report.",
/* est min impress */ "This value indicates approximately what amount of impressions must be delivered through each variable so that it will deliver the minimum number of exposed brand purchase occasions (50) required for it to contribute to the effectiveness indices.\n\nThis is calculated as:\nCurrent Impressions Delivered divided by (Exposed Purchases / 50)\n\nPurchases are counted when a household that was exposed to the tactic, within the exposure window, was likely to have purchased the brand as a result of having been exposed."
};
.
.
.
Here's where I add the comments to the cells:
int [] colMap = {0, 1, 2, 4, 6, 8}; // used to get the real position of the merged cells
for(col = 0; col < 6; col++)
{
// add the comment for the column
Comment comment = weekEndingWS.getComments().get(weekEndingWS.getComments().add(row, colMap[col]));
Font cFont = comment.getFont();
cFont.setSize(8);
cFont.setBold(false);
comment.setNote(columnText[col]);
comment.setAutoSize(false);
comment.setHeightInch(3);
comment.setWidthInch(2);
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Futura; color: #4e9072} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Futura; min-height: 14.0px} p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Futura} span.s1 {color: #000000} span.s2 {color: #931a68} span.s3 {color: #7e504f} span.s4 {color: #0326cc} span.Apple-tab-span {white-space:pre}
}