1. Home
  2. Forum
  3. React - EJ 2
  4. React pivot table editing : columns read only and refresh of the group interval values

React pivot table editing : columns read only and refresh of the group interval values

Hi,

I use the pivot table with the option edit (mode batch).  It's very important for me the feature of edit.
 
Questions : 
 
 1- Is there any way to set some colums as read only ( the user should modify date and amount alone).  ?
     * With the component grid I use allowEditing for ColumnDirective property.
 
 2- I have the following group settings : 
...
groupSettings: [                
        { name: 'fecha', type: 'Date', groupInterval: ['Months', 'Days'] }, 
     ],  
But when the user modifies the date (days) the month is not modified. 
Is there any way to "refresh" the value of the month if the user modifies the day (for the year is the same) ?.

Thanks in advance.
Jorge

 

4 Replies 1 reply marked as answer
SS Saranya Sivan Syncfusion Team April 26, 2021 04:23 PM UTC

Hi JORGE V, 
  
Thanks for contacting Syncfusion support. 
  
Please find the response below,   
   
Query  
Response  
Is there any way to set some colums as read only ( the user should modify date and amount alone).  
We would like to inform that the requirement can be achieved by `drillthrough` event. Kindly check the below sample, UG and code example for your reference. 
  
Code Example: 
  drillThrough(args) { 
    for (var i = 0; i < args.gridColumns.length; i++) { 
      if ( 
        args.gridColumns[i].field == "Year" || 
        args.gridColumns[i].field == "Amount" 
      ) { 
        args.gridColumns[i].allowEditing = true; 
      } else { 
        args.gridColumns[i].allowEditing = false; 
      } 
    } 
  } 
  
  
I have the following group settings :  
groupSettings: [{ name: 'fecha', type: 'Date',  
groupInterval: ['Months', 'Days'] } ],   
 But when the user modifies the date (days) the month is not modified. Is there any way to "refresh" the value of the month if the user modifies the day (for the year is the same) ?. 
We are checking on the reported issue at our end. We will update you the further details in two business days(28 April 2021). 
  
Please let us know if you have concern. 
  
Regards, 
Saranya Sivan. 


Marked as answer
SS Saranya Sivan Syncfusion Team April 28, 2021 10:57 AM UTC

Hi JORGE V,  
     
Please find the response below,    
    
Query   
Response   
I have the following group settings :   
groupSettings: [{ name: 'fecha', type: 'Date',   
groupInterval: ['Months', 'Days'] } ],    
 But when the user modifies the date (days) the month is not modified. Is there any way to "refresh" the value of the month if the user modifies the day (for the year is the same) ?.  
The fields “Months” and “Days” work independently even though that are created from a common field “Date” by group settings option. So, editing one of the field doesn’t affect another. 
 
But, it can be achieved by sample level by an event “editComplete”. Kindly refer the below code example and sample to frame your own logic.  
   
Code Example:  
  editCompleted(args) { 
    for (var i = 0; i < args.currentData.length; i++) { 
      args.currentData[i].Date_date_group_months = args.currentData[i].Date; 
    } 
    for (var j = 0; j < args.currentData.length; j++) { 
      for (let index of Object.values(args.previousPosition)) { 
        this.pivotObj.engineModule.data[index] = args.currentData[j]; 
      } 
    } 
  } 
   
   
   
Please let us know if you have concern.  
   
Regards,  
Saranya Sivan.  



JV JORGE V May 1, 2021 04:13 PM UTC

Hi,

- With the use of Witdrillthrough event and allowEditing I could set certains columns as read only. It's Ok !

- I could use the editCompleted event but there is another problem :
  The option edit doesn't show a datePicker control for edit the value of field "Days" then it is not possible to change the value correctly.

Thanks in advance.
Jorge


SS Saranya Sivan Syncfusion Team May 3, 2021 01:45 PM UTC

Hi JORGE V, 
 
Thanks for the reply. 
 
Query:  The option edit doesn't show a datePicker control for edit the value of field "Days" then it is not possible to change the value correctly. 
 
Answer: The issue is fixed in latest version v19.1.58. So, kindly update the pivot table package to latest version. 
 
Please let us know if you have concerns.  
 
Regards,  
Saranya Sivan. 
 


Loader.
Up arrow icon