Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
115
External reference are saved with wrong paths
posted

Hi,

I'm trying to open an excel file with external references, modify some cells and then save as a new file on disk. When doing this, formulas with external references get modified with a bad path/filename.

You'll see attached a sample project and in the two next posts sample excel files exhibiting the issue. Place the excel files into the project folder (along with the "add excel files here.txt" file) and run the project (BankOrder.xlsx is referencing equities.xlsx)

For example cell B2 is being modified from:

 

=RECHERCHEV($A2;'C:\Projets\Tests\Excel Export\Infragistics\InfragisticsExcelExport\InfragisticsExcelExport\[equities.xlsx]Equities'!$A2:$D$10000;2)

to: 

=RECHERCHEV($A2;'C:\Projets\Tests\Excel Export\Infragistics\InfragisticsExcelExport\InfragisticsExcelExport\bin\Debug\[1]Equities'!$A2:$D$10000;2)

 

I'm using version 11.2.20112.2050 of Infragistics components.

I'm also experiencing the issue described here : http://community.infragistics.com/forums/t/53201.aspx (some cells become black) but I can't reproduce it with a simple file/project, I'll post another message about this once I find a working sample, unless you already have a solution for it

 

InfragisticsExcelExport.zip
Parents Reply Children
No Data