how to convert text (odt) document to calc?

Hello

Yes, that's rather tricky.. You can do it with File > Open, but using the Insert > Sheet > From file

but you've to find the file type in the File Type drop-down list

Regards

Hello,
Thank u!
I tried, but nothing happens :(((( If it "somehow" works, Do U know how do I control which part of the text will be in column A, B etc.?
Best regards!

Hello

File > open > file type .odt will import the document correctly into calc It works fine with me!

Regards

nnarta,

I am checking to see if the information provided previously resolved your question. If so, please mark this question Solved.

Thanks!

Harvey

Thank u, but it still doesn't work at all. The Odt file just opens separately.
:((((
Best Regards!

 >-------- Оригинално писмо --------
 >От: Bhavani Shankar
 >Относно: Re: [Question #39389]: how to convert text (odt) document to calc?
 >До: <email address hidden>
 >Изпратено на: Четвъртък, 2008, Юли 17 09:17:20 EEST

 >Your question #39389 on openoffice.org in ubuntu changed:
 >https://answers.edge.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 > Status: Open => Answered
 >
 >Bhavani Shankar proposed the following answer:
 >Hello
 >
 >File > open > file type .odt will import the document correctly into
 >calc It works fine with me!
 >
 >Regards
 >
 >--
 >If this answers your question, please go to the following page to let us
 >know that it is solved:
 >https://answers.edge.launchpad.net/ubuntu/+source/openoffice.org/+question/39389/+confirm?answer_id=2
 >
 >If you still need help, you can reply to this email or go to the
 >following page to enter your feedback:
 >https://answers.edge.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 >You received this question notification because you are a direct
 >subscriber of the question.
 >

nnarta,

You can also try copying the text from the openoffice write document, and then pasting it into a new openoffice calc worksheet.

Please return to Launchpad and mark this question Solved, if this resolves your question.

Thanks!

Harvey

Hello,
copy-paste is ok, but it will take me nearly a month to replace
 the whole info. I know that there is a quick way to do it and to control the content of each
 column, by using sth like find/replace function.

Anyway, thanks to all of you!
Regards,
Marta

 >-------- Оригинално писмо --------
 >От: Harvey Muller
 >Относно: Re: Re: [Question #39389]: how to convert text (odt) document to calc?
 >До: <email address hidden>
 >Изпратено на: Петък, 2008, Юли 18 17:57:34 EEST

 >Your question #39389 on openoffice.org in ubuntu changed:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 > Status: Open => Answered
 >
 >Harvey Muller proposed the following answer:
 >nnarta,
 >
 >You can also try copying the text from the openoffice write document,
 >and then pasting it into a new openoffice calc worksheet.
 >
 >Please return to Launchpad and mark this question Solved, if this
 >resolves your question.
 >
 >Thanks!
 >
 >Harvey
 >
 >--
 >If this answers your question, please go to the following page to let us
 >know that it is solved:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389/+confirm?answer_id=5
 >
 >If you still need help, you can reply to this email or go to the
 >following page to enter your feedback:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 >You received this question notification because you are a direct
 >subscriber of the question.
 >

nnarta,

I think I am begining to understand your issue. It would be helpful if you could post 3 - 5 lines from the odt document.

Thanks!

Harvey

Dear Harvey,
Here are few lines... don't mind the language. Parts in bold must be in column A, those in italic - B, normal ones - C.

 Priema ocenkata na neparichnata vnoska na Obshtina Blagoevgrad, taka kakto e opredelena v zakliuchenieto na veshtite lica i prieta po gr.d.№215/2006g. na Okryzhen syd – Blagoevgrad na obshta stojnost 455 048 /chetiristotin petdeset i pet hiliadi i chetirideset i osem/ leva
 <!--
  @page { margin: 2cm }
  P { margin-bottom: 0.21cm }
 -->
  .
Dava syglasie da se uchredi druzhestvo s ogranichena otgovornost, mezhdu Obshtina Blagoevgrad i PFK “Pirin Blagoevgrad”.

Tnahk u for your help!

 >-------- Originalno pismo --------
 >Ot: Harvey Muller
 >Otnosno: Re: Re: Re: [Question #39389]: how to convert text (odt) document to
 calc?
 >Do: <email address hidden>
 >Izprateno na: Petyk, 2008, Iuli 18 18:50:30 EEST

 >Your question #39389 on openoffice.org in ubuntu changed:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 > Status: Open => Answered
 >
 >Harvey Muller proposed the following answer:
 >nnarta,
 >
 >I think I am begining to understand your issue. It would be helpful if
 >you could post 3 - 5 lines from the odt document.
 >
 >Thanks!
 >
 >Harvey
 >
 >--
 >If this answers your question, please go to the following page to let us
 >know that it is solved:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389/+confirm?answer_id=7
 >
 >If you still need help, you can reply to this email or go to the
 >following page to enter your feedback:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 >You received this question notification because you are a direct
 >subscriber of the question.
 >

nnarta,

That did not come across the way you intended. There is no bold or italic text.

You may resend the sample as an odt file to hlmuller<deletethis>@<deletethis>yahoo<deletethis>.com

Don't worry about the language difference!

Thanks,

Harvey

nnarta,

Thank you for sending the sample. The green, purple, and blue columns are easily distinguished from each other because they are separated by commas.

But I see a problem in that the yellow column is not separated from the green by a comma.

If the yellow column is ALWAYS ended by the word "Blagoevgrad", then I can provide you instructions that will insert a comma immediately after Blagoevgrad.

Once all of the columns are clearly separated by commas, then it will be easy to import into OpenOffice Calc.

Please let me know if Blagoevgrad always indicates the end of the first, or yellow column.

Thanks!

Tnank U Harvey,
The word Blagoevgrad always indicates the end of that first part.

Regards!

 >-------- Оригинално писмо --------
 >От: Harvey Muller
 >Относно: Re: Re: Re: Re: [Question #39389]: how to convert text (odt) document
 to calc?
 >До: <email address hidden>
 >Изпратено на: Събота, 2008, Юли 19 15:05:29 EEST

 >Your question #39389 on openoffice.org in ubuntu changed:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 >Harvey Muller proposed the following answer:
 >nnarta,
 >
 >Thank you for sending the sample. The green, purple, and blue columns
 >are easily distinguished from each other because they are separated by
 >commas.
 >
 >But I see a problem in that the yellow column is not separated from the
 >green by a comma.
 >
 >If the yellow column is ALWAYS ended by the word "Blagoevgrad", then I
 >can provide you instructions that will insert a comma immediately after
 >Blagoevgrad.
 >
 >Once all of the columns are clearly separated by commas, then it will be
 >easy to import into OpenOffice Calc.
 >
 >Please let me know if Blagoevgrad always indicates the end of the first,
 >or yellow column.
 >
 >Thanks!
 >
 >--
 >If this answers your question, please go to the following page to let us
 >know that it is solved:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389/+confirm?answer_id=10
 >
 >If you still need help, you can reply to this email or go to the
 >following page to enter your feedback:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 >You received this question notification because you are a direct
 >subscriber of the question.
 >

Hello,
Thank you very much!!!
It is the exactly what I was trying to do!
Best regards,
nnarta

 >-------- Оригинално писмо --------
 >От: Harvey Muller
 >Относно: Re: Re: Re: Re: Re: [Question #39389]: how to convert text (odt)
 document to calc?
 >До: <email address hidden>
 >Изпратено на: Събота, 2008, Юли 19 19:35:39 EEST

 >Your question #39389 on openoffice.org in ubuntu changed:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 > Status: Open => Answered
 >
 >Harvey Muller proposed the following answer:
 >nnarta,
 >
 >To convert the data to a format OpenOffice Calc can use, every column of
 >data must be separated by a character, most times a comma (,) is used.
 >
 >I see two problems:
 >
 >1. There is no clear separation between columns 1 and 2. Therefore a
 >comma must be inserted between columns 1 and 2. Although "Blagoevgrad"
 >normally marks the end of column 1, "Blagoevgrad" is used in other
 >columns. This means you cannot simply find and replace all instances of
 >"Blagoevgrad" with "Blagoevgrad,".
 >
 >2. Commas are present in column data. In the second row, column 4,
 >there is a comma between Botev and se. This means OpenOffice Calc would
 >create 5 columns for this row.
 >
 >These are my recommendations, which will require you to manually edit
 >the document prior to conversion to OpenOffice Calc:
 >
 >A. Open the document and save as -CORRECTED
 >
 > That will give you a clean copy to work with.
 >
 >B. Use the "Find and Replace" function in OpenOffice Writer to manually
 >find and replace the first instance of "Blagoevgrad" with "Blagoevgrad,"
 >in each row of data. Do not find and replace all, or you will put
 >commas in columns 2 through 4 where there should not be any.
 >
 >C. Using the second row of data as an example, replace the comma
 >between Botev and se with a ^.
 >
 > Before: Botev“, se
 > After: Botev“^ se
 >
 >This must be done for each column where you have a comma within the
 >data. We will only be using commas to distinctly separate columns.
 >
 >D. After the data is "cleaned", save the document as a text file. Open
 >the text file, copy it and paste it into a blank calc worksheet. You
 >will get a window titled "Text Import". In the "Separated by" section,
 >uncheck the "Tab" box and check the "Comma" box. Then click ok.
 >
 >E. Confirm the data as it is supposed to be.
 >
 >F. Once everything looks good, you can use "Find and Replace" to
 >replace all instances of '^' with ',' to get your commas back.
 >
 >Please report back to Launchpad and mark this question Solved, if this
 >resolves your question.
 >
 >Thanks!
 >
 >Harvey
 >
 >--
 >If this answers your question, please go to the following page to let us
 >know that it is solved:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389/+confirm?answer_id=12
 >
 >If you still need help, you can reply to this email or go to the
 >following page to enter your feedback:
 >https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/39389
 >
 >You received this question notification because you are a direct
 >subscriber of the question.
 >

Thanks Harvey Muller, that solved my question.