Bug 50499 - XSSF created text box cannot show font color and size effects.
Summary: XSSF created text box cannot show font color and size effects.
Status: RESOLVED WONTFIX
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.7-FINAL
Hardware: PC Windows Vista
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-19 17:30 UTC by Jack
Modified: 2015-08-23 19:07 UTC (History)
0 users



Attachments
POI generated a rich text fonts inside a textbox vs. a cell. (4.32 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2010-12-19 17:30 UTC, Jack
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jack 2010-12-19 17:30:58 UTC
Created attachment 26424 [details]
POI generated a rich text fonts inside a textbox vs. a cell.

Steps to Reproduce: 
After using the following code to generate a XLSX file, if you open that
generated file (I attached here as "textbox.xlsx") You can see the font inside the textbox doesn't have the effects I set in the code, i.e., xFont.setFontHeightInPoints((short)18); and xFont.setColor(XSSFFont.COLOR_RED); 

Moreover, the textbox acts not exactly the same as those created inside the Excel application in that the fill and boarder color generated by POI can't be changed in Excel App using "Shape Fill" or "Shape Outline" @ Excel Ribbon's Drawing Tools->Format menu -> Shape Fill or Shape Outline. 

Actual Results: 
Please see above.

Build Date & Platform: 
Windows XP, NetBean, Excel 2007, 11/28/2011

Additional Builds and Platforms:
Windows XP, RAD 7.5 12/15/2011, samething happens.
Comment 1 Yegor Kozlov 2011-06-24 09:02:16 UTC
Please try the latest release POI 3.8-beta3.

If the problem is still there, please post a sample code to demonstrate the problem. If it requires an input file then attach that file too.

Yegor
Comment 2 Dominik Stadler 2015-08-23 19:07:38 UTC
No update in a long time, therefore setting this to WONTFIX for now.