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
5
votes
3 answers

Handsontable, colWidths: function: how to set a column width fitting content?

My aim is to set the first column's width equal to a certain number and leave other columns' widths untouched. Now I know that setting colWidths: [myValue] actually breaks other columns' widths but this seems to be workaroundable using colWidths:…
YakovL
  • 7,557
  • 12
  • 62
  • 102
5
votes
0 answers

HandsonTable - div class "WtHolder" Automatic Height Calculation Incorrect

I am trying to have HandsonTable automatically adjust its width and height to the size of the div container it is associated to, in this case lets call it "test". I have followed the HandsonTable guide (see link below) on achieving this and it says…
Josh
  • 808
  • 1
  • 16
  • 35
5
votes
1 answer

Moving away from Excel Workbook/VBA - Technology Upgrade

This is going to be more of a opinion question because I can't find any answer on Google or any SME's within my company that really have a opinion on this. I wasn't sure if a opinion question is appropriate, so if its not please feel free to delete…
Tempster102
  • 183
  • 3
  • 10
5
votes
3 answers

handsontable / javascript - Disable new rows being added by dragging

I have a handsontable table which is dynamic, meaning data can be added after initiation. The problem is, however, that new rows can be added to the table when dragging down while clicking the corner of a cell. How would I prevent users from…
Dubb
  • 423
  • 1
  • 7
  • 21
5
votes
2 answers

Handsontable with datetimepicker

Is there a plugin to implement datetimepicker in handsontable? The closest I got was pickadate fork here but I have no clue how to implement this in Handsontable.
VariSingh
  • 59
  • 1
  • 6
5
votes
1 answer

Handsontable: jquery merge headers, bug at horizontal scroll

im currently working with handsontable and python+django, i put a custom merged header with Javascript. And this should look like this. But when i load the page. BUT, when i scroll back and foward the error disappear magically. This is the…
FranciscoV
  • 61
  • 8
5
votes
1 answer

Dynamic column width with handsontable

I'm using handsontable and my grids are dynamics. I'm creating them by pushing the data from a XML file. So, the content of the columns are always differents and I want that the width of that columns are defined with the content of the existing…
Erlaunis
  • 1,433
  • 6
  • 32
  • 50
5
votes
3 answers

Dynamically resizing a container containing a Handsontable

This is the HTML I got:

Vorschau - Notiz1.txt

Notiz1.txt

Lorem ipsum dolor sit amet, consetetur sadipscing…

Tywele
  • 485
  • 1
  • 7
  • 21
5
votes
3 answers

Access handsontable methods/properties using nghandsontable

I'm using ngHandsontable Angular directive for Handsontable. I managed to show the data successfully, but I'm struggling with getting access to the modified rows so I can send the data to the DB. I tried binding the afterChange callback, but the…
Marco
  • 91
  • 1
  • 7
5
votes
3 answers

How to change header background color and font color in Handsontable

Questions: I'm able to change background color of cells but not of the header. Can I change the background color as well as font color of the header in Handsontable?
Samuel Segal
  • 423
  • 1
  • 7
  • 18
5
votes
3 answers

Format NumeralJS percentages without multiplying by 100

In Handsontable, you can use the format option on a numeric cell to format the values accordingly. Since it uses NumeralJS, I looked through the documentation to see how to format a number to just add the % sign and not multiply by 100 but can't…
ZekeDroid
  • 7,089
  • 5
  • 33
  • 59
5
votes
2 answers

handsontable how to set cell to invalid manually

I have some handsontable which I use to update information into the db. The first step is: I validate the data, then if an error occurred I fill the row with red color else I just save the information Here come the problem: I call ajax request hard…
user3301396
  • 73
  • 1
  • 6
5
votes
1 answer

How to create dynamic columns for Handsontable?

I'm working with Handsontable to create a web grid that can copy / paste between web and excel, I tried with code below and it works fine: var first = true; var exampleGrid = $("#exampleGrid"); exampleGrid.handsontable({ rowHeaders:…
xinfli
  • 211
  • 1
  • 2
  • 6
4
votes
1 answer

R rhandsontable renderer does not follow column sorting despite being reactive

I am working in a shiny app that displays a rhandsontable. I use a "renderer" to customize cell color and border. In addition, I would like to allow the user to perform column sorting. Here is my problem: when columns are sorted, the borders and the…
mazu
  • 147
  • 6
4
votes
0 answers

How do I make Handsontable available to my Laravel Blade component?

I'm making a table editor in Laravel using a Blade component. I want to use Handsontable so I've installed it via NPM and added the import statements to app.js and then run Laravel Mix to build the output. How do I then access this from the script…
Leonard H. Martin
  • 2,734
  • 4
  • 23
  • 26
1 2 3
…
74 75