KB00023275: Import Stops Working While Processing XLSX/XLS File

Applies to: 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.

  1. Open Task Manager and kill the batch process that is stuck.
  2. End Ephesoft Transact in Task Manager.
  3. Navigate to [Ephesoft_Directory]\Application\WEB-INF\classes\META-INF\dcma-open-office.
  4. Open the open-office.properties file.
  5. Locate the following property:
    openoffice.startCommandForWindows=cmd /c soffice.exe -invisible -accept=socket,host=localhost,port=8100;urp;
  6. Change the property to:
    openoffice.startCommandForWindows=cmd /c soffice.exe --headless -accept=socket,host=localhost,port=8100;urp;
  7. Restart Ephesoft Transact and re-import the file.

Related Articles