I have two feature requests

Nov 26, 2013 at 7:06 PM
1) Can you add exporting the grid directly to excel/csv?
2) how about adding a LINQ query execution engine on top of the visualizer? once you have full collection in memory, using code dom, you can compile user query as a program, feed the collection to the newly compiled program and then get the result from it.
Coordinator
Nov 27, 2013 at 10:07 AM
What are you referring to, the Enumerable Debugger Visualizer?

1) You can currently copy and paste from the grid into excel - essentially export to clipboard

2) Are you asking for LinqPad?
Nov 28, 2013 at 2:59 AM
1) Copy paste would work, but I did not find it so convenient
2) something similar to linqpad. here is the scenario, i have a maze of methods, which do lot of data aggregation work and I often need to debug through large data sets. I need to be able to see whether certain set of rows are available on the collection or not. so adding a small text box to write linq query against the collection and binding the result to the grid helps in debugging large queries.
Nov 28, 2013 at 3:02 AM
I actually got this exception when I tried to export to excel.. that made me think of csv:

https://scontent-a-pao.xx.fbcdn.net/hphotos-frc3/1469858_10201551328117605_1732512636_n.jpg
Coordinator
Dec 1, 2013 at 9:21 AM
amithegde wrote:
I actually got this exception when I tried to export to excel.. that made me think of csv:

https://scontent-a-pao.xx.fbcdn.net/hphotos-frc3/1469858_10201551328117605_1732512636_n.jpg
How did you make that happen?
Not by pressing the 'Copy' button above the grid I suspect.
Coordinator
Dec 1, 2013 at 10:04 AM
amithegde wrote:
2) something similar to linqpad. here is the scenario, i have a maze of methods, which do lot of data aggregation work and I often need to debug through large data sets. I need to be able to see whether certain set of rows are available on the collection or not. so adding a small text box to write linq query against the collection and binding the result to the grid helps in debugging large queries.
Wouldn't a filtering UI, such as in Excel, be more convenient?
Dec 1, 2013 at 12:33 PM
1) my text was too long and because of that I got that exception. I did it by choosing print> export to excel. More details on the size limit here: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291

2) I find it better to implement it on my own rather than justifying it here. Let's stop discussing on this. I just wanted to convey that when you are debugging some issue, it is not at all convenient to export to excel every time and start doing aggregation and filtering there.

Let's stop this discussion; I will go ahead and implement these features on my own. Thanks for the time.
Coordinator
Dec 1, 2013 at 5:41 PM
amithegde wrote:
1) my text was too long and because of that I got that exception. I did it by choosing print> export to excel. More details on the size limit here: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291

2) I find it better to implement it on my own rather than justifying it here. Let's stop discussing on this. I just wanted to convey that when you are debugging some issue, it is not at all convenient to export to excel every time and start doing aggregation and filtering there.

Let's stop this discussion; I will go ahead and implement these features on my own. Thanks for the time.
1) That's a long-winded way to get the data into excel - I've not tried that in years, I would just use the 'Copy' button (above the grid, on the the other side of the combo from the print button)

2) My point is that buying a third party grid that supports Excel-like filtering and swapping that in for the DataGridView would seem a quicker way of getting the functionality that your after. http://stackoverflow.com/questions/1239525/c-sharp-winforms-datagridview-with-sorting-filtering-like-ms-excel
or modifying the existing DataGridView to do column filtering
http://www.codeproject.com/Articles/19182/Datagridview-with-filtering-capability

but either way, when you implement a solution I'll be happy to add it to the visualizer, if you wish.