Export Excel versus export CSV on a grid. Issues.

Jaymer

Several years ago, I played around with Scripps on a grid to set headings and use a template and adjust some of the parameters.

I wanted to improve some PDF output. Like turning it sideways or using a bigger sheet of paper.

wanted to improve some PDF output. Like turning it sideways or using a bigger sheet of paper.

I was mildly successful with this.

But an issue I have now and I’m not sure if Vlad can adjust this, is that an export Excel XLSX only sends the current page, whereas the CSV export sends the entire set of records in the query, regardless of visual page size.

only sends the current page, whereas the CSV export sends the entire set of records in the query, regardless of visual page size.

Make sense?

If 1000 records should show in the grid, and I’m viewing it in pages of 20, Excel will get only the first 20 records, CSV will get all thousand records.

Yes, I have made dedicated grids that return/show 1000 records, with the trade-off of it being now very sluggish, but at least a user can get all of the records exported.

But it would be nice not to have to do this and have multiple queries to maintain.

kklosson

Maybe Vlad can change this, and I think he should, but you should be able to get what you want with an Excel report.

customaware

Indeed Jaymer.
I’ve run into this a lot and you workaround is the way I do it.

In some apps now I have included a range of different Flexmonster Pivots (some with integrated Highcharts charting) and they all love love it. Gives them basically unlimited flexibility to construct the data list they want and put it immediately out to Excel.

Jaymer

JUST NOTICED THE GARBAGE IN MY OP. ENTERED FROM PHONE ON THE MOBILE VERSION. SUX

EDIT

Several years ago, I played around with Scripts on a grid to set headings and used a template and adjusted some of the parameters. I wanted to improve some PDF output. Like turning it sideways or using a bigger sheet of paper.
I was mildly successful with this.

But an issue I have now (and I hope Vlad can adjust this) is that an export Excel XLSX only sends the current page, whereas the CSV export sends the entire set of records in the query, regardless of visual page size.

Make sense?

If 1000 records should show in the grid, and I’m viewing it in pages of 20, Excel will get only the first 20 records, CSV will get all 1000 records.

Yes, I have made dedicated grids that return/show 1000 records, with the trade-off of it being now very sluggish, but at least a user can get all of the records exported.

But it would be nice not to have to do this and have multiple queries to maintain.