asked on August 10, 2021
Hi,
I would like to know if it's possible to edit the value of a cell directly on double-click and save the value instead of having a pop-up appear on double click and then edit, save the value.
Warm Regards,
Akshay
⋅ August 10, 2021
Hello, Akshay,
Thank you for your question.
Flexmonster is designed for analyzing and visualizing existing data; hence, it doesn't focus on editing the underlying data set.
Nevertheless, aside from editing cells in the drill-through view, you can also edit cells directly on the grid in the flat layout (see example).
We hope this helps.
You are welcome to reach out to us if other questions arise.
Kind regards,
Vera
⋅ August 13, 2021
Hi Vera,
Thanks for your response. The flat layout actually does not work in our client's use case. I did read in one of the older threads that it's possible to override the drill-through view and implement a workaround solution to edit and save directly.
Please check this link and solution below in one the responses...
https://www.flexmonster.com/question/edit-cell-in-pivot-table/
But you can consider the following workaround:
Please let me know if this can work because its critical for our customer use to be able to edit and save the cell value directly without drill-through.
Warm Regards,
Akshay
⋅ August 16, 2021
Hello, Akshay,
Thank you for your reply.
Yes, the suggested workaround in the provided Support Forum thread could work.
The idea lies in tracking the clicked grid cell, providing your own text input to enter the new value, applying the changes to your data set, and refreshing the data in Flexmonster with the updateData() API call.
You can implement additional functionality outside of Flexmonster and use Flexmonster API to reflect the changes.
Also, you are welcome to check out a similar case with a JSFiddle example provided in the following Support Forum thread.
We hope this helps.
As always, feel free to reach out if you have questions.
Kind regards,
Vera
⋅ August 24, 2021
Hi Vera,
Thanks for this! We were able to implement the direct cell edit functionality and get it working.
An additional question..
As we edit and save the values in the cell directly and move to the next cell, is it possible to update the totals automatically as well?
Warm Regards,
Akshay
⋅ August 24, 2021
To be more clear on the second part.. is it possible to 'refresh' the updated totals as soon as we move out of a cell after edit/update?
⋅ August 26, 2021
Hello, Akshay,
Thank you for the update.
We are happy to hear that it worked.
When a cell value is edited, it is possible to update the totals the following way:
Once you provide the updated data set to Flexmonster, Flexmonster will recalculate the totals automatically. To reload the data in Flexmonster, you can use the updateData() API call.
We hope this helps.
Kind regards,
Vera
⋅ September 1, 2021
Thanks Vera, we were able to get the edit and totals update working correctly.
We however notice an issue that when we enter a value into the cell and click out into another cell, sometimes a row of cells get auto-selected. It happens intermittently and affects the user experience. Please see a short recording for your reference here and also the attached screenshot..
https://www.loom.com/share/8cabdfe9cb8448879ba82d3d0954da9f
Is there a way we can disable the multiple cell selection for our custom edit cells ?
Warm Regards,
Akshay
⋅ September 2, 2021
Hello, Akshay,
Thank you for your reply.
You can hide the cell selection via custom CSS combined with the showAutoCalculationBar: false property of the Options object.
Here is a JSFiddle for illustration: https://jsfiddle.net/flexmonster/9grcxL3w/.
Please let us know if this helps.
Kind regards,
Vera
⋅ September 2, 2021
Thanks Vera! Will try this and let you know.
Warm Regards,
Akshay
