500979 – Nested HTML tables cause an exception when exporting a report to XLS/XLSX

Bug 500979 - Nested HTML tables cause an exception when exporting a report to XLS/XLSX

Summary: Nested HTML tables cause an exception when exporting a report to XLS/XLSX

Status:	NEW

Alias:	None

Product:	z_Archived
Classification:	Eclipse Foundation
Component:	BIRT (show other bugs)
Version:	4.6.0
Hardware:	PC Windows 7

Importance:	P3 normal (vote)
Target Milestone:	---
Assignee:	Birt-ReportEngine-inbox@eclipse.org
QA Contact:

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2016-09-07 07:26 EDT by Niklas Deutschmann
Modified:	2016-09-07 10:29 EDT (History)
CC List:	1 user (show)

See Also:

Attachments
Report created with BIRT Report Designer 4.4.2 (9.85 KB, application/octet-stream) 2016-09-07 07:26 EDT, Niklas Deutschmann	no flags	Details
Input for flat file data source (129 bytes, application/vnd.ms-excel) 2016-09-07 07:28 EDT, Niklas Deutschmann	no flags	Details
Error Stack Trace (31.86 KB, text/html) 2016-09-07 07:31 EDT, Niklas Deutschmann	no flags	Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Niklas Deutschmann

2016-09-07 07:26:45 EDT

Created attachment 264002 [details]
Report created with BIRT Report Designer 4.4.2

When a report is exported to XLS or XLSX, the Excel emitter fails if some data field of type "Dynamic Text" contains HTML that is not escaped, and the HTML markup contains nested tables (a "table" element inside the cell of another "table" element)

Attached is:
- a sample .rptdesign file
- The input file for the Flat File Data Source
- The error stack trace

We are using BIRT in our application, and some reports created by our customers output the (HTML) descriptions of reported items. So it is very important for us that this will be handled gracefully.

Comment 1 Niklas Deutschmann

2016-09-07 07:28:22 EDT

Created attachment 264003 [details]
Input for flat file data source

Comment 2 Niklas Deutschmann

2016-09-07 07:31:10 EDT

Created attachment 264004 [details]
Error Stack Trace

Comment 3 Niklas Deutschmann

2016-09-07 07:42:00 EDT

The error occurs with the following emitters:
- XLSX
- XLS_SPUDSOFT

Comment 4 Niklas Deutschmann

2016-09-07 10:29:27 EDT

I can reproduce the problem even with the latest version of the BIRT Report Designer (4.6.0)