Text in cells is duplicated using ilovepdf.com and Excel
Text in cells is duplicated using ilovepdf.com and Excel
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
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
Re: text in cells is duplicated many times
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.
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.
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.
Re: text in cells is duplicated many times
I am attaching sample document, exported from PDF
other files are more confident, I have to find something
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 361 times
OpenOffice 3.1 on Windows Vista
Re: text in cells is duplicated many times
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
Re: Text in cells is duplicated many times
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
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
Re: Text in cells is duplicated many times
Then please upload the Excel file here.My main file/database was made in Excel. Now I save it as open document.
'imported' or 'exported' 'from' or 'to' PDF file format?Plus the whole file exported from PDF
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.
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.
Re: Text in cells is duplicated many times
Your file was not attached. Please try againBeata wrote:Please find attached original file. ...
Is the forum provided by experts or are you volunteer?
I will add another file on Monday eventually
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
Re: Text in cells is duplicated many times
It is this one download/file.php?id=41457 of yesterdayRoryOF wrote:Your file was not attached. Please try again
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Text in cells is duplicated many times
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.
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
Re: Text in cells is duplicated many times
Each cell text seems to be repeated 19 times.
=LEFT(B4;LEN(B4)/19) fixes this for cell B4
=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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Text in cells is duplicated many times
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
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 289 times
OpenOffice 3.1 on Windows Vista
Re: Text in cells is duplicated many times
second file attached - more problems
OpenOffice 3.1 on Windows Vista
Re: Text in cells is duplicated many times
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
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 325 times
OpenOffice 3.1 on Windows Vista
Re: text in cells is duplicated many times
Exactly. There is a good summary on why PDF->text is hard: https://filingdb.com/b/pdf-text-extractionRoryOF wrote:PDF is intended to be a read-only format; the problem may lie in the export. Can you please upload the original PDF?
OpenOffice 4.1.7 on Ubuntu 20.04