Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-22628

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Critical
    • None
    • 16.4.4
    • Office
    • None
    • Windows 11 Pro, XWiki 16.4.4 (with Standard Jetty Servlet Container and HSQLDB database), Chrome 130
    • Unknown

    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=24000)
      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/)
      5. I've set 0 to disable the MAXIMUM CONTENT SIZE of 5000KB limit completely (Administer Wiki > Content >  PDF Export)

       

      Attachments

        1. WikiError.txt
          83 kB
        2. Notice2.jpg
          Notice2.jpg
          359 kB
        3. Notice.jpg
          Notice.jpg
          304 kB
        4. Cloud ODT Export 004.jpg
          Cloud ODT Export 004.jpg
          369 kB
        5. 004-[TEST]Formulas-Filters-1SheetXLSX - Copy.xlsx
          1.29 MB
        6. 002-[TEST]English-wide-table-1Sheet.xlsx
          525 kB

        Activity

          People

            Unassigned Unassigned
            ganechitoaei Gabriela Anechitoaei
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: