Get Free Trial

How to implement the rowEdit feature?

Answered
Akshay Alva asked on May 12, 2021

Hi Team,
 
Can you guide me on how to edit all the cells in a row by clicking on the row number? I have read about the “editing:true” option, but that would only mean that editing is possible only for the clicked cell in drill through mode. But here, I am looking at editing the entire row values without having to go inside another popup for each cell.
Please find the snapshot attached. As per the snapshot, when i click on row3, I should be able to edit Jan, Feb, Mar and April data (Row3 – Col3, Row3 – Col4, Row3 – Col5 and Row3 – Col6).
 
Thanks in advance.

Attachments:
rowEditOption.JPG

7 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 13, 2021

Hi Akshay,
 
Thank you for writing to us.
 
Flexmonster does not allow modifying the cells with aggregated values – the data in such cells consist of multiple other values, which means that some additional logic has to be implemented to determine which of these values are modified when the editing is being carried out on a specific cell.
 
That being said, it would be impossible to implement unambiguous data editing in the pivot view without the cell drill-through.
 
Hope this helps!
 
Regards,
Mykhailo 

Public
Akshay Alva May 17, 2021

Hi Mykhailo,
 
Thanks for your response.
Can you let me know if there is a possibility of enabling editing option (in drill through) only for a given cell and not for the complete table in cell drill though mode? For example, as per the attached snapshot, I am interested in editing the cells under Forecast Qty column and not in other columns.
 
Thanks in advance.

Attachments:
Capture.JPG

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 19, 2021

Akshay,
 
Thank you for your response.
 
Restricting data editing to the cells of a specific hierarchy is currently unavailable in Flexmonster.
 
Please let us know if you have any other questions we can help you with.
 
Regards,
Mykhailo

Public
Akshay Alva May 21, 2021

Hi Mykhailo,
I have achieved cell edit on a particular cell using your instruction on https://jsfiddle.net/flexmonster/txev6jh3/
 
On the onChange event, i am able to get the individual cell value, however i also need all the other cell values of the same row. How can i get this?
 
Thanks in advance.

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 24, 2021

Hi Akshay,
 
It is currently not possible to retrieve the neighboring cell values with the suggested customizeCell() API call approach.
 
Kind regards,
Mykhailo

Public
Akshay Alva June 1, 2021

Hi,
 
Can I get the complete row values based on one selected cell? It is okay if it is not editable, i am interested in the complete row values up to its top most hierarchy.

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster June 2, 2021

Hi Akshay,
 
This is not natively available in Flexmonster. However, it sounds like something that can be done with a custom drill-through.
 
For implementing custom drill-through, we usually suggest disabling the drillThrough property of the Options Object, subscribing to the celldoubleclick event, and using the information received in the callback to select the corresponding part of the data set.
 
Hope you find this helpful.
 
Regards,
Mykhailo

Please login or Register to Submit Answer