Maximum Number of Fonts Exceeded

[GoogleCodeExporter]

Thanks for this awesome Excel Emitter it has met the majority of our needs. We 
are just having a bit of an issue with regards to exceeding the maximum number 
of fonts allowed.

Our setup is as follows:

BIRT runtime 2.6.2
Excel 2010
Windows 7 Professional

1. Using BIRT runtime 2.6.2 we are creating a report that spans 144 rows and 9 
columns. The report is making use of a styles library.
2. After exporting the report as Excel and opening it in Excel 2010 we get the 
following message:

Protected View - Office has detected a problem with this file. Editing it may 
harm your computer. Click for more details.

3. When we selected all the rows of the Excel file and manually set their font 
to be "Arial", closed the file and opened it again we no longer got the 
Protected View message.
4. With a fresh version of the problematic report we then tried limiting the 
number of rows produced to just 5 and no longer got the Protected View message.
5. We also tried removing all styles from the BIRT library ran a fresh report, 
exported as Excel and got the following message when we opened it:

Some text formatting may have changed in this file because the maximum number 
of fonts was exceeded. It may help to close other documents and try again.

While it is still possible to view / edit Excel reports that show this message 
it would be great if there was a way to do away with it.

Original issue reported on code.google.com by tothebat...@gmail.com on 24 Nov 2011 at 2:43

[GoogleCodeExporter]

This does not happen if you use the office2007 output format:

options.setOption(IExcelRenderOption.OFFICE_VERSION, "office2007");

Or using the viewer, add the following parameter in BirtExportReportDialog.js:

__excelRenderOption.officeVersion=office2007

See http://www.eclipse.org/forums/index.php/t/390792/

Original comment by jordi.be...@gmail.com on 8 Apr 2013 at 10:26