Excel color palette

JasperReports allows you to use any color for your report elements.
However, when exporting to XLS format, you have to be aware that this type of files supports only a limited set of colors.
Here is the Standard Excel Color Palette containing all the 40 colors that XLS may use. Make sure you use one of these colors if you want to eventually export your reports to XLS format.

If the colors you use in your report designs do not match any of these acceptable colors, the XLS exporter will use a special algorithm to determine which is the nearest one by comparing the RGB levels. But the results might not be always what you expect.

JasperReports supplies a way to avoid this, enlarging the number of possible color choices. If the export is performed using the JExcelApiExporter class, one have to consider the JExcelApiExporterParameter.CREATE_CUSTOM_PALETTE export parameter. It is a flag specifying whether the standard color palette should be customized so that the XLS result uses the original report colors.

If this flag is not set, the nearest color from the standard XLS palette is chosen for a report color.

If the flag is set, the nearest not yet modified color from the palette is chosen and modified to exactly match the report color. If all the colors from the palette are modified (the palette still has a fixed size), the nearest color from the palette is chosen for further report colors.