Disabling pivot table ribbon


#1

In VBA, there is a way to disable the pivot table UI options and make the ribbon tabs disappear. I tried to use what I thought was the same functionality in Aspose Cells:

    pt.setEnableFieldList(false);
    pt.setEnableFieldDialog(false);
    pt.setEnableDrilldown(false);
    pt.setEnableWizard(false);
    pt.setEnableDataValueEditing(false);

This does seem to disable the features mentioned, but the tabs still appear in the ribbon. Does Aspose support disabling these ribbon tabs?


#2

@wtchang,

Thanks for the details.

Please provide us your template files (input (if any) and output file) and paste your complete Java program (runnable) to reproduce the issue, we will check it soon. Also, provide a sample file (containing your desired PivotTable) where its underlying UI options are disabled, you may create the file manually in MS Excel. Moreover, share some screenshots to highlight the issue.


#3

Attached the files. pivot_table_test.xlsx is the template file to open, asposequery.xlsx is the output of the program, and pivot_table_test_ui_disabled.xlsx is the desired output.
Screen Shot 2018-07-10 at 3.31.54 PM.png (29.4 KB)
Screen Shot 2018-07-10 at 3.31.35 PM.png (48.9 KB)


#4

@wtchang

Thanks for using Aspose APIs.

We have looked into your issue and found that you have not provided us the sample Excel files and only provided their screenshots. Please provide those Excel files instead of screenshots so that we could look into it further.


#5

aspose query.zip (65.0 KB)
Sorry about that, here they are


#6

@wtchang,

Thank you for sharing the sample files. We are analyzing these files and require more information. Please provide the detailed steps to enable/disable this pivot table ribbon as these steps are important for our analysis. We want to enable/disable this ribbon ourselves here for our tesing.


#7

I found a VBA macro online to do it here. To enable, I assume you would set everything to true instead of false.


#8

@wtchang

Thanks for using Aspose API.

We were able to observe your requirement and logged it in our database for investigation and implementation if possible. Once, we will have some fix or other news for you, we will update you asap.

This issue has been logged as

  • CELLSJAVA-42680 - Disabling Pivot Table Ribbon