I am using LO 22.214.171.124, 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.