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 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?
Previous Topic:Problems with page break
Next Topic:Lib Dynamic Data Source from Resource Property
Goto Forum:
  


Current Time: Sun Dec 21 22:25:21 GMT 2014

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

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