Bug 57697 - Comments added have transparent textbox with no background color
Summary: Comments added have transparent textbox with no background color
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.10-FINAL
Hardware: PC All
: P1 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-13 04:40 UTC by Neelakshi
Modified: 2016-06-15 10:47 UTC (History)
1 user (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Neelakshi 2015-03-13 04:40:07 UTC 
Hi All,

Following are the question:
Problem1:
I am using XSSF POI object. I have added comments in the excel generated. I donot understand how to modify comment box background color and comment box border using XSSF.

Problem2:
At times I am getting transparent comment box while at other time I am getting normal excel feature comment box using XSSF object. Please let me know how to resolve this.

Please respond at the earliest.

Thanks,

Regards,
Comment 1 Dominik Stadler 2015-09-13 21:07:37 UTC 
Can you provide some sample java code that shows the problem? Preferably as unit-test so it can be added to the test-suite for POI?
Comment 2 Javen O'Neal 2016-06-15 10:47:12 UTC 
Closing due to no response in over a year.
Refer to the user guide how to create a cell comment in XSSF. With that code, I get the default yellow background in Excel.

Please take usage questions to the POI user mailing list.