We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Links to other data sources

Thread ID:

Created:

Updated:

Platform:

Replies:

69740 Nov 9,2007 07:43 PM UTC Nov 10,2007 10:00 AM UTC Windows Forms 1
loading
Tags: XlsIO
J. Ho
Asked On November 9, 2007 07:43 PM UTC

Hi everyone -

I'm trying to modify a spreadsheet that contains links to other data sources. I don't want to modify these links, but I do need to check the displayed text contained within the linked cells.

The problem is when I save the spreadsheet, the links are altered to include the path of my application. This happens even if I just open & close the spreadsheet.

For example, a linked cell originally had this formula value:

=ILX|Q!'cbs,Bta'

would be altered to be:

='C:\ALPHA\XLSUpdate\XLSUpdate\bin\Debug\ILX\Q'!'cbs,Bta'

I don't want these formulas to be updated. Is there a way I can prevent XlsIO from doing so?

Thanks!


Rajarajeswari S [Syncfusion]
Replied On November 10, 2007 10:00 AM UTC



Hi,

I am afraid that i am not able to reproduce the problem that you have mentioned here. Please

refer to the following steps that i tried to reproduce it.

1.I have created a sample in XlsIo.
2.I have opened the file containing Link in a formula
3.Again i saved and opened it through XlsIo, but the formula is not get updated with the application path.

Please refer the tested sample following the below link:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F69740/main.htm

Please have a look at the above sample and if still the problem exists, could you please try

reproducing it in the above sample or send us the reproducing steps so that we could sort

out the cause of the issue and provide you a solution.

Regards,
Raji




CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;