Ask Your Question

column has been defined as a "Decimal" type, the max. length is 19 characters (with 15 decimal places). [closed]

asked 2017-07-19 10:52:07 +0200

bigbw gravatar image

updated 2020-08-07 14:30:23 +0200

Alex Kemp gravatar image

Can I change the formatted character length of a column in a .dbf file in Libre Calc? I am editing shapefiles for input into a spatial database. Thanks for your suggestions.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-07 14:30:34.919632

1 Answer

Sort by » oldest newest most voted

answered 2017-07-19 12:03:17 +0200

erAck gravatar image

That's a limitation of fixed width numeric fields in the dBaseIII file format, the overall length can't be longer than 19 characters, including the decimal separator and a minus sign. Also note that a "precision" of more than 14 decimal digits (not decimals) doesn't make much sense as floating point precision is limited.

To change the length of a field of a loaded .dbf file you can change the column header, e.g. to FIELDNAME,N,19,12 to have more room for digits before the decimal separator, but you'll also have to change the number format(s) applied to the column's data, because during export the maximum of characters (-integer.fraction) encountered is taken for the field length and decimals. Best to reset to the General format.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-07-19 10:52:07 +0200

Seen: 1,802 times

Last updated: Jul 19 '17