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.

  1. Open Task Manager and stop 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. Save the file.
  8. Restart the Transact service and re-import the document.

Related Articles