Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Issues with processing complex XLSX templates

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 

Attachments

1

Activity

Show:

Grace Potma October 29, 2024 at 3:13 AM

Quarterly Clean-Up Notice
This issue has not been updated in >1 year, and so has been identified as a Graveyard candidate - i.e. it will be auto-closed in 2 weeks.

If you want to keep this issue open (e.g. because it remains a priority or important thing to fix), please add a comment here explaining why, and remove the “Graveyard_CANDIDATE” label.

For questions, you can reach out to .

Piotr Wargulak March 10, 2022 at 12:31 PM

 Thanks for the info, I'll look into it. Looks like there is no 'date formatting' in the cell, just regular number. 

Mike Seaton March 10, 2022 at 12:02 AM
Edited

I've only tested on one report so far, but there does appear to be a regression. See the "Date d'execution du report". Here you have a screenshot that shows the template, the existing rendered output, and the rendered output with the new omod. See Screenshot attached.

Proscovia Niyonsaba March 9, 2022 at 9:36 AM

Piotr Wargulak That is relief, was worried how I will manage, However I will try and do personal contribution that won't affect it's progress.

Piotr Wargulak March 9, 2022 at 7:53 AM

 nothing seems to be wrong, I'm still an assignee. 

Details

Assignee

Reporter

Labels

Complexity

Undetermined

Priority

Created August 24, 2020 at 8:21 AM
Updated October 29, 2024 at 3:13 AM