danny-sg/slickgrid-spreadsheet-plugins

slickgrid-spreadsheet-plugins

These plugins aim to add additional spreadsheet type functionality to SlickGrid.

Filter (ext.headerfilter.js)

This adds a filter to the column header, displaying an ordered list of the values that can be selected or un-selected to filter.

The plugin relies on the grid data being sourced from a DataView as it handles the filtering.

Overlays (ext.overlays.js)

This plugin creates additional overlays/adorners for the grid.

• Rows and Grids are hilighted based on the selected cell
• The selected cell has a full border around it, including a handle to enable a Fill Down type functionality

For examples of the both plugins see:

http://danny-sg.github.io/slickgrid-spreadsheet-plugins/examples/example-1-everything.htm (Excel style)

http://danny-sg.github.io/slickgrid-spreadsheet-plugins/examples/example-2-everything.htm (Google Docs style)

slickgrid-spreadsheet-plugins's Issues

[Question] How can I highlight the entire selected row?

Splice method on ext.headerFilters not working to IE <= 8

On the function attached to the click event for the OK button of the filters there is a splice method applied to the workingFilters variable. The slice method only receives one argument and this not work as expected on IE 8 and older versions, the method needs to receive a second argument to work fine. I removed the splice method to the workingFilters array in my code but I need to know what this splice do exactly with the workingFilters array.

Numeric sort doesn't appear to behave as expected

http://danny-sg.github.io/slickgrid-spreadsheet-plugins/examples/example-1-everything.htm

Click the dropdown for Id, sort ascending. Sorts: 0, 1, 10, 100, 101, etc.

Fill up doesn't work properly

The range starts at the top most cell, so fill up currently makes it look like the whole thing has been shifted upwards.

The easiest thing to do will be to add the active cell as an additional argument

moveSelectionOverlay sometimes doesn't detect position

While working with this plugin, I was having an issue with it on the very last line new row
Uncaught TypeError: Cannot read property 'bottom' of null
ext.overlay.js:155

I was able to work around this by modifying the script and finding the following line

            var position = grid.getCellNodeBox(activeCell.row, activeCell.cell);

And then added in:

            if (position == null) {
                position = grid.getCellNodeBox(activeCell.row - 1, activeCell.cell);
                var options = grid.getOptions();
                position.top += options.rowHeight;
                position.bottom += options.rowHeight;
            }

This hasn't solved my issue with after hitting enter that no new line shows up, but has resolved a console error.

how to save filters in local storage

hello,
I'm french, so please excuse me for my poor english

I want to save the filters selected to restore them at the next session.
In the base slickgrid, I do it with the columnFilters[i] parameters, but in your case It's a lot more difficult. Can you explain me how to access at these parameters ?

Dominique

[Question] License

Great Work on this plugin. It would be ideal if we are aware of the license information for the usage.

Weird sorting in IE and Chrome

Unable to import this plugin in ts file

Can you please help in integrating this plugin in ts file?
I'm using Angular-slickgrid and there none of the drag events getting fired.

The lib version used in my app are:

Angular-slickgrid: ^2.7.2
jQuery: ^3.4.1
Angular: ~7.2.0
Typescript: ~3.2.2

Any help appreciated?

Filter images are not working

Hi,

This plugin and its functionalities are working properly however, for some reason, the images (sort-asc, filter and down etc) are not displayed.

While testing I have made sure that I have the same folder structure as the example.

Could someone please help me with this?

Thanks,
Navin

not able to retain checkbox selection

added data to slickgrid with checkbox, checked one of the row. then applied filter from header dropdown. previously selected row is now unchecked. Vice versa case, add data to slickgrid, apply filter. checked one of the row. Clear all Filter/Select All, row is unchecked.

Still actively being developed?

Hi, I was going to submit a pull request soon to fix 1 or 2 bugs I noticed. Is this project still actively developed or at least is it worth the time to fork, fix the code, and submit a request? I just want to be sure this isn't a forgotten project before I spend some time on it. I've used the plugin before and it is excellent.

Fill Down-Plugins not working with forzen column [slick grid] ..

Hi..

when I tired to add the Plugin features in the frozen column file...

The Fill Down functionality work's fine in the no. of freeze columns, but the same doesn't work in the other half .. .. can you check in to that.. and comeback with how to get it fixed? .. Would be great...

Need excel like drop down selection filter with check box in input field.

Hello, I am working on one of the requirement, where I need to add a down icon in input field and on click of down icon, excel like drop down selection filter with check box should come.

Currently the down icon we can see on column header and on click of that icon selection filter will open to select the values to be filter.
I want the same above functionality in input field. Let me know how we can achieve the same.