ColorPickerCellType handler

Posted by: craigreilly on 27 February 2023, 5:02 am EST

    • Post Options:
    • Link

    Posted 27 February 2023, 5:02 am EST

    I have a cell assigned the “ColorPickerCellType” but I can not seem to understand what handler fires when the color is selected.

  • Posted 28 February 2023, 7:03 pm EST

    Hello Craig,

    You can use the EditorValueChanged event handler of the ColorPickerCellType class to handle the event when color is selected.

    Please find the attached sample implementing the same.

    If you need any other help, please let us know.

    Regards,

    Prabhat Sharma.

    ColorPickerCellTypeDemo.zip

  • Posted 4 December 2023, 4:28 am EST

    What version did this become available? I am still on 13. I’m afraid to upgrade as whenever I do I have a ton of conflicts in the projects.

  • Posted 4 December 2023, 7:25 pm EST

    Hello Craig,

    We have tested with the last v13 version [13.45.20203.0] of Spread, and the EditorValueChanged event is there, which you can use to handle the event when color is selected.

    If you need any other help or are still facing any issues, please let us know.

    Regards,

    Prabhat Sharma.

  • Posted 5 December 2023, 4:07 am EST - Updated 5 December 2023, 4:12 am EST

    Here is your code converted to VB. Note all lines work except the last one. Confirmed we are using 13.45.20203.0

  • Posted 5 December 2023, 4:09 am EST - Updated 5 December 2023, 4:14 am EST

  • Posted 5 December 2023, 10:19 pm EST

    Hello Craig,

    Thank you for letting us know that you are using VB.NET. In VB.NET you can use the following code to raise the event handler so you can replace your code from:

     cellType.EditorValueChanged += CellType_EditorValueChanged;      
    


    To:

    AddHandler cellType.EditorValueChanged, AddressOf CellType_EditorValueChanged
    

    If you are still facing the issue then please let us know.

    Regards,

    Prabhat Sharma.

  • Posted 6 December 2023, 3:13 am EST

    Ahhh, got it. Apologies for leaving that out initially. I did not know the C# did this so differently.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels