Uploaded image for project: 'Reporting Module'
  1. Reporting Module
  2. REPORT-870

Issues with processing complex XLSX templates

    XMLWordPrintable

Details

    • Bug
    • Status: In Progress
    • Should
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      Report render based on the XLSX template causing an issue with report generation.

       

      org.openmrs.module.reporting.report.renderer.RenderingException: Unable to render results due to: org.apache.xmlbeans.impl.values.XmlValueDisconnectedException
      at org.openmrs.module.reporting.report.renderer.ExcelTemplateRenderer.render(ExcelTemplateRenderer.java:142)
      at org.openmrs.module.reporting.report.service.ReportServiceImpl.runReport(ReportServiceImpl.java:487)

       

      Noticed issues:

      • The issue is related to a database table constraint. The column `content_type` from `reporting_report_design_resource` table can store max 50 character for XLSX the `content type` value is `application/vnd.openxmlformats-officedocument.spreadsheetml.sheet` (65 characters). 
      • The problem with writing to a sheet, then reading from it. For example, if you have 3 rows in the sheet, then add a row at index 2, reading from 3 produces the xml disconnected exception.
      • Additionally there exist issues with losing complex objects (such as charts) because of copy over everything.
      • One more noticed issue is with the formulas they are copied for all empty rows if for example we have data in only two rows.

       

      ACC:

      • the issues were investigated
      • the issues were resolved 

      Gliffy Diagrams

        Attachments

          Activity

            People

              pwargulak Piotr Wargulak
              alalo Arkadiusz Lalo
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: