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.
⋅ 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
⋅ 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.
⋅ 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
⋅ 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.
⋅ 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
⋅ 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.
⋅ 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
