Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 348055 - excel export troubleshoot
Summary: excel export troubleshoot
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.6.2   Edit
Hardware: PC Windows 2000
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Birt-ReportEngine-inbox@eclipse.org CLA
QA Contact: Xiaoying Gu CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-06-02 05:33 EDT by Raph_1 CLA
Modified: 2011-06-10 05:55 EDT (History)
3 users (show)

See Also:

Attachments
here is my report renamed as txt (96.90 KB, text/plain)
2011-06-07 04:43 EDT, Raph_1 CLA 		no flags Details
testreport (88.28 KB, application/octet-stream)
2011-06-10 01:53 EDT, Ruo Yin CLA 		no flags Details
View All 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 Raph_1 CLA 2011-06-02 05:33:36 EDT 
Build Identifier: birt run times 2 6 2

On the same report, or the report upgraded with Birt designer 262,
the export using excel format fails, i m using excel 2007.
I have 2 folders on the tomcat server, one folder uses runtimes v 2.3.2, the report exports fine on excel (open file or save file), with the 2.6 version, excel freeze, and nothing happens. So we have to use the export data way.
The file contains 65 columns and 800 rows.The report displays 16 pages. I tried with another report that contains less datas, and it's exporting fine.
It seems to be a memory issue but it s just a idea.

Reproducible: Always
Comment 1 Jun Ouyang CLA 2011-06-02 05:37:57 EDT 
Please attach the document generated from the design.
Comment 2 Raph_1 CLA 2011-06-06 12:39:34 EDT 
I have to mention that the report finally exports, but it takes a very long time, approx. 5 or 10 minutes, compared to 20 seconds with runtimes 2.3.2.
So users can t wait so long. But we can t say it doesn t work, it s just very very slow. Do you want me to post the .rptdesign report ?

raph
Comment 3 Jun Ouyang CLA 2011-06-06 23:38:06 EDT 
Yes, please attach the report design( report document would be better if you'd like). It would help much to locate the problem. Thanks.
Comment 4 Raph_1 CLA 2011-06-07 04:43:48 EDT 
Created attachment 197484 [details]
here is my report renamed as txt

Hello,

I just changed the servername, login and password.

Raph
Comment 5 Ruo Yin CLA 2011-06-10 01:06:51 EDT 
(In reply to comment #4)
> Created attachment 197484 [details]
> here is my report renamed as txt
> Hello,
> I just changed the servername, login and password.
> Raph

Hi, 
I've tried your rptdesign in Birt designer. The xls file generation takes no more than 10 seconds. What takes 5-10 min is for excel to read and open the .xls file as the file seems a bit large (around 24.8M). Just to confirm if this is the case?
Comment 6 Ruo Yin CLA 2011-06-10 01:53:14 EDT 
Created attachment 197752 [details]
testreport

Rhaph, please try if you can still reproduce this bug by using the report I uploaded. Thanks
Comment 7 Raph_1 CLA 2011-06-10 05:49:28 EDT 
Hi,

Thank you for the work, but the thing is I m not able to correctlty modify the report to make it work on my Oracle server, I pasted the <data-sources> parameters, but i seems I steel have xml errors, I understood you build some scripted datasource and dataset I m not able to fix on my report.

Raph
Comment 8 Ruo Yin CLA 2011-06-10 05:55:38 EDT 
Could you use our report directly instead of integrating some part of it into your own report? Thanks