DataGrid width not tied to browser window width about qgrid HOT 6 CLOSED

Thanks, yep I like this idea. This seems like it will be a common problem so it's definitely worth fixing.

One thing I'd like to do with this extension in general is allow users to specify SlickGrid options when they call show_grid, to allow everyone to take full advantage of the flexibility that SlickGrid already provides. Once I get that in place, you'd have a simple workaround for this sort of situation, or any others where the default SlickGrid options that I set in my code are not ideal.

That being said, a big value-add of this extension I think is the fact that the grid works reasonably well by default and there's very little set up. So I think it would also make sense for me to add some logic to automatically determine a reasonable column width based on the page width.

from qgrid.

Hi Tim,

"a big value-add of this extension I think is the fact that the grid works reasonably well by default and there's very little set up" <= Yep!

In my experience with pandas, my data is always larger than what can be fitted on screen, and the default pandas behavior that cuts it off is annoying. Not sure about other people's data sets, but in our case a default setting that automatically resizes the table would be great. It would be in line with what Excel, Matlab and many other tools do out of the box.

from qgrid.

Hi @TimShawver ,
Is this issue in progress?
Thanks @slavi for raising it. I'm quite surprised more people aren't following this.

from qgrid.

Hi @Telson, we have an open PR #23 which will allow people to pass SlickGrid options in to change the behavior of the grid. Specifically that will allow people to set SlickGrid's 'forceFitColumns' option to false to allow a scroll bar to appear (rather than trying to fit all the columns). There was some back and forth and it got forgotten, so thanks for reminding me. I'll resolve the open questions and merge it at some point this week (or maybe over the weekend).

from qgrid.

Hey @TimShawver , Great, Looking forward to it.!

from qgrid.

@Telson and @slavi, I merged a PR today so you now can achieve the desired behavior by setting grid_options like this:

qgrid.set_defaults(grid_options={
    'forceFitColumns': False,
    'defaultColumnWidth': 150
})

The set_defaults function sets the options for the grid for the lifetime of the kernel. You can also set grid_options for individual grids by passing them in to the show_grid functions, like this:

qgrid.show_grid(spy, remote_js=False, grid_options={
    'forceFitColumns': False,
    'defaultColumnWidth': 150
})

Use the question mark operator to see the doc strings about these new capabilities:

qgrid.set_defaults?
qgrid.set_grid_option?
qgrid.show_grid?

forceFitColumns and defaultColumnWidth are just two of the SlickGrid options that can be set this way. Here's the full list https://github.com/mleibman/SlickGrid/wiki/Grid-Options

Big thanks to @snth and @ssanderson for this awesome PR. We haven't yet updated our package on PyPI, so if you won't be able to get the updated version with pip yet. I'll do that tomorrow, but until then you'll have to just pull the latest from this repository to get the new capabilities.

from qgrid.