Posted 8 September 2017, 1:25 pm EST
I am using percent cell type to few of my columns in the spread. I have set the max size 100.00 and min to 0.00. The problem is like I can enter no: 2345 and the cell accepts that no: without any problem ( the reason is like it is getting stored as 23.45)
I think it is getting multiplied by 100. Is there a way by which I can restrict this multiplication.