Re: Set up Constraint in Xlsx

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 needs to be forced into
DECIMAL(?,?). And this can be a real nightmare, because most of the End
Users just copy/paste the content from other data sources into the
Spreadsheet without thinking about it.

Also, certain data, like currency amounts or interest rates permit only
a fixed number of digits.

Spreadsheets actually do lack a BigDecimal data type.

Cheers