https://bz.apache.org/bugzilla/show_bug.cgi?id=58910
Bug ID: 58910
Summary: org.apache.xmlbeans.impl.values.XmlValueDisconnectedEx
ception when first column removed from template
Product: POI
Version: 3.14-dev
Hardware: All
OS: Mac OS X 10.4
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 33478
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33478&action=edit
Modified Template
When the very first column of a template (blank) is removed, during report
creation an XmlValueDisconnectedException occurs. Attached is the template
version that is modified and causes the error. Notice that the very first
column is not empty and is supposed to have output written to it... When there
is a blank column "A", and the output is written from column "B", the error
does not result.
I was able to get around this issue by changing the template file format to
.xls instead of .xlsx... Many times if the error was not caught, the .xsls
report would need to be "repaired" before opening. When I looked into this
further, it seems as though the XML tags for the sheet are being generated out
of order.
Ex:
<row r="14" ht="15.75" customHeight="true">
...
</row>
<row r="15" ht="15.75" customHeight="true">
...
</row>
<row r="19">
...
</row>
<row r="16" ht="15.75" customHeight="true">
...
</row>
<row r="18" ht="15.75" customHeight="true">
...
</row>
<row r="17" ht="15.75" customHeight="true">
...
</row>
<row r="20" ht="15.75" customHeight="true">
...
</row>
<row r="21" ht="15.75" customHeight="true">
...
</row>
When the report generated had less than 200 rows, I was able to "repair" and
open the report but rows would be removed from my results. When more data was
to be returned, the XmlValueDisconnectException would result and report
generation would fail.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
