DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUGĀ·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=43751>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED ANDĀ·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=43751





------- Additional Comments From [EMAIL PROTECTED]  2007-10-31 08:02 -------
Created an attachment (id=21067)
 --> (http://issues.apache.org/bugzilla/attachment.cgi?id=21067&action=view)
Proposed fix to solve the two issues in the bug report

Here is an updated version of HSSFSheet.java (org.apache.poi.hssf.usermodel)
that fixes the two issues. If you would like a patch instead, let me know. 

The implemented fix solves the rotated text problem by performing some
transformations on the text before determining it's width:

1. First, the text is scaled vertically by a multiple of the font "leading"
value so that text rotated close to 90 degrees will have some whitespace around
it in the final output

2. Second, the text is rotated by the rotation specified in the cell layout

After these transformations the new width is determined from the text bounding
box.

The fix solves the numerical value problem by no longer using DecimalFormat to
format numerical cells that have the Excel "General" format, but instead using
a simple string conversion.


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to