No changes saved in XLS file (LinkSource update)


#1

Hi Aspose team,

in attached project

XLS_NoUpdate.zip (97.1 KB)

you will find simple project that is reading one XLS document and showing all Link Sources (Data Connection), making change of SourceFile from c: to d:, saving output file and reading content of output file.

Now, when you run example you will see that source file has C: and output file has D: but when you open created document and go to Data => Connections => Definition of one of connections there still you can find C: so no update is shown. On the other side Aspose.Cells is returning D:.

Same example with newer Excel formats works.

Can you please check why changes are not updated in the document and provide solution?

Thanks,
Oliver


#2

@dr_oli,

Thanks for the sample project, template file and details.

After an initial test, I am able to reproduce the issue as you mentioned by using your sample project with your template file. I found link sources are not updated in the output XLS file although at runtime we get correct updated path for external links/sources. I have logged a ticket with an id “CELLSNET-46905” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.


#3

@dr_oli,
If the connection is data source of QueryTable, MS Excel saves some duplicate data to .xls file and some records of QueryTable are not supported to parse now. We hope we can fix this issue in Q4 2019.