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
7
votes
1 answer

Make Handsontable autocomplete popup wider than the column

The Customer ID column is setup to use autocomplete. The autocomplete values concatenates various customer information together, to aid the user in selecting the correct one. Once selected, the Customer ID is put into the grid. I cannot figure out…
Matt Slavicek
  • 841
  • 10
  • 18
7
votes
1 answer

Handsontable paste not working

I've implemented handsontable in MVC .Net 4 using razer views, and although the paste functionality works beautifully on localhost (both in release and debug mode), it fails once deployed. It fails silently (no console output) but if you double…
audiochick
  • 184
  • 1
  • 10
7
votes
3 answers

Conditionally highlight row in handsontable based on a cell value

I have several rows of data. One of the columns is an error flag. If the error flag is true, I want to change the background color of the entire row. How would i do that?
user3250795
  • 71
  • 1
  • 1
  • 2
6
votes
1 answer

How to use getCellMeta in afterChange at Handsontable?

I'm using handsontable js plugin. I want to use getCellMeta function in afterChange hook but not working. I when use function out afterChange hook, function is working. But not working in afterChange hook. var container =…
Hüseyin ASLIM
  • 153
  • 1
  • 15
6
votes
1 answer

Disable column editing in rhandsontable?

Suppose I have the following shiny app: library(shiny) library(rhandsontable) ui <- shinyUI(fluidPage( titlePanel("Handsontable"), sidebarLayout( sidebarPanel( helpText("Handsontable demo output. Column add/delete does work ", …
Ignacio
  • 7,646
  • 16
  • 60
  • 113
6
votes
1 answer

rhandsontable change background of specific row

I'm using rhandsontable in R shiny and I would like to change the color of the row with "Sum" in the first column. Since the number of rows is not fixed, selecting the "Sum" row based in its row number does not work. I have tried the attached code,…
ChrisW
  • 81
  • 6
6
votes
1 answer

Extending Handsontable

I'm trying to create a wrapper around Handsontable, to provide some additional features. I've tried doing the following and although the constructor works, the loadData function doesn't seem to get overridden. Any advice? I've tested this in…
Jitesh Vassa
  • 477
  • 5
  • 12
6
votes
2 answers

Initial handsontable view does not stretch to correct width

I have a handsontable object (in fact two objects, both in a bootstrap modal) that have data loaded after the page is built. Here's a jsfiddle that duplicates the problem https://jsfiddle.net/mtbdeano/w7dofbyy/ The tables are sized way too narrow,…
Deano
  • 1,136
  • 10
  • 19
6
votes
1 answer

Constraining HandsOnTable to the size of its parent container

I realize this is a simplistic example, but I wanted to get some explanation on how HandsOnTable expects to behave within a container. e.g. we have a Tab where we place HoT and we'd like it to consume 100% of the container space, but right now it…
bkbonner
  • 105
  • 2
  • 7
6
votes
1 answer

handsontable destroy and create

I want to destroy and recreate my excel sheet i'm using Handsontable for it the object is getting destroyed and created new but the data inside the row is same for new table as well for old one since the title is similar to SO QUESTION i've…
MayuriS
  • 337
  • 1
  • 4
  • 17
6
votes
1 answer

Instantiate Handsontable with no data

Seems like a simple task yet I haven't found a simple solution yet. My data sometimes comes as an empty array so that the user can start working off of an empty table (except for the headers). The table has a minSpareRows:1 so I was hoping the table…
ZekeDroid
  • 7,089
  • 5
  • 33
  • 59
6
votes
4 answers

How do I add a custom Button inside a cell in handsontable?

I am trying to add a custom save button at the end of each row in handsontable. I am using handsontable package in laravel 4. The button shows up like this:
aps5842
  • 125
  • 1
  • 2
  • 10
6
votes
3 answers

AngularJS and Handsontable: How to think about data binding between datacolumn elements

I am trying to rewrite a JS/jQuery SPA using AngularJS. The SPA is an item editing grid using the amazing Handsontable. I was delighted to see that there is an AngularJS version in the works, and that, for the most part, it works just as…
scott_trinh
  • 155
  • 1
  • 8
6
votes
5 answers

add column dynamically to handsontable

I am trying to dynamically add a column to a handsontable. I don't see a sample anywhere nor o i see a method to do so in the API. Has anyone figured out a way to overcome this or have some sample code that I can look at that would help. Thank you.
Pawan
  • 293
  • 1
  • 3
  • 13
6
votes
3 answers

Ruby on Rails: send javascript array of arrays to ruby controller

I would like to send a javascript array of arrays to my ruby controller. I am a bit lost. My question is in the controller. Here is what I have so far: (totalChanges is an array of arrays. JSON.stringify(totalChanges) might look like this:…
bdeonovic
  • 4,130
  • 7
  • 40
  • 70
1 2
3
…
74 75