Stack Overflow
Stack Overflow

Questions tagged [handsontable]

Handsontable is a composite spreadsheet component for apps and websites written in JavaScript and HTML.

Handsontable is a composite spreadsheet component for apps and websites written in JavaScript and HTML. Handsontable Community Edition is open sourced and MIT-licensed and there's also Handsontable Pro, a commercial version with extra features. A number of features may be experienced at the examples page.

Website: http://www.handsontable.com

1070 questions
210
votes
0 answers

Rendering Angular components in Handsontable Cells

In a project of mine, I try to display Angular Components (like an Autocomplete Dropdown Search) in a table. Because of the requirements I have (like multi-selecting different cells with ctrl+click) I decided to give it a go with handsontable. I've…
phhbr
  • 2,360
  • 1
  • 11
  • 22
36
votes
1 answer

On Handsontable, if there is similar columns header, then the first columns cell value is auto copied to other similar cell

Whenever I enter a value in the first cell, then the same value is auto copied to the same name header cell. How can we stop this? I tried to google this issue but didn't found any suitable solution. Here is the code: $.ajax({ type: "POST", …
Sudhanshu Saxena
  • 1,154
  • 12
  • 30
21
votes
4 answers

How do I edit the header text of a Handsontable?

I'd like to be able to edit the text of column headers in a Handsontable but I can't seem to figure out if it's possible to make them editable. I suppose I could make the headers just another row, but I'd like to avoid that if at all possible. To…
ksigmund
  • 498
  • 1
  • 5
  • 13
18
votes
2 answers

Handsontable dropdowns with multiple selections

I am trying to extend the handsontable plugin to support multiple selections in its dropdown list. I have already tried extending the base Editor built into the library by modifying the 'dropdownEditor' as suggested …
Alpha G33k
  • 1,367
  • 1
  • 8
  • 19
14
votes
4 answers

How to get handson table data in json format with column header as key

I have handsontable and I want to get data enter on handsontable cell into server side. I have tried to ran below code but data is not in expected format. I was expecting to get the data in pure json format as column header as key. Html code
user4736585
13
votes
1 answer

Handsontable Replace autocomplete values with key before posting

I am using HandsOnTable to make editing database tables more interactive on my site. HandsOnTable fulfils nearly all my requirements except that some columns in my database actually store foreign keys rather than local string values. In the UI I…
Chopo87
  • 1,170
  • 4
  • 17
  • 31
11
votes
1 answer

Update handsontable by editing table and/or eventReactive

I am using the rhandsontable package in a Shiny app which should have the following functionality: the data used in the calculation can be randomly generated, invoked by an actionButton (and when the app starts) the data can be manually edited by…
Patrick Roocks
  • 2,791
  • 1
  • 12
  • 25
11
votes
2 answers

Get selected rows of Rhandsontable

I am using rhandsontable in a Shiny App and I would like to know how to use the getSelected() method of Handsontable in this case, as I intend to apply changes on the data.frame. thank you!
Laia Cabré Vandellós
  • 151
  • 1
  • 3
11
votes
4 answers

Anyway to filter rows with Handsontable?

I'm currently trying to add a search filter on a column in handsontable. I can use the callback of the search plugin to hide the rows with css but that breaks scrolling. The search plugin also seems to only look at the first 100 or so of a table.…
Michael B
  • 7,282
  • 3
  • 25
  • 54
11
votes
3 answers

When using Handsontable how to force a selected cell into edit mode?

Handsontable provides some nice hooks for when a cell is selected but I can't seem to figure out way to get it to allow me to force a cell into edit mode when it has been selected. I can detect the cell selection like…
Jamie Poitra
  • 281
  • 3
  • 14
10
votes
3 answers

Prevent Handsontable cells from being selected on column header click

In a Handsontable, when a column header is clicked, all cells of that column are selected. Is the a way to prevent this from happening ? I don't think there's such an option in the documentation. I didn't find where the events are registered on the…
Alexandre Dubé
  • 2,622
  • 1
  • 14
  • 28
10
votes
2 answers

Retrieving a hidden header inside a sorted handsontable instance

When using Handsontable, it seems hard to retrieve the header of a row from a contextual menu. Consider the following data source: var data = function () { return [["1212", "roman", "i", "ii", "iii"], ["3121", "numeric", 1, 2 ,3], …
Thibault Martin
  • 509
  • 2
  • 5
  • 16
10
votes
2 answers

How to set dropdown width in handsontable

I am trying to set width of handsontable dropdown to be according to the lookup data width, not column width. How can this be achieved? See picture below please. Dropdown is too narrow to fit lookup data.
husayt
  • 12,616
  • 7
  • 45
  • 75
10
votes
3 answers

Is there any excel-like grid solution for AngularJS

I found ngHandsontable very satisfying. http://handsontable.com/ However, it does not support inserting columns which Handsontable supports. So I'm wondering if there is any other solution that is similar to ngHandsontable but also supports dynamic…
Isilmë O.
  • 1,568
  • 3
  • 18
  • 33
9
votes
2 answers

handsontable .getData by div id is not working?

I'm trying to get the filled data using the div id but it is throwing $container.data(...) is undefined.
I have…
mkHun
  • 5,507
  • 1
  • 25
  • 65
1
2 3
…
71 72