Vaadin Spreadsheet with components

Flow
1

Hi
I have a Vaadin application with spreadsheet in which a column has a combobox as a custom editor. Now i have a requirement that i have to display an item value and store its id in the spreadsheet. It looks like it is not possible to do that as the cell is taking the id value and displaying it. Is there a way to store the id internally in the spreadsheet cells so i can display the item value and store id in the cell.

Thank you.

2

Hi,

The spreadsheet doesn’t translate custom components automatically. You need to handle the combobox valueChange and give the cell your value manually. Also if you handle cellValueChange from the spreadsheet you will allow the user to paste values.