1. Home
  2. Forum
  3. Blazor
  4. Pivot table unable to save edits

Pivot table unable to save edits

Hi,

We are testing the pivot grid and are having issues with it. Attached is a sample project.

When inline editing and you hit enter or tab, the change isn't applied. We have to click in the cell again and then it will register.

Image_6938_1700042362707


Then when it does apply we get the following error:

Image_5435_1700042439358

This error wasn't occurring on our first test with actual data, but now we are getting it on this sample data, but on the actual data there was no error but the OnActionComplete event wouldn't fire.


We need to be able to get the Id and Value from the Forecast chunk that has been edited so we can send it back to the server for updating. 

We also need to only have certain sections editable, so "User Forecast" can be edited but if a user tries on "System forecast" it must cancel the edit.


Then theres a sub grouping issue when the text is falling through the grid.

Image_9097_1700042703424


Please assist.

Thank you


Attachment: PivotGrid_ec0fc987.zip

3 Replies
AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team November 16, 2023 03:57 PM UTC

Hi Andrew,


Please find the response below.

Query

Comments

We are testing the pivot grid and are having issues with it. Attached is a sample project.

When inline editing and you hit enter or tab, the change isn't applied. We have to click in the cell again and then it will register.

 

Then when it does apply we get the following error:

This error wasn't occurring on our first test with actual data, but now we are getting it on this sample data, but on the actual data there was no error but the OnActionComplete event wouldn't fire.

Thanks for sample. We checked the reported issue and found that the reported issue only occurs in the provided data source, and we are validating it at our end. And we will update the details in two business days(Nov 20, 2023). Appreciate your patience until then.

We need to be able to get the Id and Value from the Forecast chunk that has been edited so we can send it back to the server for updating. 

If the editing completed successfully, OnActionComplete and EditCompleted events will be triggered and you can able to get the edited data information there. Please refer to the below code example and the sample from the below attachment to know more about the “OnActionComplete” and “EditCompleted” event.

 

Code Example:

 

<SfPivotView TValue="PivotVirtualData" @ref="@pivot">

       <PivotViewEvents TValue="PivotVirtualData" EditCompleted="EditCompleted" OnActionComplete="Action_Complete"></PivotViewEvents>

</SfPivotView>

 

 

public void Action_Complete(PivotActionCompleteEventArgs<PivotVirtualData> args)

    {

        Console.Write(args.ActionInfo.EditInfo);

    }

 

private void EditCompleted(EditCompletedEventArgs<PivotVirtualData> args)

    {

        Console.Write(args.ModifiedData);

        Console.Write(args.AddedData);

        Console.Write(args.RemovedData);

    }

 

Please refer the below document to know more about the “OnActionComplete” and “EditCompleted” event.

 

Document:

OnActionComplete event: https://blazor.syncfusion.com/documentation/pivot-table/editing#onactioncomplete

EditCompleted event https://help.syncfusion.com/cr/blazor/Syncfusion.Blazor.PivotView.PivotViewEvents-1.html#Syncfusion_Blazor_PivotView_PivotViewEvents_1_EditCompleted

 

We also need to only have certain sections editable, so "User Forecast" can be edited but if a user tries on "System forecast" it must cancel the edit.

 

We would like to inform you that the OnActionBegin event triggers commonly while performing UI actions, thus you are unable to get the current cell information. However, using the DrillThrough event you can restrict the editing action for the specific value cell based on your requirement. . Please refer the below code example.

 

Code Example:

<SfPivotView TValue="PivotVirtualData" @ref="@pivot">

        <PivotViewEvents TValue="PivotVirtualData" DrillThrough="drillThrough"></PivotViewEvents>

</SfPivotView>

 

private void drillThrough(DrillThroughEventArgs args)

    {

        // Restricted the editing for the cells which has “PRO-101” a row header.

        if (args.CurrentCell.RowHeaders == "PRO-101")

        {

            args.Cancel = true;

        }

    }

 

Please refer the below document to know more about the “DrillThrough” event.

Document: https://blazor.syncfusion.com/documentation/pivot-table/events#drillthrough

 

Then theres a sub grouping issue when the text is falling through the grid.

 

We have checked your project and found that you have used older version CDN link for script and styles that causes the reported alignment issue occur in the pivot table UI. However, we suggest you to use our latest “Syncfusion.Blazor.Themes” package for the styles and “Syncfusion.Blazor.PivotTable” package for Pivot table script instead of CDN links. And, please refer only the below links for script and styles references in the Host.cshtml file.

 

Code Example:

<script  src="_content/Syncfusion.Blazor.Core/scripts/syncfusion-blazor.min.js"  type="text/javascript"></script> 

<link rel='nofollow' href="_content/Syncfusion.Blazor.Themes/bootstrap5.css" rel="stylesheet" />

 

Screenshot:

 

 

Please refer the below document to know more about the getting started.

Document: https://blazor.syncfusion.com/documentation/pivot-table/getting-started

 


Please let us know if you have any concerns.


Regards,

Angelin Faith Sheeba.


Attachment: PivotTable_b5c18d42.zip

AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team November 20, 2023 02:34 PM UTC

Hi Andrew,


Thanks for the patience. We checked the reported issue and found that issue occurs because of the read-only properties in the provided data source. And we have considered this issue as a bug “Editing not working properly while binding data source with read-only properties”. The fix for this issue will be included in our upcoming weekly release which is scheduled to be rolled out on Nov 29, 2023. You can track the status with the feedback link below.


Feedback: https://www.syncfusion.com/feedback/48632/editing-not-working-properly-while-binding-data-source-with-read-only-properties


We appreciate your patience until then.


Regards,

Angelin Faith Sheeeba.


AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team November 30, 2023 05:22 AM UTC

Hi Andrew,


We are glad to announce that our weekly Release V23.2.6 is rolled out and the fix for the reported issue “Editing not working properly while binding data source with read-only properties” has been included in this release. And, we have modifed your sample for your reference and please find it from the below attachment.


Output screenshot:


Please let us know if you have any concerns.


Regards,

Angelin Faith Sheeba


Attachment: PivotGrid_6bbb0dd0.zip

Loader.
Up arrow icon