Wednesday, January 07, 2009   
 Search   
 

http://www.foxfirereporting.com
Register  Login  
Forums  
      
 Forums    
SearchForum Home
  Support  Foxfire! 6.0x Support  Error when Outp...
 Error when Output to Excel Graph in Office 2007
 
 9/27/2007 3:09:06 AM
klchiew
14 posts


Error when Output to Excel Graph in Office 2007

I encountered error when I'm trying to send my data using foxfire 6.04 and output to 'Graph-Excel Chart--3D Pie'. I'm using Office 2007. It is ok when I'm using Office 2003.

The error I encountered is :   OLE IDispatch exception code 0 from S:The specified dimension is not valid for the current...

Please assist.

Thanks.

 

 9/27/2007 1:08:04 PM
AndrewM
102 posts
www.aksel.com
5th


Re: Error when Output to Excel Graph in Office 2007
We are looking into this. I will let you know as soon as I find out anything.
 9/28/2007 11:12:17 AM
AndrewM
102 posts
www.aksel.com
5th


Re: Error when Output to Excel Graph in Office 2007
We are not seeing this problem when we run it with the sample data.
If you run a Pie chart using Cars Color and Count, do you still get the error?
 9/30/2007 8:41:55 PM
klchiew
14 posts


Re: Error when Output to Excel Graph in Office 2007

Hi Andrew,

To give you more specific on the problem, below is my finding:-

In Foxfire 6.04,   I hit the above error when I'm sending output to Office Excel 2007 using Graph-Excel Chart -- 3D Pie or Graph-Excel Chart -- PieOther chart type is ok.

In Foxfire 8+ (8.0.495), I downloaded the Demo copy and hit below error when I'm sending output [using sample report:[MAKECOL : Popularity of Colors by Make] to Office Excel 2007 using Chart Type - Excel Pie and tick the [Display in 3-D] selection. However, I don't hit error if I did not check the [Display in 3-D]. Other chart type is ok.

         ERRORs

Customer ID: 90954

Error Report:

Version : 8+ (8.0.495 - 10/01/2007)

An unrecoverable error just occurred (OLE IDispatch exception code 0 from S: The specified dimension is not valid for the current chart type...) in \FF80\. Please report this problem so it may be resolved.

Administrator

<p>

CHARTXLS ( 892)<p>

Timestamp: 10/01/2007 10:00:30 AM

Error: An unrecoverable error just occurred (OLE IDispatch exception code 0 from S: The specified dimension is not valid for the current chart type...) in \FF80\. Please report this problem so it may be resolved.

Program: CHARTXLS

Line: 892

HTH

Thanks and Regards

 

 

   

 10/4/2007 2:56:58 PM
AndrewM
102 posts
www.aksel.com
5th


Re: Error when Output to Excel Graph in Office 2007
While I was unable to reproduce it, I was able to see that the charts were not appearing properly in Excel 2007. Sometimes they would show up as Pie charts but in other cases, they would not.

It looks like this is being caused by Microsoft changing the Chart type constants in Excel 2007.
I'm looking into it and will get back to you on this shortly.
  Support  Foxfire! 6.0x Support  Error when Outp...
   
SearchSearch  Forum HomeForum Home     
 Links    
   
  
Downloaded from DNNSkins.com