I have read the documentation for per cell rules ( dhtmlx.com/docs/products/dht … xcell.html ) but it doesn’t seem to work with math types. In a column I need some cells to be “ro” and I need some cells to be “ron[=c4c5]". I’ve tried setting the column to “ro” then per cell setting a type of "ron[=c4c5]”, and I’ve tried the reverse. There also seems to be a math rounding issues, see the image I uploaded. Thank you!
I think I have found a solution for making the cells blank “ro”'s. I have the column defined as “ron[=c4*c5]” but then for the specific ones I want blank I’m now doing this…
myGrid.setCellExcellType(“100”,6,“ro”);
myGrid.cells(“100”,6).setValue("");
That seems to work. Is that the easiest way to accomplish what I need?
I’m still having math issues though.
myGrid.setCellExcellType(“100”,6,“ro”);
myGrid.cells(“100”,6).setValue("");
That seems to work. Is that the easiest way to accomplish what I need?
You’re right. This is the correct way.
There also seems to be a math rounding issues.
That issue was fixed in 3.5 version of dhtmlxgrid.
Please, open ticket at support.dhtmlx.com so we can provide you a fix.
I opened a ticket for the rounding issue that you said was fixed in version 3.5. You guys sent me the fix via e-mail. It worked great. Thanks! I received the e-mail three times now No need to keep sending it. I can’t close out the ticket cause my support has expired. So could you close Ticket ID: KPB-305036.
Thanks!
no problem.