Change of pivot data source adds additional LinkSource

Hi Aspose team,

when I make change of pivot data source additional Link Source is created.
This new link source is copy of original not changes pivot data source.
Output is:

DATA CONNECTIONS
1. DSN=MS Access Database;DBQ=P:\PROJECTS\SCM-ToolBox\A1__Tools\01__PRoLog\06__Daten\03__Daten\Loader_Pipeline.accdb;DefaultDir=P:\PROJECTS\SCM-ToolBox\A1__Tools\01__PRoLog\06__Daten\03__Daten;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;

EXTERNAL LINKS
1. \\ww002.siemens.net\dfs06\SCM_Toolbox\SCM-Toolbox\A1__Tools\Absatzplanung\Planung_aktuell\Tool_Absatzplanung_Stammdaten.xls
2. C:\SCM_Toolbox\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\TMP_LINK\Pipeline_Linie_05_Cpy.xlsm
3. C:\SCM-ToolBox\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm
4. C:\TEST\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm
PIVOT TABLES
1. 'C:\TEST\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\[Pipeline_flexible_Auswahl_Linien.xlsm]Berechnungsblatt PIVOT'!A:W

SAVE NEW FILE

NEW DATA CONNECTIONS
1. DSN=MS Access Database;DBQ=P:\PROJECTS\SCM-ToolBox\A1__Tools\01__PRoLog\06__Daten\03__Daten\Loader_Pipeline.accdb;DefaultDir=P:\PROJECTS\SCM-ToolBox\A1__Tools\01__PRoLog\06__Daten\03__Daten;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;

NEW EXTERNAL LINKS
1. \\ww002.siemens.net\dfs06\SCM_Toolbox\SCM-Toolbox\A1__Tools\Absatzplanung\Planung_aktuell\Tool_Absatzplanung_Stammdaten.xls
2. C:\SCM_Toolbox\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\TMP_LINK\Pipeline_Linie_05_Cpy.xlsm
3. C:\SCM-ToolBox\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm
4. C:\TEST\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm
5. C:\ASPOSE\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm

NEW PIVOT TABLES
1. 'C:\ASPOSE\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\[Pipeline_flexible_Auswahl_Linien.xlsm]Berechnungsblatt PIVOT'!A:W

As you can see first part has 4 external links and second part after SAVE NEW FILE has 5. I put in bold that what is additionally created.

Project to reproduce this issue is attached.

Thx for help.


Hi,


Thanks for your posting and using Aspose.Cells.

We have tested this issue with the attached sample project which uses the same code provided by you and were able to replicate this issue.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45158 - Change of pivot data source adds additional LinkSource

I have also shown the console output of the sample project for a reference.

Console Output
Aspose.Cells for .NET v17.02.0.0
DATA CONNECTIONS
  1. DSN=MS Access Database;DBQ=P:\PROJECTS\SCM-ToolBox\A1__Tools\01__PRoLog\06__Daten\03__Daten\Loader_Pipeline.accdb;DefaultDir=P:\PROJECTS\SCM-ToolBox\A1__Tools\01__PRoLog\06__Daten\03__Daten;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;

EXTERNAL LINKS

  1. \\ww002.siemens.net\dfs06\SCM_Toolbox\SCM-Toolbox\A1__Tools\Absatzplanung\Planung_aktuell\Tool_Absatzplanung_Stammdaten.xls
  2. C:\SCM_Toolbox\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\TMP_LINK\Pipeline_Linie_05_Cpy.xlsm
  3. C:\SCM-ToolBox\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm
  4. C:\TEST\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm

PIVOT TABLES

  1. ‘C:\TEST\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell[Pipeline_flexible_Auswahl_Linien.xlsm]Berechnungsblatt PIVOT’!A:W

SAVE NEW FILE

NEW DATA CONNECTIONS

  1. DSN=MS Access Database;DBQ=P:\PROJECTS\SCM-ToolBox\A1__Tools\01__PRoLog\06__Daten\03__Daten\Loader_Pipeline.accdb;DefaultDir=P:\PROJECTS\SCM-ToolBox\A1__Tools\01__PRoLog\06__Daten\03__Daten;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;

NEW EXTERNAL LINKS

  1. \\ww002.siemens.net\dfs06\SCM_Toolbox\SCM-Toolbox\A1__Tools\Absatzplanung\Planung_aktuell\Tool_Absatzplanung_Stammdaten.xls
  2. C:\SCM_Toolbox\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\TMP_LINK\Pipeline_Linie_05_Cpy.xlsm
  3. C:\SCM-ToolBox\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm
  4. C:\TEST\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm
  5. C:\ASPOSE\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell\Pipeline_flexible_Auswahl_Linien.xlsm

NEW PIVOT TABLES

  1. ‘C:\ASPOSE\A1__Tools\02__Pipeline_Regler\00_GJ_aktuell[Pipeline_flexible_Auswahl_Linien.xlsm]Berechnungsblatt PIVOT’!A:W


Hi,


Thanks for using Aspose.Cells.

We are afraid, we could not simply remove the existed external link when the data source of pivottable is changed for performance reasons.

There are 3 steps to remove an existed external link:

1. Check whether it’s referred by formulas.
2. If it’s not referred, remove it.
3. Update all formulas.

We have to consume time to iterate all cells, shapes and pivottables to implement step 1 and 3. As this useless data does not affect the file, so we have no plan to remove it. Therefore, we have closed this issue as Won’t Fix. Sorry for the inconvenience.

Hi,

thanks for reply.
Does that mean that when Pivot table is created Excel is creating at the same time also External link that there is no connection between Pivot and External entry?

I was thinking that if there is connection when I change Pivot table source External link can be automatically adjusted to new Pivot table source. Of course, this can work only in case that there is connection between those two entries.
Hi,

Thanks for your posting and considering Aspose.Cells.

Yes, there is a connection from pivottable to external link pool. But we can't simply know whether an external link is only referred by a pivot table, so it's hard to remove an external link from pool.

Hi,


Furthermore, we will try to work as MS Excel, the external links do not contain the data source of the pivottable. We have reopened the ticket now.

Thank you.
Thanks Amjad.
Will issues status be also changed from "Won't fix" to "Not resolved" :)?

Hi Oliver,


I believe you are talking about the status on the left hand pane of the first post. Please note, it will be automatically updated in a couple of hours as the back-end ticket has been reopened.

Hi again,


This is to update you that the ticket logged earlier as CELLSNET-45158 has been marked resolved. We will shortly share the fix here for your testing.

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v17.2.3:
(Note: please choose any of the fixes for your .NET framework version).

Your issue “CELLSNET-45158” should be fixed in it.

Let us know your feedback.

Thank you
Great, thanks.
My test looks good :)

Thank you
Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.

The issues you have found earlier (filed as CELLSNET-45158) have been fixed in Aspose.Cells for .NET 17.3.0.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.