HandsOnTable User Formatting Options

Getting help Questions
1

I’ve done some searching but can’t seem to find an answer to my question.

Is there a way to allow the user to format each cell within a HoT? Examples being bold, italic, change cell background, etc. Similar to Excel.

2

Hi @jeremy

yes, you can add styling to a cell in Handsontable.

The easiest way would be to use cells method. Here’s an example http://jsfiddle.net/nc8yd3u8/

3

I apologize I wasn’t as clear as I should be. I meant the end user of the application not me as the programmer.

4

Oh, sure. There are a couple of things a user can do. The first one is a context menu.

Here http://jsfiddle.net/gmcLfbzb/ I have an example that changes all the cells (use RMB on the table) but if you need a demo for a selected area or a single cell I can help.

The second one is a dropdown menu. Here’s an example of making a column red (background) via dropdown menu http://jsfiddle.net/x91r6v0d/1/ (column option).

And you can also use good old buttons. This time by setCellMeta method http://jsfiddle.net/9y0w2xzw/

5

Thanks for the information! I’ll give those a look.

6

You’re welcome.

Let me know if you’d need anything else.