Home » Developer & Programmer » Reports & Discoverer » Number Conversion Fails in Excel (Oracle Reports)
Number Conversion Fails in Excel [message #335850] Thu, 24 July 2008 00:31 Go to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Hi All,

im transforming xml output to Excel
1)In excel numbers are converted to string, so cant perofrm any
calculation on numbers in excel....

anyone help me out
Re: Number Conversion Fails in Excel [message #335889 is a reply to message #335850] Thu, 24 July 2008 01:45 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Did you make sure the language format settings are the same on both sides?
Re: Number Conversion Fails in Excel [message #335933 is a reply to message #335850] Thu, 24 July 2008 03:27 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
wel kindly can u explain it to me....
i have set column types to number.... (report and word xml)
Re: Number Conversion Fails in Excel [message #335946 is a reply to message #335933] Thu, 24 July 2008 04:06 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
What I meant was that in general Oracle tools have a certain formatting in the front end (I don't know how that works in Reports, but I'm sure it can be done). First it looks at my own computer settings, if that's not set, then at the database. For example the (english formatted) number 1,004.3 will show up in Oracle Discoverer on my screen in Dutch like 1.004,3. If for some reason my Excel is set up in English, this will not be recognized as a number by Excel.

So, verify if your Excel settings are the same as the Oracle database and front end setting.
Re: Number Conversion Fails in Excel [message #336021 is a reply to message #335850] Thu, 24 July 2008 07:53 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Dear Friend,

Language settings are same...

Values coming from Reports Formula columns havig problem...

kindly help me out...........
Re: Number Conversion Fails in Excel [message #336175 is a reply to message #335850] Fri, 25 July 2008 02:07 Go to previous message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Dear All,

Problem is Solved.... just recreate the columns in
Ms Word(XML)....

Thanks, Smile
Previous Topic: Formatting problem in matrix group by report
Next Topic: Using FTP in Report
Goto Forum:
  


Current Time: Wed Dec 07 18:32:20 CST 2016

Total time taken to generate the page: 0.12048 seconds