COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosun on 03 Jun 2016 06:44:34 AM

Title: Excel Issue - Decimals
Post by: cognosun on 03 Jun 2016 06:44:34 AM
Gurus,

In our dev environment we are able to successfully export a report to excel, which has combination chart and the hidden sheet of the chart(in excel) contains measures as integers, for y-axis values.

But when we deployed this report to testing environment we are getting 'unformatting error' in excel, and error is pointing to the hidden sheet, where the chart contains measures as decimals, for y-axis values.

So any idea like why in one environment, excel is displaying integers and in other environment decimals ( both the databases are same).

We are on 10.2.1

Many thanks in advance
Title: Re: Excel Issue - Decimals
Post by: cognosun on 05 Jun 2016 04:02:55 AM
Is it any server side software issue (excel specific). We are running report in Excel 2007.
Title: Re: Excel Issue - Decimals
Post by: cognosun on 05 Jun 2016 09:41:08 AM
Any clue ?