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
4
votes
4 answers

handsontable: hide some columns without changing data array/object

I have a data to show in grid. I am using handsontable to show data. Each 3rd column is computed as difference of previous two (for example, 3rd column is rendered as the sum of 1st and 2nd column; this is done by custom renderer taking sum of i-1…
renathy
  • 5,125
  • 20
  • 85
  • 149
4
votes
0 answers

HandsOnTable Copy/Paste does not function correctly in some browsers

Copy/Paste functionality works correctly in Chrome and works poorly in Safari. I am running on Mac OS (Maverick). The code uses Handsontable 0.11.4 and ZeroClipboard plugin. Operations that work in both browsers: Copying and pasting inside the grid…
Michael Smolyak
  • 593
  • 2
  • 6
  • 21
4
votes
1 answer

How in handsontable scroll to row?

Set the range of visible lines or scroll to the desired table row during initialization. Thanks for your help.
Stepanov Andrey
  • 129
  • 2
  • 9
4
votes
1 answer

Select entire Handsontable column with icon click?

I want each column in my table to have an icon that when clicked, will select the entire column. I have this working for the first (not fixed) column with a button, but cannot get the for each icon working. Also, any idea why the last column (2018)…
triplethreat77
  • 1,276
  • 8
  • 34
  • 69
4
votes
3 answers

Get column number from column name

Is there any method to get the column number from the column name? I can only retrieve the column name, and I need the column number for getCellMeta. Thanks
Cornwell
  • 3,304
  • 7
  • 51
  • 84
3
votes
1 answer

highlight the row if a cell is edited in Rhandsontable and keep track of all changes

I'm developing a shiny app which is reading data from SQL database and present it in a rhandsontable and allows user to edit the data. I would like to add some functionality before I submit the changes back to the database : How could I highlight a…
Haribo
  • 2,071
  • 17
  • 37
3
votes
1 answer

Is console unnecessary Error Message slowing the webpage?

I am using Handsontable to show some table in my webpage and it is working fine, but over the time as the client left the page hanging the page will accumulate error such as (I can't upload pic but the message is something like this) 387…
Hendy Lim
  • 113
  • 4
3
votes
1 answer

Adding multiple rows in rhandsontable via context menu

I'm using the rhandsontablepackage and would like to add a context menu option for adding multiple rows to the handsontable produced. I've tried to adapt this example into my R equivalent with no luck. I believe my javascript is the issue but don't…
Michael Bird
  • 771
  • 8
  • 21
3
votes
1 answer

Vue.js crud javascript?

I need to load data to a hands-on table, When I use: case: if used directly into data, its work good, but I need to load data when is created from Axios, using Axios. This doesn't work. data: function() { return { info:[], hotSettings:…
Carlos
  • 572
  • 1
  • 5
  • 13
3
votes
1 answer

Date formating in handson table

I am using handson table lib in my angular project. have a date column and i want the dates to be formatted like that DD/MM/YYYY at the init of the table but unfortunately nothing is happened and even when i call afterRender() in angular's…
fbm fatma
  • 430
  • 6
  • 22
3
votes
1 answer

Handsontable update formula variable

I've got handontable: var dataObject = [ ['', '', '', '', '', '', 2017, 2017, 2017], ['Item ID', 'Item Name', '', 'Split', 'Weighed LRA', 'LRA', 3, 2, 1], ['556874', 'POMEGRANATE PEONY BB 1L', '', '=ROUND(CONCEPT_SUM*E3;0)',…
adriano26010
  • 57
  • 5
3
votes
1 answer

Primefaces extension sheet component on "Enter" press move the focus to the cell in the right

The default operation of the handsontable when press intro is focus the cell on the bottom, but in primefaces extension the focus go to the right, I need go to the bottom, is there some config that I can try? I tried to modify the afterChange event…
Migue Jara
  • 67
  • 1
  • 10
3
votes
2 answers

How to use checkbox to checkall or uncheck all boxes into handsontable

i want to use a checkbox to checkall or uncheck all boxes into available col. I create a checkbox with a function doalert to control the checked action. I was using setDataAtCell to edit check cell but it dosen't work. My code is…
user6223604
3
votes
1 answer

Handsontable not immediately shown when inside Vuetify Stepper

When placing the Handsontable HotTable component inside of a Vuetify Stepper the Handsontable is only visible after you click somewhere on the page. But if I place the HotTable component outside of the Stepper it would be shown immediately. It…
mono68
  • 2,080
  • 19
  • 27
3
votes
1 answer

To allow multi select in Rhandsontable column dropdown

I am trying to build a application in R shiny, where I am using a handsontable to take inputs from users. One column in my handsontable is having dropdowns where I need multiple selection from the user. For example in my below sample code, I want…
kawsleo
  • 560
  • 4
  • 23
1 2 3
…
74 75