You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2007/11/07 16:16:57 UTC
DO NOT REPLY [Bug 43807] New: - Problems with "sheet.addMergedRegion()" in Excel 2003 SP3 if colFrom is greater than colTo
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=43807>.
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=43807
Summary: Problems with "sheet.addMergedRegion()" in Excel 2003
SP3 if colFrom is greater than colTo
Product: POI
Version: 3.0
Platform: All
OS/Version: other
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: ciprian.mihalache@alcatel-lucent.ro
In a Java program which exports an xls file, let's say that we have the
following code:
HSSFWorkbook wb = ... //initialization goes here
HSSFSheet sheet = wb.getSheetAt(0);
sheet.addMergedRegion(new Region(1, (short)3, 1, (short)2));
//do other things there and in the end call wb.write(some FileOutputStream file)
If you open the exported file with Excel 2003 SP2 you will not receive any error
or warning message, and everything seems to be ok.
If you open the exported file with Excel 2003 SP3 you get an error message that
Excel found unreadable content in that file. If you want it to recover the file,
all the exported data (numbers, Strings...) are present in the exported file,
but all cell styles, merged cells, preferred width for columns are lost.
Sincerely, I would prefer an IllegalArgumentException thrown by addMergedRegion
if colFrom is greater than colTo instead of this behavior.
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 43807] - Problems with "sheet.addMergedRegion()" in Excel 2003 SP3 if colFrom is greater than colTo
Posted by bu...@apache.org.
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=43807>.
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=43807
nick@torchbox.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
------- Additional Comments From nick@torchbox.com 2007-11-12 14:24 -------
An IllegalArgumentException will now be thrown
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org