| Summary: | XSSF created text box cannot show font color and size effects. | ||
|---|---|---|---|
| Product: | POI | Reporter: | Jack <duanxingjian> |
| Component: | XSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED WONTFIX | ||
| Severity: | normal | ||
| Priority: | P2 | ||
| Version: | 3.7-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows Vista | ||
| Attachments: | POI generated a rich text fonts inside a textbox vs. a cell. | ||
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 No update in a long time, therefore setting this to WONTFIX for now. |
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.