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

HandsonTable - How to use the "IF" Formula from RuleJS

I am trying to replicate the below IF Formula from excel to handsontable but i am getting !value. =IF(B1=0,(B5*D4),C1*D2) jsfiddle link : http://jsfiddle.net/15ydb2h9/ Please help me with the syntax to use it in handsontable(if possible with the…
Sreeram Nair
  • 2,369
  • 12
  • 27
-1
votes
1 answer

Hansontable in Asp.Net , Repeat the table

I'm using Asp.net , 2957 https://pastebin.com/raw/Rf02nKuC Click on the Load button, two handsontable panels appear, including an empty table and a table containing data. How to display only 1 table with updated data. Pls!
-1
votes
1 answer

How to get current value of header cell? (incl. nested headers)

I have a handsontable, where some of the headers are checkboxes, and some of them are select boxes. How do you access the header to check the value of a select/checkbox inside the header cell? JSFiddle (with nested headers - same as my project):…
LucasSeveryn
  • 5,984
  • 8
  • 38
  • 65
-1
votes
1 answer

Handsontable Header Search, Input Text, is Cleared Intermittently on Scroll

I'm having issue with maintaining search terms in text input fields that I have added to the HoT headers. If I enter a search term and scroll down this term often gets cleared. I think this may relate to HoT header freeze behaviour upon…
Jewell
  • 21
  • 5
-1
votes
1 answer

How can I get the checkbox control inside the cell of the handsontable

I use a handsontable with a checkbox column, how could I get the checkbox control from the api ?
-1
votes
1 answer

Disable Cell Editing or Make Cell Readonly

When the user types a value in a cell of a certain column, I would like to make the cell of the next column(same row), readonly ou not editable. If the user deletes de value, I would like to make the next cell editable again. Can someone give an…
-1
votes
1 answer

Handsontable Sequence word creation

Thanks for this wonderful plugin. I am using this plugin for grid functionality. For this I am trying to use sequence word creation on drag down. I have implemented upto my knowledge. But I am facing one problem while select and drag multiple…
-1
votes
1 answer

Checkbox custom render for handsontable not working

I have applied a custom renderer for check boxes in the handsontable.My handsontable has only checkboxes in all of its row and column. The read only property will be applied for the rows specified in the settings of the handsontable, but when I…
Nikhil Bharadwaj
  • 867
  • 4
  • 24
  • 42
-1
votes
1 answer

Got duplicate table when export handsontable to XLS

I was to export a handsontable to XLS file but i encountered this bug: The result excel file contains 2 table like this: First name Last name Email Phone Password 23123 31231231 213@dsfsd213.563 NjU0NTY0 46565465546 Buu …
-1
votes
1 answer

How to add CSS Style to Handsontable cell header?

I want to add some style classes to a handsontable cell header (colHeaders). I am using a custom renderer to do this on the table cells however i can't find out how to do this to the cell header. I have tried to use JQuery to add a class to the…
Tim
  • 111
  • 2
  • 5
-1
votes
1 answer

the fastest way to select all checkbox

columns: [ { data: 'ch', type: 'checkbox', checkedTemplate: 'yes', uncheckedTemplate: 'no' }] If you want to make checkbox like this.. you might thought select…
Juno Im
  • 77
  • 1
  • 8
-1
votes
1 answer

Not able to use RuleJS (formula support) with handsontable + angularJs

I am not able to use RuleJS (formula support) with setup handsontable + angularjs. In angular data is loaded but only formula support functionality is not working at all.Same thing is working without angular ( in jquery). I am not able to use RuleJS…
-1
votes
2 answers

How to add new row in handsontable angularjs?

I am using handsonetable with angularjs and I want to add a new row by clicking an add button. Is it possible to create dynamic rows in Handsontable grid? and how to do it?
-1
votes
1 answer

How to load data in Handsontable using Ajax JQuery?

i am using the below code to load data from ASP.Net using Jquery and AJAX. But when it loads the Handsontable loads only one cell with array data. I have tried different ways with no luck. Please help me to load data from the server. function…
SSK
  • 783
  • 3
  • 18
  • 42
-1
votes
1 answer

How can i read Handsontable array in ASP.Net?

I have an handsontable and i am trying to read the array data in ASP.Net. i have the below code. When i send the data to server. i keep getting ParseError. I tried different ways but did not help. var data = [ ["Year", "Kia", "Nissan",…
SSK
  • 783
  • 3
  • 18
  • 42
1 2 3
74
75