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\桌面\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.