How to Ignore Text Formatting in Excel Export

Request Description

Customer created a report and need to remove elemtns formatting (color, style etc) in export to MS Excel

Solution

JasperReports library has a special property which allows to ignore text formatting (such as text color, background color, bold style, italic, underline, etc) in Excel export:

net.sf.jasperreports.export.xls.ignore.text.formatting[/code]

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.ignore.text.formatting

The property can be set at report level (in that case all cells in Excel export will be affected), or at the specific Text Field element.

AS-20200922, case 01889949