This issue has been created
 
 
XWiki Platform / cid:jira-generated-image-avatar-fafafcf6-5d1a-438f-9968-712f2c9de4fc XWIKI-22628 Open

Can't export an excel file containing a very large table, as ODT or RTF

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-e04f4073-f083-4e4d-9cbc-79fd6cf3368a Gabriela Anechitoaei created this issue on 01/Nov/24 20:36
 
Summary: Can't export an excel file containing a very large table, as ODT or RTF
Issue Type: cid:jira-generated-image-avatar-fafafcf6-5d1a-438f-9968-712f2c9de4fc Bug
Affects Versions: 16.4.4
Assignee: Unassigned
Attachments: Notice.jpg, Notice2.jpg, WikiError.txt
Components: Office
Created: 01/Nov/24 20:36
Environment: Windows 11 Pro, XWiki 16.4.4 (with Standard Jetty Servlet Container and HSQLDB database), Chrome 130
Priority: cid:jira-generated-image-static-major-85ae2839-7085-4375-9745-90e6889f2b16 Major
Reporter: Gabriela Anechitoaei
Description:

Preconditions: LibreOffice 24.2.6 must be configured and started.

Steps to reproduce:

  1. Create a new page selecting Type > Page from Office
  2. Select the attached large Office document (002-[TEST]English-wide-table-1Sheet.xlsx)
  3. Click on Import
  4. Access the page
  5. Click on More actions > Export > Export as ODT / RTF

Expected results: The page is exported as ODT / RTF

Actual results: An error page appears in the wiki "A problem occurred while trying to process your request. Please contact the webmaster if this happens again." and many error messages in the console - the errors can be seen in WikiError.txt

NOTE: I've tried to make some changes I did in the past that used to help, but in this case it didn't.

  1. I've Increased Java Memory in Windows (-Xmx2048m)
  2. I've cleared all the temporary files (C:\Users\gabri\AppData\Local\Temp)
  3. I've changed the Timeout for the OpenOffice server in xwiki.properties (openoffice.taskExecutionTimeout=240000)
  4. I've changed the Time Out for Libre to 300 seconds (https://ask.libreoffice.org/en/question/4574/libreoffice-base-connection-times-out-after-60-seconds-how-do-you-keep-a-connection-alivereconnect-without-restarting/)

 

42886_Notice.jpg

42885_Notice2.jpg