Re: Set up Constraint in Xlsx

Marcin,

On Thu, 2020-05-21 at 13:30 +0000, Marcin Wyrwalski wrote:
> Hello.
> 
>  I would like to ask, if there is a possibility to set up constraint to not allow user to write more than three decimall places in cell? I preparing and sending file to user, and user is supposed to return file with some data.

The closest thing I found look like that: 
https://exceljet.net/formula/data-validation-number-multiple-100
(Validity defined by a formula.)

You will likely compare ROUND(x, 2) vs ROUND(x/100) and test for Zero
or something like that.
Cheers
Andreas