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

        Activity

          People

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

            Dates

              Created:
              Updated: