You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
What is the current behavior?
Not sure if this is a bug for ClosedXML or limitation for referencing OpenXML.The issue im facing is
Unable to open xlsx file and getting Object reference error when opening an excel file which has Pivot Tables with source as Named Table reference.
What is the expected behavior or new feature?
to be able to open the file and read the values from the named Manager or the individual cells
attached the sample excel file and code for reference testingPivotExcel.zip
Is this a regression from the previous version?
This issue is happening in current stable version 0.102.2
Reproducibility
Code to reproduce problem:
using ClosedXML.Excel;try{stringexcelFileName="testPivot.xlsx";stringexcelFilePath= Path.Combine(AppDomain.CurrentDomain.BaseDirectory, excelFileName);// Load the Excel workbook and worksheet containing the pivot table with named table referencevarworkbook=new XLWorkbook(excelFilePath);varworksheet= workbook.Worksheet(1);varpivotTableParts= worksheet.PivotTables;}catch(Exceptionex){throw;}
[ x] I attached a sample spreadsheet. (You can drag files on to this issue)
The text was updated successfully, but these errors were encountered:
Read and complete the full issue template
Do not randomly delete sections. They are here for a reason.
Do you want to request a feature or report a bug?
Did you test against the latest CI build?
If you answered
No
, please test with the latest development build first.Version of ClosedXML
e.g. 0.102.2
What is the current behavior?
Not sure if this is a bug for ClosedXML or limitation for referencing OpenXML.The issue im facing is
Unable to open xlsx file and getting Object reference error when opening an excel file which has Pivot Tables with source as Named Table reference.
What is the expected behavior or new feature?
to be able to open the file and read the values from the named Manager or the individual cells
attached the sample excel file and code for reference
testingPivotExcel.zip
Is this a regression from the previous version?
This issue is happening in current stable version 0.102.2
Reproducibility
Code to reproduce problem:
The text was updated successfully, but these errors were encountered: