I have a bank statement in pdf, simple outlay, date, payee, amount balance etc.
I use adoble dc cloud to read the pdf and convert to excell. On the screen the excell looks fine, but once downloaded to my drive and read in with openoffice each cell has multiple copies of the data in the payee field,
Why are you using OpenOffice Calc to read an PDF that was converted to MS Excel format .xls?
Do you get the same results if you open the same file with Micrososft Excel rather than OpenOffice Calc?
In any case, you need to verify if OpenOffice Calc is defaulting to the .ods spreadsheet format instead of .xls for MS Excel when you try to view it.
Go to "Tools" --->>>"Options", and scroll down to the section "Load/Save".
There are three subsections of interest:
In "General", see the dropdown menu to the the right labeled: "Document type" --->>> select "Spreadsheet" and to the right of this dropdown, another dropdown menu labeled "Always save as"; select "OpenOffice.org XML 1.0 Spreadsheet".
Then click on "VBA Properties" and see to the right "Microsoft Excel 97/2000/XP"; tick the checkboxes below:
Load Basic code
Save original Basic code
Next, click on "Microsoft Office" and make sure to tick both of the checkoxes provided to the right under the columns "[L]" (for load and convert the object) and "[S]" (for convert and save the object) respectively:
"Excel to OpenOffice Calc or reverse".
Click OK to save these preferences and exit the "Options" dialogue window.
Try and see if you see the same garbage this time.