Multi-Select Dropdown Support in BlazorDatasheet!

[manharsinh22]

Hello Team,

I've been working with the BlazorDatasheet component and noticed that there's no built-in support for multi-select dropdowns. I have researched and found that it's not available out-of-the-box, but I want to confirm if anyone knows when this feature might be added or if there are any workarounds or custom solutions available.

Has anyone successfully implemented a multi-select dropdown in a BlazorDatasheet cell, or is there a recommended approach for achieving this behavior? Any suggestions or insights would be greatly appreciated!

Thanks in advance!

[anmcgrath]

Hi @manharsinh22 I have no current plans to do this but you could follow the examples on custom editor and custom renderer and register a type called "multi-select" or something similar. If you want to do this for your project you could use a multiselect control from another blazor UI framework and it should work well.

[ADefWebserver]

I have an example of a complex custom renderer here: [src/BlazorDatasheet.SharedPages/Pages/DataEditor/CustomRenderer]
(https://github.com/ADefWebserver/BlazorDatasheet/tree/main/src/BlazorDatasheet.SharedPages/Pages/DataEditor/CustomRenderer)

[manharsinh22]

Hello Team, Thank you for your suggestion regarding implementing a custom editor and renderer for a "multi-select" type. I wanted to let you know that I’ve followed the examples and successfully integrated the custom renderer. It’s working as expected, and I truly appreciate your guidance. I have, however, encountered another requirement in my project and was hoping you could help with some insights. The feature I’m trying to implement involves auto-populating other cells based on the selection made in a specific cell. For example, if the user selects "Option 1" in Cell 0, it should dynamically update the values of Cell 2 and Cell 3 accordingly. I’ve looked for any override methods or events in the framework that could facilitate this functionality, but I haven’t been successful in finding one that works. Is there any event or method you would recommend to handle such scenarios? If possible, could you share an example or guide me on how to achieve this? Looking forward to your response. Thanks again for your assistance!

…

On Tue, Nov 19, 2024 at 3:21 AM Michael Washington ***@***.***> wrote: I have an example of a complex custom renderer here: [src/BlazorDatasheet.SharedPages/Pages/DataEditor/CustomRenderer] ( https://github.com/ADefWebserver/BlazorDatasheet/tree/main/src/BlazorDatasheet.SharedPages/Pages/DataEditor/CustomRenderer ) image.png (view on web) <https://github.com/user-attachments/assets/60fe67e5-0eae-4138-88ea-e26865ded283> — Reply to this email directly, view it on GitHub <#124 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BDHYHCOQED63G3CWX2KOCRD2BJOMXAVCNFSM6AAAAABR7HYTX2VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMRZG4ZDINA> . You are receiving this because you were mentioned.Message ID: ***@***.*** com>

-- Thanks & Regards, *Manharsinh Jadeja*Sr. Software Developer, Biztech Consultancy Pvt. Ltd. *Email:* m ***@***.***>***@***.*** www.biztechcs.com We follow a strict data compliance policy as per GDPR legislation, effective from 25th May 2018. In order to remove your personal data or unsubscribe from all our emails, send us a reply and we will take the necessary actions.

[anmcgrath]

Hi @manharsinh22
You could use formulas in the cells as one method. Currently we support a small number of excel formula. IF is one of them.

You could also listen for a cell changes through Sheet.Cells.CellsChanged event and handle the updates to the other cells in that way.