Pasting data from spreadsheet into base table - rounds decimal amounts to nearest integer. Trying to convert an Access database to LibreOffice Base by pasting a file from LibreOffice Calc into a base table. Currency amounts defined in table as Decimal round to nearest integer.Tried with and without the currency sign but always lose the 2 decimal places.Pastes OK into a varchar but then I cannot use that as a currency amount. There must be a way to do this, but how?
Missing some more informations:
Which version of LibreOffice do you use? Copy Help → About LibreOffice → Version Information (press button and insert here).
Which database do you use? Base isn’t a database. Base uses internal databases like HSQLDB and Firebird and external databases like MariaDB, PostgreSQL …
Open the table of the database for editing, not for input data. Mark the row for the field, which should contain decimal values. Make a screenshot - should show how many decimal places will be defined.
Thanks for the quick response - problem solved. New to Libre Office Base and failed to spot the Field Properties box as it it dropped off the bottom of my screen. From previous experience with database systems (mostly Sybase and Oracle on Unix over 25 years ago) I knew there had to be more to editing the table - I must be getting old!