WFS fields larger than 32000 characters corrupt Excel output
------------------------------------------------------------
Key: GEOS-3598
URL: http://jira.codehaus.org/browse/GEOS-3598
Project: GeoServer
Issue Type: Bug
Components: Excel
Affects Versions: 1.7.7, 1.7.6, 1.7.5, 1.7.4, 1.7.3, 1.7.2
Reporter: Shane StClair
Assignee: Andrea Aime
Priority: Minor
Attachments: ExcelOutputFormat.patch
When WFS data is exported to Excel, inclusion of fields containing more than 32,767 characters results in a corrupted workbook. Opening the workbook in Excel gives the following message:
Excel found unreadable content in Book_Name. Do you want to recover the contents of this workbook.
Choosing yes results in spreadsheets missing many data values and columns.
The error stems from Excel's limit of 32,767 characters per cell. Attached patch checks string length, truncates if necessary, and places warning text in the cell if data was truncated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira