More Information On Rendering To Excel

1) Selection of font - Excel doesn't support Java's font. Using more common fonts such as Times New Roman or Arial etc will deliver a correct output.

2) Excel has different font metrics from other applications, meaning that the width and line spacing are further apart than it should be. As Excel doesn't allow the control of the line spacing, you can adjust the line spacing in the designer to match the value Excel uses.

Therefore to achieve a better aligned Excel output, try the follow steps:

1) Choose a supported font

2) Include a little left and right padding (to allow for the metrics differences in the width). 3px padding on left and right is applied for this sample

3) Adjust the line spacing in the Report to 115% to match the value used by Excel. (Note that Line Height feature is only available in Elixir Repertoire version 7.0 and above)

This sample consists of 2 reports

• renderInExcel1.rml without the above steps applied to it.
• renderInExcel2.rml with the above steps applied to it.

Sample

-- Main.ZacSim - 10 Jul 2007