Import Stops Working While Processing XLSX/XLS File
Applies to: Transact 2020.1 and above.
Issue
Document import stops processing when importing an XLSX/XLS file.
Root Cause
Due to a LibreOffice limitation, this issue occurs when XLSX/XLS files contain a column count that exceeds 1,024 or a row count that exceeds 1,048,576. Please refer to Maximum Number of Rows, Columns, Cells in LibreOffice Calc for more information.
Solution
To resolve this issue, follow the steps below.
- Open Task Manager and stop the batch process that is stuck.
- End Ephesoft Transact in Task Manager.
- Navigate to [Ephesoft_Directory]\Application\WEB-INF\classes\META-INF\dcma-open-office.
- Open the open-office.properties file.
- Locate the following property:
openoffice.startCommandForWindows=cmd /c soffice.exe -invisible -accept=socket,host=localhost,port=8100;urp;
- Change the property to:
openoffice.startCommandForWindows=cmd /c soffice.exe --headless -accept=socket,host=localhost,port=8100;urp;
- Save the file.
- Restart the Transact service and re-import the document.