views:

808

answers:

0

When jasper outputs a file in the Excel xls format, the columns when viewed are only the fixed width determined in the jasper XML.

This is a problem when the data in the columns is of varying widths, causing some columns to wrap.

I've had a look at the API and the DTD and there doesn't seem to be a way of setting the column widths to auto adjust.

i.e.instead of displaying as

  emailAdress
  @email.com

display as

  [email protected]

Is it possible to do this at all?

This question is similar to Jasper report column width