Planned
Last Updated: 29 Mar 2022 12:25 by ADMIN
Greg
Created on: 03 Feb 2020 10:49
Category: Grid
Type: Feature Request
10
Multiple Cell Selection (not full row)
My users need to select cells rather than entire rows, as they come from an MS Access background.
9 comments
ADMIN
Nadezhda Tacheva
Posted on: 29 Mar 2022 12:25

Hi Nicholas,

Yes, this enhancement is in the 2022 backlog. Once we know which release will contain its implementation, we will add a label with the release number. You can follow the request, so you will receive email notification for this update.

Regards,
Nadezhda Tacheva
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Nicholas
Posted on: 24 Mar 2022 21:07
This still planned for 2022?
ADMIN
Nadezhda Tacheva
Posted on: 09 Sep 2021 08:42

Hello Daniel,

Currently, there is no available workaround, however this feature is included in our roadmap and it is planned for implementation in 2022.

The easiest way to keep in track with its progress is to follow the item. Thus, you will be notified via email on status changes. Once we know which release will contain its implementation, we will update its status.

Regards,
Nadezhda Tacheva
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Daniel
Posted on: 07 Sep 2021 15:29
Do you guys have a timeline on this? Or a workaround ? Other than trying to integrate a JQuery version of the grid?  
ADMIN
Nadezhda Tacheva
Posted on: 28 Jul 2021 15:26

Hello Nicholas,

Generally speaking, the key purpose of the Multiple Cell Selection feature is to allow the user to select multiple cells depending on the chosen mode of selection (for example cell selection, drag selection, etc.). You can explore this feature functionality in some of our other suites, for example Kendo React Grid Selection (it is very similar to the upcoming Blazor Grid Multiple Cell Selection in terms UI as we are using a shared resource for the styles).

After the user selects the desired cells, what will happen with them and how the selected items will be handled is a matter of further customization depending on the application business logic.

The Spreadsheet Component that my colleague Marin mentioned in his previous post will provide far more excel-like features. However, if you don't consider it a good fit for your scenario, and you are only looking for ability to paste content onto the Grid instead of using the built-in abilities for creating new items, you can take a look at this sample project in our public repository - Import (Paste) from Excel. It demonstrates one way you could implement such ability for your app.

I hope you will find the above information useful. If any further questions appear, please let us know.

Regards,
Nadezhda Tacheva
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Nicholas
Posted on: 21 Jul 2021 18:05

In the majority of my use cases, we need to lock the user into a specific set of columns / data items.  Say you have a product list that is trying to be updated and you have 15 items in Category 1, which have been configured, but then Category 2 needs to also be configured and the list of items are almost the same except for 1 or 2 attributes.

If you are using excel the user will copy and paste then modify the necessary attributes.  It feel natural to them.  In an application we generally turn around and say you have to do the data entry of each of the 15 items individually. 

Another example would be I have 1 item and I need to create 30 of them where 1 thing is different.  In a spreadsheet again I can easily copy and paste to create the 30 items and then quickly modify the 1 thing that is different.  Again in an application we generally ask them to enter each item individually 30 times.

However, we don't want to give them the flexibility of an actual spreadsheet to add extra columns, do merges, add summary information, etc.  We only want to allow them to have that smooth experience of copy and pasting.

Custom code is always an option (If we had the cell selection capability) but having some hooks to enable a smoother user experience for this type of "story" would be ideal.

 

ADMIN
Marin Bratanov
Posted on: 21 Jul 2021 17:46

Hello Nicholas,

For excel-like behavior, you may want to Vote for and Follow a spreadsheet component: https://feedback.telerik.com/blazor/1442151-spreadsheet-component. There are many differences between a grid and a spreadsheet, with the key one being that grids don't have formulas, calculations, and that they repeat the same row for the model they are given, while the spreadsheet is much more free-entry.

Regards,
Marin Bratanov
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Nicholas
Posted on: 21 Jul 2021 16:36
Nice to have the cell selection and copy / paste be as close to how it is done in excel as possible.
Greg
Posted on: 03 Feb 2020 23:04

Some thoughts on selection and copy from the grid are as follows:

  • It would be good to have an extra option in GridSelectionMode for "MultiCell" or "CellRange"  etc.
  • In it's simplest form, this would allow a user to select grid location B3 and then Shift + D6 to highlight the range B3:D6. (Obviously these are grid column/Row references)
  • If a grid hierarchy was implemented, it would be good if the selection mode would work if the hierarchy was collapsed, although if expanded, it shouldn't be expected to span child grids.
  • If Ctrl + C is pressed, copy the range to clipboard to allow pasting into Excel or other application.
  • The clipboard capture could be WYSIWYG.  eg. if foreign Key / Template column is included in the range, just pick up whatever is shown in the cell (ie. not the underlying ID).  A possible exception to this is checkboxes.  It would be good to return true / false or 0 / 1 in that circumstance.

In terms of pasting into the grid, following are some thoughts:

  •  Once the desired grid contents are in Clipboard, user should select the desired paste range in the Grid (eg. B3:D6). Even if the clipboard range is bigger than this, it should only paste within that range (possible exception for new rows - see subsequent point).  If the clipboard range is smaller than the selected range, cells outside of the clipboard range should be unaffected.
  • It would be "nice" to be able to create new records from the clipboard, but not the end of the world if we have to create the records first.  
  • It would be good if the paste functionality was able to parse some of the basic data types (eg. numeric, text, datetime etc.) For checkboxes, it would be good if it was possible to parse true/false or 0/1 into the Checkbox.
  • For more complex requirements (eg. data validation) that might take a bit of work to do in a generic sense.  One option might be to just implement the basic paste functionality using a WYSIWYG philosophy that can be overridden by the developer if necessary if an OnPaste event is available.