Excel Exporter and Timezone Not Applied

Hi,

 

1) Could you give us some more details about this problem? When you say "Excel Exporter", do you mean exporting to Excel using the "JRXlsExporter" class, or the "JExcelApiExporter" one?

 

2) When using POI (ie JRXlsExporter) there are a set of builtin data format patterns (see http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFDataFormat.html), and a set of recognized format symbols. Unfortunately, the timezone \'z\' or \'Z\' characters are not included, and so are the \'E\', \'w\' and \'W\' too. Excel does not recognize them as part of date formatting. That explains them being written "as it is".

We introduced a new exporter parameter (FORMAT_PATTERNS_MAP) to allow translating the

text field patterns to XLS exporter specific cell format patterns. This is a map containing the classic java format pattern as key, and the corresponding proprietary format pattern as value, and you can see an example after downloading compiling and executing the "jasper" sample (http://scm.jasperforge.org/svn/repos/jasperreports). The corresponding pattern you choose may not look 100% like the java pattern, you have to decide the better way to keep the most part of information in the new data representation.

 

Regards,

sanda

 

Hi,

 

Anything new on this one?

If not, we are going to close it.

 

Thank you,

Teodor

 

Teodor,

 

I\'m not currently on the project utilizing Jasper Reports...Dave are

you aware if this is still an issue?

 

On Nov 22, 2006, at 5:57 AM, JasperForge Administrator wrote:

 

>

> artf1553: Excel Exporter and Timezone Not Applied

>

> Modified on 11/22/2006 by Teodor Danciu

>

> Comment was added:

>

> Hi,

>

> Anything new on this one?

> If not, we are going to close it.

>

> Thank you,

> Teodor

>

>

> Respond by visiting:

> http://www.jasperforge.org/sf/go/artf1553

>

> ---------------------------------------------------------------------

> Artifact details:-

>

> Project: JasperReports

> Tracker: Bugs

>

> Group:

> Status: Open

> Category:

> Customer:

> Priority: 4

> Assigned To: No user

> Reported in release: none

> Fixed in release: none

> Estimated Hours: 0

> Actual Hours: 0

>

> Description: 1) The date used in the "Excel Exporter" does not

> account for the timezone defined for the report;

>

> 2) When defining a date format pattern that includes the timezone

> symbol ("z"), the "z" is displayed as part of the date output.

>

 

Changed Assigned User from - to @teodord

---