Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 331089

Summary:

Error shows when opening an exported report, confirm it related with bookmark expression format in the report.

Product:

z_Archived

Reporter:

Hai Feng Luo <haifengl>

Component:

BIRT

Assignee:

Yu Chen <yChen>

Status:

CLOSED FIXED

QA Contact:

Xiaodan Wang <xwang>

Severity:

normal

Priority:

CC:

bluesoldier, haifengl

Version:

2.3.2

Target Milestone:

3.7.0

Hardware:

OS:

Windows XP

Whiteboard:

Attachments:

Description	Flags
Opening error	none
exported excel file	none
error log	none
report design	none
data source file	none

Description Hai Feng Luo

2010-11-25 03:05:15 EST

Build Identifier: 2.3.2.v20090601-0700

An error "Problems During Load" being prompted when opening an exported excel from my report. The log under C:\Documents and Settings\Administrator\Local Settings\Temporary Internet Files\Content.MSO shows as below:

XML ERROR in Workbook Setting
REASON:	Bad Value
FILE:	C:\Documents and Settings\Administrator\&#26700;&#38754;\Test cases1.xls
GROUP:	Names
TAG:	NamedRange
ATTRIB:	Name
VALUE:	R2A

Open the file by notepad, found this sentence
<Names>
		<NamedRange ss:Name="R2A" ss:RefersTo="=Sheet1!R3C1"/>
</Names>

If I changed R2A to RA, then the excel can be opened successfully. Seems R2A is an illegal format for Name of NamedRange.

In my investigation I found it's related with this element in my report
<expression name="bookmark">row["name"]</expression>
When the row["name"] is R2A, the error occurs.

 The same problem to some formats like C99_NhiTC, r1, etc. 

The problem is that the bookmark expression support those formats, but excel doesn't support that.

I also tried that on 2.5.2, the error still be there.

Reproducible: Always

Steps to Reproduce:
1.build the report I uploaded, use the uploaded xml file as the datasource. Using /root/user/name as the xpath expression when creating Data Set.
2. run the report by view report in web viewer, and names are displayed, then export that as excel
3. open excel, error should be prompted.

Comment 1 Hai Feng Luo

2010-11-25 03:07:28 EST

Created attachment 183828 [details]
Opening error

Comment 2 Hai Feng Luo

2010-11-25 03:08:00 EST

Created attachment 183829 [details]
exported excel file

Comment 3 Hai Feng Luo

2010-11-25 03:08:47 EST

Created attachment 183830 [details]
error log

Comment 4 Hai Feng Luo

2010-11-25 03:09:37 EST

Created attachment 183831 [details]
report design

Comment 5 Hai Feng Luo

2010-11-25 03:10:02 EST

Created attachment 183832 [details]
data source file

Comment 6 Hai Feng Luo

2010-11-25 20:39:09 EST

Hi, would you pls give a workaround asap, our product are waiting for this to be fixed. Thanks!

Comment 7 Yu Chen

2011-01-11 02:40:35 EST

Fixed.