You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by "Thomas, John" <Jo...@daytonohio.gov> on 2014/07/02 19:39:12 UTC
open pdf documents and save them as spreadsheets or word documents
Can open office translate .pdf files to spreadsheets or word documents?
Sincerely,
John Thomas
John A. Thomas
Application Analyst
City of Dayton
Central Services / Information Technology
130 W. Second Street, Suite 320
Dayton, OH 45402
Phone: 937.333.6321
FAX: 937.333.7835
Email: John.Thomas@daytonohio.gov
Re: open pdf documents and save them as spreadsheets or word documents
Posted by Tom Backer Johnsen <ba...@psych.uib.no>.
Tim
I have to admit that my experience is evidently limited, I only have experience with the text type of pdf file. I was not aware of the “image” type of pdf file. Thank you for that information!
Tom
On 6. Jul 2014, at 07:04 , Tim Deaton <ti...@timdeaton.org> wrote:
> Much depends on the type of pdf file.
>
> If the pdf file is an image (what you normally get when you scan a document into the computer), then a program with OCR capabilities is needed to try to recognize the text in the image and either add that text to the pdf document or save that text into a document that text editors, word processors, or spreadsheets can use. (I use Nuance Power PDF on Windows - a commercial product - for that, and know of other commercial alternatives. Other people here may know of open source alternatives.)
>
> If the pdf file is NOT just a scanned document, then it probably actually contains the text (not just a photo) in the file. In that case, you can highlight the text you want to copy and do a copy-and-paste into Writer. As Rory wrote, spreadsheet use may need much more care. Special-purpose programs like Acrobat, Nuance, Foxit, etc. can make such tasks easier -- but they still need careful proof-reading.
>
> -- Tim
> ===========================
>
>
> On 7/3/2014 3:05 AM, Tom Backer Johnsen wrote:
>> John
>>
>> The solution is much simpler, at least on a Mac. Simply mark, copy, and paste to wherever you want the text to be. However, you loose formatting. As to spreadsheets, copy the table to a temporary file, replace whatever separates the cell contents with a comma or semicolon, and read the temporary file as a .CSV file.
>> On 2. Jul 2014, at 22:21 , Baccara <bb...@tstonramp.com> wrote:
>>
>>> Rory O'Farrell wrote:
>>>> On Wed, 2 Jul 2014 13:39:12 -0400
>>>> "Thomas, John" <Jo...@daytonohio.gov> wrote:
>>>>
>>>>
>>>>> Can open office translate .pdf files to spreadsheets or word documents?
>>>>>
>>>>>
>>>>> Sincerely,
>>>>>
>>>>>
>>>>> John Thomas
>>>>>
>>>>>
>>>> No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
>>>>
>>>>
>>> OCR - does that equate to Adobe creates an image (jpg or ?) from any document "printed to / saved as" a pdf document?
>>> PDF document can be opened with a pdf reader (free from Adobe and other sources), content highlighted, copied then pasted to another program such as OO Writer; MS Word then saved in the new format?
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
Tom Backer Johnsen
Søndre Steinkjellersmauet 7
5003 Bergen
Mobil: +47 9169 3346
Email: backer(at)psych.uib.no
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: open pdf documents and save them as spreadsheets or word documents
Posted by Tim Deaton <ti...@timdeaton.org>.
Much depends on the type of pdf file.
If the pdf file is an image (what you normally get when you scan a
document into the computer), then a program with OCR capabilities is
needed to try to recognize the text in the image and either add that
text to the pdf document or save that text into a document that text
editors, word processors, or spreadsheets can use. (I use Nuance Power
PDF on Windows - a commercial product - for that, and know of other
commercial alternatives. Other people here may know of open source
alternatives.)
If the pdf file is NOT just a scanned document, then it probably
actually contains the text (not just a photo) in the file. In that
case, you can highlight the text you want to copy and do a
copy-and-paste into Writer. As Rory wrote, spreadsheet use may need
much more care. Special-purpose programs like Acrobat, Nuance, Foxit,
etc. can make such tasks easier -- but they still need careful
proof-reading.
-- Tim
===========================
On 7/3/2014 3:05 AM, Tom Backer Johnsen wrote:
> John
>
> The solution is much simpler, at least on a Mac. Simply mark, copy, and paste to wherever you want the text to be. However, you loose formatting. As to spreadsheets, copy the table to a temporary file, replace whatever separates the cell contents with a comma or semicolon, and read the temporary file as a .CSV file.
>
> On 2. Jul 2014, at 22:21 , Baccara <bb...@tstonramp.com> wrote:
>
>> Rory O'Farrell wrote:
>>> On Wed, 2 Jul 2014 13:39:12 -0400
>>> "Thomas, John" <Jo...@daytonohio.gov> wrote:
>>>
>>>
>>>> Can open office translate .pdf files to spreadsheets or word documents?
>>>>
>>>>
>>>> Sincerely,
>>>>
>>>>
>>>> John Thomas
>>>>
>>>>
>>> No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
>>>
>>>
>> OCR - does that equate to Adobe creates an image (jpg or ?) from any document "printed to / saved as" a pdf document?
>> PDF document can be opened with a pdf reader (free from Adobe and other sources), content highlighted, copied then pasted to another program such as OO Writer; MS Word then saved in the new format?
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: open pdf documents and save them as spreadsheets or word documents
Posted by Tom Backer Johnsen <ba...@psych.uib.no>.
John
The solution is much simpler, at least on a Mac. Simply mark, copy, and paste to wherever you want the text to be. However, you loose formatting. As to spreadsheets, copy the table to a temporary file, replace whatever separates the cell contents with a comma or semicolon, and read the temporary file as a .CSV file.
On 2. Jul 2014, at 22:21 , Baccara <bb...@tstonramp.com> wrote:
> Rory O'Farrell wrote:
>> On Wed, 2 Jul 2014 13:39:12 -0400
>> "Thomas, John" <Jo...@daytonohio.gov> wrote:
>>
>>
>>> Can open office translate .pdf files to spreadsheets or word documents?
>>>
>>>
>>> Sincerely,
>>>
>>>
>>> John Thomas
>>>
>>>
>>
>> No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
>>
>>
> OCR - does that equate to Adobe creates an image (jpg or ?) from any document "printed to / saved as" a pdf document?
> PDF document can be opened with a pdf reader (free from Adobe and other sources), content highlighted, copied then pasted to another program such as OO Writer; MS Word then saved in the new format?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: open pdf documents and save them as spreadsheets or word documents
Posted by Baccara <bb...@tstonramp.com>.
Rory O'Farrell wrote:
> On Wed, 2 Jul 2014 13:39:12 -0400
> "Thomas, John" <Jo...@daytonohio.gov> wrote:
>
>
>> Can open office translate .pdf files to spreadsheets or word documents?
>>
>>
>>
>> Sincerely,
>>
>>
>>
>> John Thomas
>>
>>
>
> No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
>
>
OCR - does that equate to Adobe creates an image (jpg or ?) from any
document "printed to / saved as" a pdf document?
PDF document can be opened with a pdf reader (free from Adobe and other
sources), content highlighted, copied then pasted to another program
such as OO Writer; MS Word then saved in the new format?
Re: open pdf documents and save them as spreadsheets or word
documents
Posted by Rory O'Farrell <of...@iol.ie>.
On Wed, 2 Jul 2014 13:39:12 -0400
"Thomas, John" <Jo...@daytonohio.gov> wrote:
> Can open office translate .pdf files to spreadsheets or word documents?
>
>
>
> Sincerely,
>
>
>
> John Thomas
>
No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
--
Rory O'Farrell <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org