Hi,
We are trying to create a template .xlsx file by removing information from an input file. Using Aspose.Cells works really well at doing this.
However it has an issue with retaining replacement values in a pivot table i.e. replace all “(blank)” values with a less messy entry such as "-"s.
Below is a simplified step by step of the process we see the issue in.
- Clear an input file of all data except for the tables’ column headers.
- Save file after data has been removed.
- Populate the whole source table making sure there are no blank cells.
- Update Pivot tables
- Save the file after the file has been repopulated.
- Populate only some cells in the source table; making sure there are blank cells within the table.
- Update the pivot table.
- Final time the file is saved after making sure that the source table contains empty cells.
ISSUE: The second file created (from Step 5) no longer has the replacement value for “(blank)”.
It seems that the replacement value is not remembered if the pivot table got updated while the source table did not have any empty cells.
Additional Information:
- When you do the same thing in Office Excel (fill in all empty cells in the source table then update the pivot table); the replacement value is remembered and reappears when the source table is edited to have empty cells again.
I have attached a sample project to demonstrate the issue. I have also attached an input file for you to use.