Questions tagged [slickgrid]

SlickGrid is a specialized JavaScript grid/spreadsheet component optimized for high performance, even with many thousands of rows of underlying data.

SlickGrid utilizes virtual rendering to enable you to easily work with hundreds of thousands of items without any drop in performance. This is achieved through virtual rendering where only what’s visible on the screen plus a small buffer is rendered. As the user scrolls, DOM nodes are continuously being created and removed. These operations are highly tuned to provide optimal performance under all browsers. The grid also adapts to the direction and speed of scroll to minimize the number of rows that need to be swapped out and to dynamically switch between synchronous and asynchronous rendering.

It is an advanced component and is a bit more difficult to learn and configure, but is correspondingly extremely flexible.

Some highlights:

  • Adaptive virtual scrolling (handle hundreds of thousands of rows with extreme responsiveness)
  • Extremely fast rendering speed
  • Supports jQuery UI Themes
  • Background post-rendering for richer cells
  • Configurable & customizable
  • Full keyboard navigation
  • Column resize/reorder/show/hide
  • Column autosizing & force-fit
  • Pluggable cell formatters & editors
  • Support for editing and creating new rows.
  • Grouping, filtering, custom aggregators, and more!
  • Advanced detached & multi-field editors with undo/redo support.
  • “GlobalEditorLock” to manage concurrent edits in cases where multiple Views on a page can edit the same data.

Useful links

1268 questions
5
votes
7 answers

in slickgrid how I can delete a row from a javascript function

how I can delete a row from a javascript function from a button for example
gerar
  • 51
  • 1
  • 1
  • 3
5
votes
1 answer

Missing space when I change the cell's background color in SlickGrid?

I was trying to change cell's background color with custom formatter like this: var myCellFormatter = function(row, cell, value, columnDef, dataContext) { if ((row + cell) % 5 == 1) { return "
" + value…
Misha Moroshko
  • 166,356
  • 226
  • 505
  • 746
5
votes
1 answer

Validating all cells in all rows of SlickGrid

Given a SlickGrid, how can I trigger all cells in all rows to be validated? Or perhaps to use JavaScript to trigger once cell to be validated (which I can then use against all cells in all rows)? The use case is one where the user must edit every…
jwl
  • 10,268
  • 14
  • 53
  • 91
5
votes
1 answer

Updating a single cell (not the entire row) in slickgrid with DataView

I have a slickgrid (using a DataView) that I'm using to display rapidly changing values. As far as I know, when a value changes in the underlying model, the only choice I have is to update the entire row: dataView.updateItem(rowId,…
ricklane
  • 173
  • 1
  • 11
5
votes
1 answer

Does ng-grid support virtual scrolling?

I wanted to use Slickgrid for the grid functionality in my app but since I am using AngularJS for the most part i thought that ng-grid is the way to go but not sure whether it supports virtual scrolling (I tried to look into their documentation and…
Ajax3.14
  • 1,647
  • 5
  • 24
  • 42
5
votes
2 answers

SlickGrid selection issues on sort

When using SlickGrids selection and sorting together I found that the selection is storing the index of the selected rows rather than storing the selection for the data you selected. How can I fix this so that the selected data is remembered instead…
Blowsie
  • 40,239
  • 15
  • 88
  • 108
5
votes
2 answers

Is there a way to force a single row refresh with SlickGrid?

I have the amazing SlickGrid configured to access data asynchronously and post user changes back to the server asynchronously. In general terms, the server may modify a few fields of a row based on the user's changes. As such, after the row is…
jbarlow
  • 1,500
  • 14
  • 21
5
votes
2 answers

SlickGrid 2.0 can't change row background color in odd indexes

I'm trying to change the background color using this code: data.getItemMetadata = function (index) { if (index === 5) { return {cssClasses: "Unverified"}; } } It works perfect as long as the index is…
Slime recipe
  • 2,223
  • 3
  • 32
  • 49
5
votes
3 answers

slickgrid resize causes scrollbar gap near bottom

I have the following problem: I use Slickgrid in combination with jquery layout. Panes can be resized with this plugin. When I resize the Slickgrid pane, so that a horizontal scrollbar appears, which wasn't there at first, I am unable to scroll all…
Dittrich
  • 81
  • 1
  • 4
5
votes
1 answer

Slickgrid add colour to a cell/ column or row

I have a slickgrid which works fantastic, it has calculations/ subtotals / expenses etc, The subtotals are not fixed a one row they move down as Items are selected above. However I am stuck at change the colour of the text in this one cell to red?…
chris
  • 551
  • 1
  • 13
  • 32
5
votes
3 answers

How to implement jQuery autocomplete in SlickGrid cell editor

I am setting up SlickGrid and need to have a column with an autoComplete editor. I tried it my modifying TextEditor or DateEditor. Nothing works. Can anybody give me a rough sketch of an implementation by using the TextEditor as a basis? Thanks a…
user1596343
  • 101
  • 2
  • 10
5
votes
0 answers

How do I get the row height in a slickgrid formatter?

I'm making a formatter for slickgrid that will display a url as an img tag. Due to the complexity and performance issues involved slickgrid doesnt support dynamic row heights but it does allow setting the global row height via the options. var…
user310988
5
votes
2 answers

SlickGrid: How to view full text in column headers?

I'm using SlickGrid, and right now, if I have really long column headers, SlickGrid cuts the header short with ellipses (...). My question is: Is there's a way to view the whole text on mouseover? By the way, I was able to do it for long cell…
Crystal
  • 191
  • 5
  • 10
5
votes
4 answers

SlickGrid functions for CSV export?

Within a Django application, I'm using SlickGrid to bind some XHR data to a client-side spreadsheet: var grid; var review_url = '/api/reviews/?t=' + current_tcode; $.getJSON(review_url, function(data) { grid = new Slick.Grid("#myGrid", data,…
flossfan
  • 10,554
  • 16
  • 42
  • 53
5
votes
1 answer

Using SlickGrid Aggregation/ Sum of a column

I am simply trying to sum a column and display the total at the bottom of the table. From looking at examples it seems like using an aggregator is the best way to do this. However when I simply add in dataView.setAggregators([ new…
Ryan
  • 204
  • 3
  • 12