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

1117 questions
9
votes
1 answer

Add a table type to a JSON editor

I want to understand the code of this JSON editor and modify it. In directives.js, there is a piece of code that tries to construct templates: var switchTemplate = '' ... ... + '
user6330767
9
votes
2 answers

Completely disable a handsontable

I have just started using handsontable with JSON data and its working great but I need to disable all table input to certain users (read-only view). Is there a way to completely disable a handsontable so none of the inputs respond and the remove row…
PeteT
  • 18,754
  • 26
  • 95
  • 132
8
votes
4 answers

Handsontable & React

I'm starting with react and trying to set up handsontable in my react app following: react-handsontable // import React... import React from 'react'; import ReactDOM from 'react-dom'; // ... Handsontable with its main dependencies... import moment…
Tim
  • 147
  • 1
  • 10
8
votes
6 answers

How to save edits made using rhandsontable r package

My R program works as expected. It shows a table containing my dataFrame, and lets me edit the values. How do I capture those values and save them to my dataframe, or a copy of my dataframe? require(shiny) library(rhandsontable) DF =…
PaeneInsula
  • 2,010
  • 3
  • 31
  • 57
8
votes
3 answers

How to disable adding new rows/cols in handsontable?

First of all, there is an well-known bug with handsontable (which is a great piece of code anyway), mentioned by e.g. user tezhm, on official github issues list for handsontable: When selecting a cell on the last row of a table and drag-selecting…
PolGraphic
  • 3,233
  • 11
  • 51
  • 108
8
votes
2 answers

Not able to delete rows using HandsOnTable

I am not able to remove rows with the latest version. I am using version 0.9.9. This is what I do: var $container = $("#add-table"); $container.handsontable(options); var handsontable = $container.data('handsontable'); var data =…
automaticAllDramatic
  • 2,025
  • 1
  • 21
  • 25
8
votes
2 answers

Retrieve data from handsontable to Struts2 Action via JSON not working

I am using struts2-json plugin to generate JSON data and Ajax to populate table (handsontable) with data from that JSON (according to the source). Now, I need to retrieve data from table to Struts2 Action using Ajax by JSON. First I've implemented…
Roman
  • 1,121
  • 4
  • 23
  • 38
8
votes
4 answers

Disabled inputs in bootstrap. How to apply it to a different TAG?

By using disabled attribute on an input is possible to prevent user input and trigger a slightly different look. Here is the demo http://jsfiddle.net/D2RLR/3023/ Let's suppose I want to apply the same style to a different TAG like a table. In fact,…
Lorraine Bernard
  • 13,000
  • 23
  • 82
  • 134
7
votes
1 answer

Type errors when extending component more than one level using forwardRef and useImperativeHandle

I'm experimenting with extending components in React. I'm trying to extend Handsontable using forwardRef and useImperativeHandle. First I wrap Handsontable in my own BaseTable component, adding some methods. Then I extend the BaseTable in a…
mottosson
  • 3,283
  • 4
  • 35
  • 73
7
votes
1 answer

How to sync multiple handsontable horizontal scrolling

I have 3 handsontables in my React view. I need them to be synced when the user is scrolling both horizontally and vertically. I tried to use javascript to get horizontally working without any luck. import React from 'react'; import ReactDOM from…
texas697
  • 5,609
  • 16
  • 65
  • 131
7
votes
1 answer

Issue with update content data in handsontable

I'm trying to implement handsontable. As per my requirement, I want to re-render handsontable from changing a dropdown value, but on dropdown selection, the handsontable does not update properly. Below is my code: Handsontable.vue: