Description

PivotGrid does can not export all the date to excel when the nodes are collapsed

Plan

KendoReact Free

Steps To Reproduce

https://www.telerik.com/kendo-react-ui/components/pivotgrid/excel
Configure a PivotGrid with multiple row and column fields, and at least one measure.

Expand only a few nodes manually.

Click the Export to Excel button.

The exported file contains only the visible/expanded rows/columns.

Screenshots or video

No response

Actual Behavior

It is not practical or user-friendly to expect users to manually expand every node (especially if data changes frequently).

Users expect complete data export based on the selected dimensions/measures and based on provided data source to generate pivot grid — not just what is visible.

Expected Behavior

Expected Behavior:
When clicking Export to Excel, PivotGrid the entire dataset should be exported in expanded format.

Browser

Chrome, All

Browser version

latest

OS type

MacOS

OS version

No response

Last working version of the KendoReact package (if regression).

No response

Hi Team,

I am using the KendoReact PivotGrid component in my project and would like to enable column resizing. However, I have not found any property that allows me to achieve this.

I have tried using resizable={true} in the PivotGrid, but it did not work. I checked the official documentation but could not find any specific guidance on enabling column resizing for the PivotGrid component.

Could you please confirm whether column resizing is supported in the PivotGrid? If not, is there any workaround or planned support for this feature?

Looking forward to your response.

Thanks,

Amit

Hey Hi Team,

Please go through the link https://stackblitz.com/edit/react-4ze9fd-pxytyn?file=app%2Fmain.tsx

Here you will find our exact solution and we want last column description to hide.

Other than that we required all columns as it is. So need to remove last column only.

Recently we came up with a workaround for expanding the defaultRowAxes by creating a string value (by concatenating previous tag value with ‘&’ + tag value + next tag along with expand: true property and so on). This approach is not ideal because we have a lot of data and we use the pivotProps values returned from ‘usePivotLocalDataService’ hook as sometimes we can have more than 5 nested tags in a row and we update our config based upon the return values from configuratorProps returned from the same hook (usePivotLocalDataService) so we can save the values in our database later.

We need a solution where we can pass in a prop (eg: expandRows) either to the usePivotLocalDataService hook or the PivotGrid component itself that will expand the rows by default whenever we click the “Apply” button in the Configurator component.

Telerik Dojo example: https://www.telerik.com/kendo-react-ui/components/pivotgrid/data-binding/local-binding/

In the above mentioned example and the screen recording attached (expand-defaultRowAxes.mov) you can see when we click apply -> defaultRowAxes are added but they are collapsed. So we need a solution where in we can pass a prop to the component / hook for expanding defaultRowAxes whenever we click on “Apply” button.