Request Percentage input behavior

Joined
Feb 27, 2020
Messages
43
Likes
23
Points
8
#1
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

Administrator
Staff member
Administrator
Joined
Mar 19, 2018
Messages
33
Likes
29
Points
18
#2
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
 
Joined
Feb 27, 2020
Messages
43
Likes
23
Points
8
#3
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

Administrator
Staff member
Administrator
Joined
Mar 19, 2018
Messages
33
Likes
29
Points
18
#4
Hi Grantham,

We've solved this issue now.

Thanks,
Ben