EPPlus icon indicating copy to clipboard operation
EPPlus copied to clipboard

Having a selection inside a pivot table can cause the pivot to become corrupt.

Open JanKallman opened this issue 8 months ago • 1 comments

If you have a selection in a pivot table and refresh the pivot table the xml for selection inside the worksheet xml is not updated or deleted if the pivot table has changed. This causes the workbook to become corrupt. Example:

<sheetViews>
  <sheetView workbookViewId="0">
    <selection activeCell="A6" sqref="A5:A6 A8:A10"/>
    <pivotSelection pane="bottomRight" showHeader="1" axis="axisRow" dimension="1" activeRow="5" previousRow="5" click="1" r:id="rId2">
    <pivotArea dataOnly="0" labelOnly="1" fieldPosition="0">
    <references count="1">
    <reference field="1" count="0"/>
    </references>
    </pivotArea>
    </pivotSelection>
  </sheetView>
</sheetViews>

JanKallman avatar Apr 02 '25 14:04 JanKallman