Filter on label are not applied during refreshPivotTables

Aspose.Cells Product Family
1

We have define filter on label of a pivot table to exclude empty cells.
After refreshPivotTables, pivot table contains "(blank) cells.
Code example:

import com.aspose.cells.SaveFormat;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
import com.aspose.cells.WorksheetCollection;

public class testasposeXLSPivottoPDF
{

public static void main(String[] args) throws Exception
{
    // TODO Auto-generated method stub
   new testasposeXLSPivottoPDF();
}

public testasposeXLSPivottoPDF() throws Exception
{
    String filepath="C:/temp/gteufp_fr_q000000001.xlsx";       
    Workbook workbook = new Workbook(filepath);
    WorksheetCollection worksheets = workbook.getWorksheets();
    workbook.save(filepath+".ok.pdf", SaveFormat.PDF);               
    for (Object xsheet : worksheets)
    {                        
        
       Worksheet wsheet = (Worksheet)xsheet;
       wsheet.refreshPivotTables();
    }
    workbook.save(filepath+".ko.pdf", SaveFormat.PDF);               
}

}gteufp_fr_q000000001.zip (13.8 KB)

2

@j.brauge,

Thanks for the template file and sample code.

After an initial test, I am able to observe the issue as you mentioned by using your sample code with your template file. I found that filters on labels are not applied during PivotTable.refreshPivotTables call. I have logged a ticket with an id “CELLSJAVA-42825” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

3

Hi Amaj,
Do you have any news ?
Regards.

4

@halfspawn,

This issue is still pending and not resolved yet. I am afraid that no ETA can be provided now, however we will write back here once any update is ready to share.

5

@halfspawn,

We have investigated this issue. The filter is based upon the unused data. For now, we don’t keep the missing and unused data when you refresh the PivotTable. We will support it later on.

6

We are pleased to inform you that your issue (logged as “CELLSJAVA-42825”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v23.11) that we plan to release in the first half of November. You will be notified when new versions are released.

7

The issues you have found earlier (filed as CELLSJAVA-42825) have been fixed in Aspose.Cells for Java 23.11.