Request Percentage input behavior

[Grantham Good]

It would be good to be able to enter 90 into a % formatted workview and the value be recorded as 90%, instead of 9000%, this would make a user think in % instead of having to create a decimal each time. Also would still want the smarts to be able to copy from excel and it recognise that is still as a decimal...

In addition, at the moment, If you go into a view with format % , try and enter a number manually with a decimal. This seems to be only possible if you click the mouse in the cell one by one, but with numbers you can type directly without that extra step - this makes % input very tedious.

 

[Ben Hill]

Hi Grantham,

This one will be in the next upgrade to the gateway portal. Data entered is interpreted based on the cell formatting and so % cells where the user enters 25 will result in 0.25 being stored. This behavior is now in alignment with MS Excel.

It will take a week after gateway (backend) goes live before the change is in the frontend.

Thanks,
Ben

 

[Grantham Good]

Hi Ben, I think we have a further issue, which is if you are using eg 25% format and copy and paste in Modlr, it pastes as 0.25 % to the target cell

 

[Ben Hill]

Hi Grantham,

We've solved this issue now.

Thanks,
Ben