When working with
.xlsx files within an Excel layout, you may encounter this error:Error in UI:
- #UCAM002: A capture processing error occurred for source .
- Strict OOXML isn't currently supported, please see bug #57699
Error in logs:
Caused by: org.apache.poi.POIXMLException: Strict OOXML isn't currently supported, please see bug #57699
The error is referring to a conflict between two unique file types that share the same
.xlsx file extension:- Excel workbook
- Strict Open XML Spreadsheet
Both of these file types are available in Excel as a file type while saving (see screenshot below, but they don't share the same file structure despite having the same file extension:
Assure's Excel layout leverages Apache POI to read Excel and various other proprietary file types. Apache POI is the standard amongst Java applications. However, Apache POI only supports real Excel workbooks and not Strict Open XML Spreadsheets. This is in the pipeline for Apache to add (source), which is also the bug 57699 referenced in the error message.
The workaround is to select the
Excel Workbook (*.xlsx) option when saving an Excel spreadsheet.
Comments
0 comments
Please sign in to leave a comment.