I hope that the DataGrid in WPF can add the whole column selection function. It is better to also implement the pivot table function

[weiyoucheng]

When to add the whole column selection function to DataGrid. Users often need to copy the contents of an entire column, and it would be great if you could add the whole column selection function.It would be perfect if you could also implement functions similar to Excel pivot tables. At present, wpf has not encountered that it is too difficult to define a slightly more complex report of an open source pivot table component. If it is not feasible, you can also add a column grouping function

[miloush]

Thanks for filing the issue here. They are two different requests and should probably be separate issues. If you do file a separate issue for pivot tables, I think you need to expand on what functionality you are actually looking for, "function similar to Excel pivot tables" is not very well defined.

For selection, the situation is as follows:

• DataGrid.SelectAllCells() selects all cells
• clicking on DataGridRowHeader selects the row
• clicking on DataGridRowColumn sorts the column

In Excel, Ctrl+Space extends the selection to whole columns covered by the selected cells, and and Shift+Space extends the selection to whole rows covered by the selected cells (more precisely the last selected region).

One option would be to add DataGridRow.SelectAllCells() and DataGridColumn.SelectAllCells(), which should be relatively straightforward. It would also make sense to allow clicking on the header to select the column if the sorting is disabled.

[weiyoucheng]

感谢您在此处提交问题。它们是两个不同的请求，可能应该是单独的问题。如果您确实为数据透视表提交了一个单独的问题，我认为您需要扩展您实际正在寻找的功能，“类似于 Excel 数据透视表的功能”并没有很好地定义。

对于选择，情况如下：

• DataGrid.SelectAllCells()选择所有单元格
• 单击“选择行”DataGridRowHeader
• 单击对列进行排序DataGridRowColumn

在Excel中，+将所选内容扩展到所选单元格覆盖的整列，并将所选内容+扩展到所选单元格覆盖的整行（更准确地说是最后选定的区域）。CtrlSpaceShiftSpace

一种选择是添加，这应该相对简单。如果禁用排序，允许单击标题以选择列也是有意义的。DataGridRow.SelectAllCells()``DataGridColumn.SelectAllCells()

I don't know much English, which is something I probably don't say very clearly in Google Translate. I mean could he let him choose like Excel, when the user selects the entire column content when the user has a single column header (I know it can be done using Ctrl + Show + arrow keys, but it is more convenient to select the column contents by clicking on the column header, and some users don't even use shortcut keys). And you would like to remind me of another idea, can you add a filter function like Excel, by setting a property such as: "IsDisplayFilters = True" and then displaying the filter button at the header, when the user clicks the filter button, the filter window pops up, the window has simple ascending and descending order and filter function.

Thanks for filing the issue here. They are two different requests and should probably be separate issues. If you do file a separate issue for pivot tables, I think you need to expand on what functionality you are actually looking for, "function similar to Excel pivot tables" is not very well defined.

For selection, the situation is as follows:

• DataGrid.SelectAllCells() selects all cells
• clicking on DataGridRowHeader selects the row
• clicking on DataGridRowColumn sorts the column

In Excel, Ctrl+Space extends the selection to whole columns covered by the selected cells, and and Shift+Space extends the selection to whole rows covered by the selected cells (more precisely the last selected region).

One option would be to add DataGridRow.SelectAllCells() and DataGridColumn.SelectAllCells(), which should be relatively straightforward. It would also make sense to allow clicking on the header to select the column if the sorting is disabled.

I don't know much English, which is something I probably don't say very clearly in Google Translate. I mean could he let him choose like Excel, when the user selects the entire column content when the user has a single column header (I know it can be done using Ctrl + Show + arrow keys, but it is more convenient to select the column contents by clicking on the column header, and some users don't even use shortcut keys). And you would like to remind me of another idea, can you add a filter function like Excel, by setting a property such as: "IsDisplayFilters = True" and then displaying the filter button at the header, when the user clicks the filter button, the filter window pops up, the window has simple ascending and descending order and filter function.