Export Set (Format - xls,xlsx , Column value - Use Raw ) Errors Out if the Cell Content is More Than 32,767 Characters: "SEVERE *** ERROR *** The maximum length of cell contents (text) is 32,767 characters - Known Error

Export Set (Format - xls,xlsx , Column value - Use Raw ) Errors Out if the Cell Content is More Than 32,767 Characters: "SEVERE *** ERROR *** The maximum length of cell contents (text) is 32,767 characters Description Export Set with Format - xls,xlsx, and Column value - Use Raw value errors out if the cell content is more than 32,767 characters and the export doesn't complete:

"SEVERE *** ERROR *** The maximum length of cell contents (text) is 32,767 characters java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters"

Same works if the Column value is set as "Use display value" in the export set.

Steps to Reproduce

1. Set "description" max length to 40,000 in incident table.(sys_dictionary) 2. Create an incident record with description content more than 32,767 characters 3. Create an Export set with format xls or xlsx And Column Name "Use Raw Value" 4. Create an export definition to export the above-created incident record. 5. Click test load 20 records.

Expected: System truncates the description value and saves in xls/xlsx format. This is what happens with the "Use Display value" configuration.

Actual: It errors out saying "The maximum length of cell contents (text) is 32,767 characters" and the export did not complete.

Workaround The available workarounds are:

1. Export as CSV 2. Export as xls/xlsx with column value "Use display value"