Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 10:34 Go to next message
Hai Feng Luo is currently offline Hai Feng LuoFriend
Messages: 3
Registered: November 2010
Junior Member
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] Mon, 22 November 2010 02:21 Go to previous messageGo to next message
Hai Feng Luo is currently offline Hai Feng LuoFriend
Messages: 3
Registered: November 2010
Junior Member
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 16:50 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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] Tue, 23 November 2010 01:55 Go to previous messageGo to next message
Hai Feng Luo is currently offline Hai Feng LuoFriend
Messages: 3
Registered: November 2010
Junior Member
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 13:57 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 21:50 Go to previous message
Michael Csuti is currently offline Michael CsutiFriend
Messages: 1
Registered: October 2015
Junior Member
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: Sun Dec 04 12:41:12 GMT 2016

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

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