Per Cell Math Types

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 :slight_smile: 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!

:slight_smile: no problem.