Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » XML ERROR in Workbook Setting when opening exported excel(a error like: XML ERROR in Workbook Setting REASON: Bad Value FILE: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\Report-42.xls GROUP: Names TAG: NamedRange ATTRIB: Name VALUE: R2A is showing when I try to open)
icon14.gif  XML ERROR in Workbook Setting when opening exported excel [message #640145] Fri, 19 November 2010 05:34 Go to next message
Eclipse UserFriend
Hi,
an error shows in log like:

XML ERROR in Workbook Setting
REASON: Bad Value
FILE: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\Report-42.xls
GROUP: Names
TAG: NamedRange
ATTRIB: Name
VALUE: R2A

is showing when I try to open a excel, which is exported from my BIRT report.

My birt version is 2.3.2. And then I checked my excel file, and found this:

<NamedRange ss:Name="R2A" ss:RefersTo="=Sheet1!R2162C1"/>. If I change R2A to RA, then the excel can be opened
successfully. I also tested it for many times, and found if the name is started with "R number letter" format, the error will
happen.

I'm really confused and have two questions as below:
1, Is the format like "R2A" are illegal for NamedRange name? Does birt has any defined rules for this?
2, If not, can we treat this as a birt bug?

Any input is appreciated, thanks!
Re: XML ERROR in Workbook Setting when opening exported excel [message #640426 is a reply to message #640145] Sun, 21 November 2010 21:21 Go to previous messageGo to next message
Eclipse UserFriend
did anyone meet this issue?
Re: XML ERROR in Workbook Setting when opening exported excel [message #640650 is a reply to message #640426] Mon, 22 November 2010 11:50 Go to previous messageGo to next message
Eclipse UserFriend
Have you tried this in BIRT 2.6.1?

On 11/21/2010 9:21 PM, Hai Feng Luo wrote:
> did anyone meet this issue?
Re: XML ERROR in Workbook Setting when opening exported excel [message #640752 is a reply to message #640650] Mon, 22 November 2010 20:55 Go to previous messageGo to next message
Eclipse UserFriend
Hi Jason, currently I didn't test that on 261, I tested on 252, the same problem, as our product use 232 and 252. Seems that the NameRange name is not supported. Should we consider it as a defect?
Re: XML ERROR in Workbook Setting when opening exported excel [message #640909 is a reply to message #640752] Tue, 23 November 2010 08:57 Go to previous messageGo to next message
Eclipse UserFriend
Are you using the default BIRT excel emitter? Can you post the report
design?

Jason

On 11/22/2010 8:55 PM, Hai Feng Luo wrote:
> Hi Jason, currently I didn't test that on 261, I tested on 252, the same
> problem, as our product use 232 and 252. Seems that the NameRange name
> is not supported. Should we consider it as a defect?
Re: XML ERROR in Workbook Setting when opening exported excel [message #1712623 is a reply to message #640145] Mon, 26 October 2015 17:50 Go to previous message
Eclipse UserFriend
Does any know what the resolution to this issue from 2010 was?

We have just had a similar problem arise where BIRT titles with a standalone R or C or parentheses creates a NamedRange workbook setting problem after download.

The titles previously worked without a problem.

Thanks. Mike
Previous Topic:Custom Report Wizards
Next Topic:BIRT 4.5 Engine not working
Goto Forum:
  


Current Time: Wed Jul 23 13:45:56 EDT 2025

Powered by FUDForum. Page generated in 0.26513 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly