Text in cells is duplicated using ilovepdf.com and Excel

Talk about anything at all....
Post Reply
Beata
Posts: 6
Joined: Fri Jul 31, 2020 12:36 pm

Text in cells is duplicated using ilovepdf.com and Excel

Post by Beata »

For example there is text:
Euthyrox N 50
and next time I see text:
Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50Euthyrox N 50

I have database with many notes and informations, not numbers only, approximately 1000 lines and 15 columns. Plus othes sheets in the same file. I have noticed the problem for the beginning in single cells. I clear it, but there are new the next day or after a while.

Now I was exporting data from PDF and this is just a disaster - in the first 80% of 300 lines all notes are multiplied. No problem with numbers.

Is it a virus or did I something wrong?

I am using programme just for a week, previously I was using Excel
OpenOffice 3.1 on Windows Vista
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: text in cells is duplicated many times

Post by RusselB »

Welcome to the Forums.
The number of possibilities are almost endless, so in order to help you, please attach a sample of your document that shows the problem.
Please see How to attach a document for more information on attaching and anonymizing your document.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Beata
Posts: 6
Joined: Fri Jul 31, 2020 12:36 pm

Re: text in cells is duplicated many times

Post by Beata »

I am attaching sample document, exported from PDF
other files are more confident, I have to find something
Attachments
czarna lipiec.ods
second table is important, this is from PDF
(76.79 KiB) Downloaded 357 times
OpenOffice 3.1 on Windows Vista
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: text in cells is duplicated many times

Post by RoryOF »

PDF is intended to be a read-only format; the problem may lie in the export. Can you please upload the original PDF?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Beata
Posts: 6
Joined: Fri Jul 31, 2020 12:36 pm

Re: Text in cells is duplicated many times

Post by Beata »

Please find attached original file. I don’t think this is the reason. The problem started before.
My main file/database was made in Excel. Now I save it as open document.
I think I had this problem in Excel before but it was single episode from time to time. Now is is few cases daily. Plus the whole file exported from PDF
Thank you for help
Is the forum provided by experts or are you volunteer?

I will add another file on Monday eventually
OpenOffice 3.1 on Windows Vista
User avatar
Zizi64
Volunteer
Posts: 11345
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Text in cells is duplicated many times

Post by Zizi64 »

My main file/database was made in Excel. Now I save it as open document.
Then please upload the Excel file here.

Plus the whole file exported from PDF
'imported' or 'exported' 'from' or 'to' PDF file format?

Was it converted in this way?
.xls -> .pdf -> .ods ?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Text in cells is duplicated many times

Post by RoryOF »

Beata wrote:Please find attached original file. ...
Is the forum provided by experts or are you volunteer?

I will add another file on Monday eventually
Your file was not attached. Please try again

We are all volunteers on the Forum, each with different levels of expertise in our areas of interest.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Text in cells is duplicated many times

Post by Villeroy »

RoryOF wrote:Your file was not attached. Please try again
It is this one download/file.php?id=41457 of yesterday
I have never seen anything like this before.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Text in cells is duplicated many times

Post by RoryOF »

I was asking for the original file, from which the distorted files were derived.

I have seen similar repeated fields in a query(s) on Forum, but cannot recollect when, where or how they occurred.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Text in cells is duplicated many times

Post by Villeroy »

Each cell text seems to be repeated 19 times.
=LEFT(B4;LEN(B4)/19) fixes this for cell B4
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Beata
Posts: 6
Joined: Fri Jul 31, 2020 12:36 pm

Re: Text in cells is duplicated many times

Post by Beata »

I analysed my files again. The problem started, when I was using Excel, but it was just from time to time, I was clearing data every time I have noticed.
Now I can see, that sometimes there was the same problem in 2 cells in the same line (name/Product and descripion/Uwagi, which are usually with longest text), sometimes name or description only.

See attached file in Excel: Lista_2020_07_07
I wanted to send original document, but it is much to big, so I delated many coumns and some tables/shhets
line 148 Product Boostrix: name is OK, column Uwagi - many times
line 222 Product Dalacin C many times, column Uwagi - empty so there was nothing to duplicate
line 822 Product Targin: name many times, Column Uwagi - many times
and one more thing notiec right now - second table is duplicated today, it was for sure ok before:(

So this file was created in Excel and now I am using it in OpenOffice, now it is saved in .ods format

See my othe file in .ods, this is Lista_2020_07_16_2.0ds

look at line 387, product name HYLO-GEL ŻEL DO OCZU - 10 ML, this line was OK previously, it was line 371 in the file Lista_2020_07_09.xlss
now name is OK, but column Uwagi 2/description is multiplied

***
other file converted from PDF into Excel using page:
https://www.ilovepdf.com/pl/pdf-do-excel
Please attached original file in PDF
I I converted it form PDF to Excel on this page
than I have downloaded it to my computer (which don't have Excel) and opened it in OpenDocument

***
I don't know how to add 4 files, so I will add next file in a inute in next post. I I have to cut files, as they ar too big

And thank all of you
Attachments
Lista_2020_07_07_saved_as_ODS_shorted.ods
(121.91 KiB) Downloaded 283 times
OpenOffice 3.1 on Windows Vista
Beata
Posts: 6
Joined: Fri Jul 31, 2020 12:36 pm

Re: Text in cells is duplicated many times

Post by Beata »

second file attached - more problems
OpenOffice 3.1 on Windows Vista
Beata
Posts: 6
Joined: Fri Jul 31, 2020 12:36 pm

Re: Text in cells is duplicated many times

Post by Beata »

source of PDF file ;
http://dziennikmz.mz.gov.pl/compatible/Details/2020/55

the file if too big, I cannot attached it!!! So probably the previous time I didn't noticed that attachement was not attached

after converting form PDF into Excel attached now
Attachments
czarna lipiec.ods
(76.79 KiB) Downloaded 321 times
OpenOffice 3.1 on Windows Vista
DocKeeper
Posts: 3
Joined: Fri Nov 13, 2020 7:24 pm

Re: text in cells is duplicated many times

Post by DocKeeper »

RoryOF wrote:PDF is intended to be a read-only format; the problem may lie in the export. Can you please upload the original PDF?
Exactly. There is a good summary on why PDF->text is hard: https://filingdb.com/b/pdf-text-extraction
OpenOffice 4.1.7 on Ubuntu 20.04
Post Reply