-
Notifications
You must be signed in to change notification settings - Fork 1.4k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Error with filters on a pivot table causes a corrupt sheet and memory error #1155
Comments
We're getting a similar issue on |
Can you share the original Excel file? |
Timesheet_Report_08-10-2023 (2).xlsx |
Any update on this? |
This looks not to be the original file. It's a broken one. Can you upload the original one? How did you add a filter? using C# by NPOI or Microsoft Office? If using C#, can you show me the code of adding this filter? |
Pivot table works great until we add a filter on a yes/no column, then it gives:
then this error:
The pivot table appears on the sheet but is not populated
Without the filter on the billable column it works fine:
And you can manually drag the billable column down to be a filter and it works fine.
pivotTable.AddReportFilter(filterIndex);
is the only relevant code added, the column is a yes/no text field.
The text was updated successfully, but these errors were encountered: