Re: Set up Constraint in Xlsx
Rob Sargent <[email protected]>
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Message-ID | <[email protected]> |
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.3333333333. You're going to make the user trim that manually to 0.333. That would not make me happy. On 5/21/20 7:30 AM, 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. I would like to set up constraints on required field, to allow only good values. > Has anybody have any ide it this can be done? > > Have a Nice day > marcin Wyrwalski > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >