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
0 answers

How to change the value of cells in ipysheet without making new cells?

I'm running a Jupyter notebook that, among other things, displays a simple string-to-string dictionary (with a single empty row at the bottom so the user can add new entries to the dictionary). I'm using ipysheet to do this, and I noticed that as…
wanderso
  • 1,785
  • 3
  • 13
  • 21
4
votes
2 answers

Change cell background of rHandsontable with afterChange event on client side

I'd like to change the background color of a handsontable cell after it's been edited by the user on the client side. The handsontable is defined through a Shiny application; so this is really a question about how to define event hooks in…
Soren
  • 1,792
  • 1
  • 13
  • 16
4
votes
2 answers

Can not register custom renderer for Handsontable in angular 5,No registered renderer found under

I prepared a custom renderer for Handsontable in angular 5 but i can not find a way to register the renderer.I can not find any function like 'registerRenderer'.Renderer function is specified below coverRenderer (instance, td, row, col, prop, value,…
user3692033
  • 585
  • 3
  • 8
  • 21
4
votes
4 answers

Refresh Handsontable Angular 4

I am using n2-handsontable with angular 4 for a project. I can't seem figure out how to refresh the table when the data has changed. I found this post: Refresh a handsontable It seems to be what I want but I can't figure out how to access the…
Calidus
  • 1,374
  • 2
  • 14
  • 31
4
votes
4 answers

Handsontable: how to get instance by container?

I need to create a function that does some data updates and re-rendering to a rendered instance of handsontalbe (var ht = new Handsontable(el,options)). What I can easily get in my case is el (the element which is used as a container of the…
YakovL
  • 7,557
  • 12
  • 62
  • 102
4
votes
2 answers

Handsontable in VueJS, table loads only on page reload

I am using Handsontable with vanilla javascript inside a VueJS single page application. Using the following listener: document.addEventListener('DOMContentLoaded', function() ... the table only appears on a page refresh, not initial load. I also…
Don Smythe
  • 9,234
  • 14
  • 62
  • 105
4
votes
2 answers

Trigger the digest cycle in callback events

I want to create a corresponding textarea along with a handstontable, such that modifying the table has impact to the text, and vice-versa. Here is a JSBin.
user6330767
4
votes
0 answers

Summernote Rich text Editor with handsontable

I am trying to implement the summernote rich text editor in handsontable. The requirement is like when user press enter/F2/double click on a cell then the Rich text editor should open and cursor should move to editor having cell text in the…
user3346075
  • 41
  • 3
4
votes
1 answer

Use a specific format to display numbers with Handsontable

I need to force Handsontable to display numbers with a specific format (1.000,01 for example) but it seems to ignore what I try to use as thousands separator. I tried several ways to do that but none worked : Setting a format to cells that will…
Guillaume Billon
  • 41
  • 2
  • 5
4
votes
0 answers

Calculation for a cell with values from a cell from another table

I am trying to recreate a excel like feel using HandsOnTable and RuleJS. I am able to put in formulas where the calculations use cell values from the same table but cannot find a way to compute with cells from different tables. In my example(see…
satya on rails
  • 392
  • 2
  • 13
4
votes
3 answers

Change the class name of a cell in handsontable

I want to change the class name of a "td" in a handsontable. So I use jquery to do that with "addClass". In my css file, I have a specified color with this class name. My css : .error { background-color : red; color : blue; } And my…
Erlaunis
  • 1,433
  • 6
  • 32
  • 50
4
votes
2 answers

HandsOnTable - updateSettings with updated mergeCells option is not working

I have a HandsOnTable with mergeCells option, on particular event I make a server call which gives me updated data and hence merge cells options also need to be updated. For e.g. before server call, grouping was for every 5 rows, but after it's for…
Sohan Soni
  • 1,207
  • 21
  • 35
4
votes
2 answers

HandsOnTable - destroy and re-create not working after upgrading from 0.11.0 to 0.15.0-beta 2

I have code like below: HTML
Javascript: var rangePriceGrid = $('#rangePricesGrid').handsontable('getInstance'); if…
Sohan Soni
  • 1,207
  • 21
  • 35
4
votes
1 answer

How to disable write in a Cell Handsontable and include one dropdown

I made a fiddle with this example. Example with fiddle. In the 4th colum there are some cells that I want to disable the write mode and activate the dropdown. Actually I have the dropdown and works well for me but I can keep writing in it and I want…
Arnau Guadall
  • 327
  • 1
  • 4
  • 17
4
votes
1 answer

Set a max-width and max-height for table cells

Is it possible to set a max-width and max-height for cells in Handsontable? I've tried to set this via CSS on the and elements but this doesn't work. I saw in the docs that you can set the columns to particular widths, but not maximums.
Don P
  • 60,113
  • 114
  • 300
  • 432
1 2 3
…
74 75