1,106 questions
0
votes
0
answers
47
views
Handsontable - Get selected cells after clicking ok button not working
I have configured the afterSelection hook in React HotTable to retrieve the selected area. However, this interferes with the merging of cells, causing it to not work properly. Is there an alternative ...
- 3
0
votes
1
answer
105
views
Pasting rows copied from excel into handsontable
Think of an excel with 15 rows, in this excel when I select and copy rows 2, 4, 7, 9, 11 and 12, it copies all rows between rows 2 and 12. When I paste it to Handsontable, it pastes it in the same way....
0
votes
1
answer
162
views
'HotTable' component not rendering while passing "non-commercial-and-evaluation" as license key
I'm using Handsontable for my first time with React18 (Vite6), and the fisrt thing I recreated was the example they provided in their installation docs.
I've noticed this example has the line ...
- 31
0
votes
0
answers
99
views
Problem Editing a HandsOnTable component on Angular
I'm having an issue with HandsOnTable in Angular where numeric cell values are not being displayed after editing, although the validation and edit events are triggering correctly. I recently migrated ...
- 11
1
vote
1
answer
97
views
handsontable unfreeze a column and return to original position
I'm trying to create a handsontable table where when I freeze the column it goes to the 0th column position, but when you right click to unfreeze I'd like it to go back to its original location.
I've ...
- 81
0
votes
1
answer
315
views
How add a column in table handsontable
I’m getting an error message when trying to add a new column to the end of my handsontable table
Error: Cannot create new column. When data source in an object, you can only have as much columns as ...
1
vote
1
answer
91
views
PFE Sheet how to prevent resize with frozen columns in PF7
I have been working with primefaces, and the sheet component meet most of the requirements that I need to accomplish my work, did some research and added contextual menu and other functions, but my ...
0
votes
1
answer
67
views
Error HotTable renders extra empty column at beginning of table
HotTable puts an empty column at the beginning of the spreadsheet when calling the spreadsheet in vue3.
Above is the code I'm currently using in Vue3. Handsontable / HotTable loads a file that is in ...
0
votes
1
answer
66
views
How to summarize formulated cells in handsontable
I have here a handsontable and I'm trying to summarize the last column but the formulated cells are not added in the summary.
https://jsfiddle.net/q3b1zjcL/1/
var sourceDataObject = [
[1, 2, "=...
- 357
0
votes
1
answer
141
views
Set source property of Handsontable dropdown option to the corresponding data value
I have a data array taken from ajax call as
data=[ // all are dynamic values can vary
['Alex', '16', ['2024-01-01,50000', '2024-03-01,20000', '2024-05-01,30000']],
['Bob', '21', ['...
0
votes
0
answers
79
views
How to insert 'dropdownMenu' in 'rhandsontable'?
The JavaScript library Handsontable has the 'dropdownMenu' option, which allows displaying an icon in the column headers and opening a dropdown menu with various options.
I know this can be achieved ...
- 1
0
votes
1
answer
47
views
How to Validate and Clean Cell Range in Shiny App Before Passing to JavaScript?
I am currently working on a Shiny app where I want to have an input to select parts of an Rhandsontable. My goal is to do the validation and the cleaning of the cell range within the Shiny app and ...
- 2,663
0
votes
1
answer
89
views
How to Select a Cell Range in rhandsontable Using Text Input in a Shiny App?
I am currently working on a Shiny app in R that incorporates an rhandsontable element. I would like to add a feature where a user can specify a cell range (e.g., "A1:B2") in a text input ...
- 2,663
2
votes
1
answer
356
views
Sticky Column and Row Names in Rhandsontable
I am currently developing a Shiny application and utilizing the rhandsontable package to display a table. Here is the code snippet I am working with:
library(shiny)
library(rhandsontable)
ui <- ...
- 2,663
0
votes
1
answer
121
views
Preventing Column Looping in (R)handsontable
I'm currently working with Rhandsontable and I'm facing an issue with user cell selection. When a user selects a cell from the last column (say column C) and then presses the right keyboard arrow, the ...
- 2,663
