Page 1 of 1

SetCellHtml

PostPosted: 14 Mar 2017 19:04
by TheoLang
Hi,

i want to use the spreadsheet to visualize data.

I can use "SetCellValue" to set values. But i also want to have colors and other formattings.
I tried to use "SetCellHtml" but that doesn't work.

Or may be it is better to write the complete sheet in json format and import it ?

Best Regards
Theo

Re: SetCellHtml

PostPosted: 15 Mar 2017 12:21
by Alexander Bulei
Hi TheoLang,

But i also want to have colors and other formattings.


You need to use the ToggleCellStyle procedure, to set your custom css class, and then, create the css rule for that class.

But, I have detected some issues with generation of js code on that procedure.
I'll fix it for next beta build.

Thanks.

Best Regards.