Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 06 Mar 2019 12:06:03 +0100Problem importing decimal data from CALC sheet to Firebird Base tablehttps://ask.libreoffice.org/en/question/185691/problem-importing-decimal-data-from-calc-sheet-to-firebird-base-table/I have been able to setup a LO v6.2 embedded Firebird database with a single table having an ID primary key plus a couple of other DECIMAL(X,2) columns for currency data. I used an SQL statement run under the Tools>SQL menu to do that job.
The input data-source is a CALC sheet with columns formatted as NUMERIC XXXX.XX type destined for the DECIMAL columns in BASE. My import steps are:
1. Select all the CALC file populated cells
2. Click-select the BASE/FB table in the table list as the destination for the import.
3. Do the paste.
RESULT: All the data are imported properly except for the two DECIMAL columns in which the numerical data now displays with the decimal point shifted two spaces to the left - i.e. a CALC cell has 12.65 and the BASE/FB table corresponding value appears as .12 (without the least-significant digits). Is there anything I can do to correct this problem?
However, I suspect this might be a problem with the FB importing mechanism because doing the same procedure into a SPLIT HSQLDB Base setup works perfectly.
Also, I wonder is this related to the problem as described in the 'Firebird Migration: Number [ NUMERIC ] Field Data Corruption' post [HERE](https://ask.libreoffice.org/en/question/169284/firebird-migration-number-numeric-field-data-corruption/)?frofaWed, 06 Mar 2019 12:06:03 +0100https://ask.libreoffice.org/en/question/185691/