Marcin,
On Thu, 2020-05-21 at 13:30 +, 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
Rob,
On Thu, 2020-05-21 at 19:39 -0600, Rob Sargent wrote:
> I guess I don't understand what is not "good" about extra digits after
>
> the decimal point?
Very simple, but frequent use case: Loading data from a Spreadsheet
file into a database.
In this case, the read value is a FLOAT which need
I guess I don't understand what is not "good" about extra digits after
the decimal point? You can round to whatever precision you choose.
What if the user is using some tool to generate and insert the data and
it divides 1 by 3 and gets 0.33. You're going to make the user
trim that ma
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. I
would like to set up constraints on required field, to allo
Hi Andreas,
thanks for the pointers, currently we are doing the file as XSSF and willl load
test in our UAT environment.
If it does kill the memoty over ther I will try to go with the appoach as you
described.
Thanks you verry much for the help
On 2020/05/19 06:39:47, Andreas Reichel wrote: