Bug 57697

Summary:	Comments added have transparent textbox with no background color
Product:	POI	Reporter:	Neelakshi <bishnoi.neelakshi>
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	bishnoi.neelakshi
Priority:	P1
Version:	3.10-FINAL
Target Milestone:	---
Hardware:	PC
OS:	All

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.