Hi there!
I need to make Pivot Table (cells) editable. Is there any possibility to do so?
For example with datatable-property?
Thank you,
Thomas
Hi,
Pivot Table is a showcase for the result of data aggregation. Cells values shouldn’t be edited. Technically, yes, you can enable editor directly for the inner datatable, but it will interrupt the component’s logic.
Hi Listopad,
could you please show me how to enable editor in pivot? I’ve tried it like in this comment, but didn’t work: http://forum.webix.com/discussion/865/enable-cell-editor-in-pivot-component
I need to override aggragated Sums, as well as the single data sets. Then I have to recalculate the aggregation or single data with business logic.
Would this be possible?
No. That’s exactly the way I’ve mentioned. Real data won’t be updated from such edition and the new value will be lost after changing the config or will cause calculation issues.
If you need to edit the data, I strongly recommend you to use the separate datatable.
But would it be possible to turn off the aggregation logic of pivot table and implement a customized aggregation logic?
What I do need is the presentation logic of pivot table and I need to edit the cells as textfield, checkbox, datepicker, combobox and so on.
Would this be possible to do with pivot table? Or are there other webix components to do so?
Any suggestions?
Pivot is not editable. However, you may consider onBeforeRender event and datatable customization - possibly they will fit. You can try to enable editing for datatable and set editor types for columns:
http://docs.webix.com/pivot__customization.html#gettingdatatableobject
http://docs.webix.com/pivot__customization.html#prerendercustomization