Hello,
I had a query recently via our support , the person had a problem which related to an Excel file which they had imported into X2008 , created a simple column chart and then tried to Preview that file.
At first I thought it could be the Excel file itself and maybe unsupported formulas, but that doesn't appear to be the case. I tracked the error down to a VLOOKUP formula.
This was tested against the latest release of X2008 (fp2) , on Vista / XP /Windows Server 2003.
The same Excel was then loaded into CX 4.5 and it worked fine.
The question is are there known differences in the way X2008 handles VLOOKUP compared to CX 4.5
The files can be downloaded from: [http://www.flynetviewer.com/downloads/support/fin-brut-net.zip]
zip contains Excel file, X2008 .xlf and CX 4.5 .xlf
Note: The X2008 file shows the Formula to be a circular reference. If previewed in X2008 the application will freeze and you will have to end the program (at least that is my experience and the customers).
Deleting the Formula at K11 will solve the problem in X2008 , but the question is why is there a probelm in X2008 and not 4.5?
Is this a known issue?
Best Regards,
Ian
flynet