Ask Your Question
0

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

asked 2019-04-29 21:17:24 +0100

JRvZ gravatar image

updated 2019-04-29 21:22:05 +0100

Ratslinger gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-04-29 21:26:37 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-29 21:17:24 +0100

Seen: 45 times

Last updated: Apr 29