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 2009/05/28 12:18:42 UTC
DO NOT REPLY [Bug 47278] New: xsi:nil attribute for tag caused
Excel 2007 to fail to open workbook
https://issues.apache.org/bugzilla/show_bug.cgi?id=47278
Summary: xsi:nil attribute for <t> tag caused Excel 2007 to
fail to open workbook
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: eduard.dudar@gmail.com
At some conditions POI XSSF generates the following shared string element:
<si><t xsi:nil="true"/></si>
Opening such workbook caused an error with text like that:
"Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Load
error. Line 2, column 174962.
Removed Records: Cell information from /xl/worksheets/sheet1.xml part"
Column number of course will be different in other examples but points to
element above.
Actually such attribute is valid for XML and says that tag's value is empty but
Excel doesn't understand this. Huh.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47278] xsi:nil attribute for tag caused Excel
2007 to fail to open workbook
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47278
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> 2009-05-30 03:43:48 PST ---
Fixed in r780228 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=780228 ).
Passing null to the XSSFRichTextString constructor resulted in xsi:nil for the
<t> tag. A minimal code to reproduce the behavior is as follows:
XSSFCell cell = sheet.createRow(0).createCell(0);
cell.setCellValue(new XSSFRichTextString((String)null));
I fixed setCellValue to blank cell ( erase all the data previously associated
with this cell) if the argument string is null.
Regards,
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47278] xsi:nil attribute for tag caused Excel
2007 to fail to open workbook
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47278
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2009-05-28 06:45:00 PST ---
Can you post sample code that generates xsi:nil entries in sharedStrings.xml?
It would be helpful to diagnose the problem.
Regards,
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47278] xsi:nil attribute for tag caused Excel
2007 to fail to open workbook
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47278
--- Comment #2 from Eduard Dudar <ed...@gmail.com> 2009-05-28 07:20:48 PST ---
Original source code where I have this is quite tightly coupled within huge
application and will not give any value without own environment. I'm going to
simplify this case as much as it will be possible and will back here.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org