Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 317831 - Wrong data types in excel export
Summary: Wrong data types in excel export
Status: RESOLVED WORKSFORME
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Birt-Converter-inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-24 10:24 EDT by gerd.guehne.ecg CLA
Modified: 2010-08-24 02:02 EDT (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description gerd.guehne.ecg CLA 2010-06-24 10:24:14 EDT 
Build Identifier: 20100218-1602

Hello,

We found a problem in the export to excel from an html report. Numbers were detected as strings. Because of this we must select all columns/rows in the excel files and change the format to number.
The ExcelUtil class has a method called "getType" which only use instanceOf to detect numbers. An additional check of NaN works better. Because of this the method "addDataContent" in class ExcelEmitter does not work correctly. 

This problem was found in the latest org.eclipse.birt.report.engine.emitter.prototype.excel.source_2.5.2.v20100201.jar library.

When will a bug fix be available?   

Thanks for your answer!


Reproducible: Always

Steps to Reproduce:
1. generate a html report
2. export to excel
3. not all cells are a type of number
Comment 1 Xiaoying Gu CLA 2010-08-02 04:06:15 EDT 
Would you please attache a example report using the sample db?
I can not reproduce this issue in current release.
Comment 2 Xiaoying Gu CLA 2010-08-24 02:02:07 EDT 
Set as worksforme based on comment #1

Feel free to reopen if have any problem or attaching a sample that can reproduce the issue..