I am using LO 6.2.3.2, and am having huge difficulties importing decimal data (format x,xx)

[JRvZ]

I am using LO 6.2.3.2, and am having huge difficulties importing decimal data (format x,xx) from a spreadsheet into a base table. No matter what I try it ends up divided by 100 in the table. What can I do to overcome this?

To illustrate if a value is say 423,00 in the spreadsheet it lands up as 4,23 in the table.

I have copied the data in the spreadsheet & pasted it into table. The first line in the spreadseet has coulumn headings corresponding to the data names in the table.

[Ratslinger]

Hello,

An educated guess that this is for a Firebird embedded database.

Please see answer in this post → Problem importing decimal data from CALC sheet to Firebird Base table

In future, please specify specific LO version & bitness, OS and database used as this can determine where problem lies.