[igx-spreadsheet] event for cell click in and how to customize for right click cell

Tam Le Van posted over 4 years ago

Hi team,

i want customize function when click on cell but i don't know igx-spreadsheet have support ?
and how to customize for right cell click, event for format cell like merge cell, color, border cell,...

An example would also be nice.
Thanks in advance

34430

Offline Andrew Goldenbaum posted over 4 years ago

Hello Tam Le Van,

I have been investigating into this post, and at the moment, I’m a little uncertain on exactly what you are looking to achieve in this case?

From your description, it sounds like you are looking to do something on right-click, although I’m a little bit unsure what. Are you looking to modify the default context menu that shows up on right-click with the igx-spreadsheet, or potentially something else?

Would it be possible for you to please elaborate a little bit further on what functionality you are looking to achieve with the igx-spreadsheet so I may be able to make a recommendation for you in this case?
Cancel
Reply

Cancel
15

Offline Tam Le Van posted over 4 years ago in reply to Andrew Goldenbaum

Cell click:
i want click/double-click in cell C3 of column C and want call function for show dialog like image below

Right-click:
menu edit cell like image below

Besides i want to format column "Column filter" like image above
i see that support in: https://www.igniteui.com/spreadsheet/filter-dialog-configurations
but not in Angular, how i do that.

Also I found a problem when you entered the cell: 'click/double-click 1' it automatically switches back to 1/1/2001
Cancel
Reply

Cancel
34430

Offline Andrew Goldenbaum posted over 4 years ago in reply to Tam Le Van
Hello Tam Le Van,

Thank you for your updates on this matter. I have been discussing this with our development teams, and unfortunately at the time of writing this, the behaviors that you are looking to achieve do not have anything implemented that would allow you to achieve them. More information below:

Cell Click: Unfortunately, there does not currently exist any sort of “cellClick” or “cellDoubleClick” event on the igx-spreadsheet control. The closest thing that is available is the “activeCellChanged” event, but this will not fire if, for instance, you already have an active cell and you click or double-click on it. This event will also fire for keyboard navigation and activation of cells via the keyboard.

Right Click: Like point 1, there does not exist a “rightClick” event on the igx-spreadsheet at the moment. Internally, we do have an event that can suppress the context menu on igx-spreadsheet, but this has not yet been publicly released. There also does not currently exist an object model for manipulation of the currently built-in context menu.

Column Filter Dialog: The column filter dialog that exists in the spreadsheet control for our Ignite UI for Javascript/JQuery toolset does not currently exist in our Angular igx-spreadsheet. We are working on a parity between the two platforms, but this dialog does not currently exist.

If you would like to see cell click events, an ability to modify the context menu, and the column filter dialog implemented in the igx-spreadsheet control, I would recommend suggesting a new feature request for these features. You can do this at our Angular Ideas Site, here. This will place you in direct communication with our product management teams who plan and prioritize upcoming features and development based on community and user feedback.

Regarding the cell value switch to 1/1/2001, could you please elaborate a bit on this? At the moment, I am unsure if I understand the behavior you are seeing, and I have not been able to reproduce it locally. Are you by chance able to reproduce this behavior on any of the samples in our online documentation for Angular, here?

Please let me know if you have any other questions or concerns on this matter.
Cancel
Reply

Cancel
15

Offline Tam Le Van posted over 4 years ago in reply to Andrew Goldenbaum

Regarding the cell value switch to 1/1/2001, I created the video to show here
Cancel
Reply

Cancel
34430

Offline Andrew Goldenbaum posted over 4 years ago in reply to Tam Le Van

Hello Tam Le Van,

Unfortunately, I am unable to view this video. On Google Chrome, I can see the video box, but nothing plays, but on other browsers, I don’t even see the video box.

Can you please provide a concrete set of steps or an isolated sample project to reproduce the behavior you are seeing instead?

Please let me know if you have any other questions or concerns on this matter.
Cancel
Reply

Cancel