Wednesday, February 18, 2009

How to import an openoffice spreadsheet into a table

The tip can be found here. Basically, here is what you do:
  • Create a new Writer Table with the number of columns and rows you need
  • In Calc, select and copy the range of cells you want to import into Writer
  • In Writer, use Paste Special below or above the Writer table (not in the table, yet). For 'Selection', choose either "Formatted text [RTF]" or "HTML (HyperText Markup Language)". This creates a temporary table.
  • Select and copy the contents of the newly created (but badly formatted) temporary table.
  • Paste the contents of the temporary table into the original table you created in the first step.
  • Delete the temporary table.

13 comments:

Rachat de credit said...

Thanks a lot it has been a very good support, now to import an openoffice spreadsheet into a table is without a doubt simple with your information. Thank you

Anonymous said...

http://nen360.nenonline.org/blog/itll-be-big-itll-be-tough
http://idioproject.com/social/index.php?do=/blog/57365/having-too-many-spyware-removers-or-running-on-your-system-actually-could-b/
http://prsites.biz/myblog-admin/there-was-an-urgent-need-a-a-a-a-a-a-a-a-a-a-a-a-a-for-a-replacement.html
http://www.toma.jp/blog/jiumengshici/?entry_id=869830
http://oriflameblog.cz/forum/topic/finding-cheap-and-effective-deals-has-become-as-easy-as-clicking-your-mouse?replies=1#post-38790
http://archive.remdublin.com/blog/xmyshang/2013/01/27/jatimberlandsale
http://blog.qlep.com/blog.php/223035/718351
http://www.toma.jp/blog/333333/?entry_id=870634
http://nen360.nenonline.org/blog/does-mean-end-spyware-we-know-it
http://www.toma.jp/blog/aaa333/?entry_id=870937
http://prsites.biz/myblog-admin/with-spts-help.html
http://www.heavenlysins.com/index.php?do=/blog/46759/when-you-use-a-spyware-remover/
http://www.toma.jp/blog/333333/?entry_id=870629
http://blog.qlep.com/blog.php/216559/718423
http://idioproject.com/social/index.php?do=/blog/57363/there-m-a-r-c-b-y-m-a-r-c-j-a-c-o-b-s-%E3%83%90-%E3%83%83-%E3%82%B0-is-presently-only-one-option-fo/

Anonymous said...

http://bloggervillage.com/index.php?do=/blog/5081/the-on-tory-burch-riding-boots-foot-navigation-is-a-great-additional-featur/
http://www.benches2swings.com/vocab/catpath/comparison-sites-other-hand-make-you-compare-various-manufacturers-and-models-and-enab
http://blog.qlep.com/blog.php/223035/718355
http://www.acdating.net/index.php?do=/blog/77942/always-be-aware-of-where-you-search-for-your-spyware-virus-protetion/
http://thundernetworks.info/jcow/index.php?p=blogs/viewstory/28091
http://d.hatena.ne.jp/jiumengshici/20130129/1359425718
http://www.acdating.net/index.php?do=/blog/77203/sim-free-mobile-phones-enjoy-the-freedom/
http://sns.cam111.com/blogs/entry/-The-inventors-of-the-Shifting-Calories-method-market-such-a-diet-under-the-name-Fat-Loss-4-Idiots
http://www.heavenlysins.com/index.php?do=/blog/46759/when-you-use-a-spyware-remover/
http://heraldbulletin.neighborsink.com/node/247765
http://www.heavenlysins.com/index.php?do=/blog/46760/when-you-use-a-spyware-remover/
http://jiumengshici.hatenablog.com/entry/2013/01/28/145228
http://www.mymarburg.com/blog/76809/this-can-%E3%83%9F-%E3%83%A5-%E3%82%A6-%E3%83%9F-%E3%83%A5-%E3%82%A6-%E8%B2%A1-%E5%B8%83-be-even-more-true-if-you-use-refilled-ink-cartridg/
http://www.toma.jp/blog/aaa333/?entry_id=870947
http://www.moselbook.de/index.php?p=blogs/viewstory/144331

Anonymous said...

My brother suggested I would possibly like this web site.
He used to be entirely right. This post truly made
my day. You cann't imagine just how so much time I had spent for this information! Thanks!

Feel free to visit my web page: book of rah

Anonymous said...

Pretty great post. I just stumbled upon your blog and wanted to mention that I've truly loved browsing your weblog posts. After all I'll be subscribing to your rss feed and I am hoping you write once
more very soon!

my site: Garcinai Cambogia Review

Anonymous said...

I have been surfing online greater than 3 hours today, yet I never discovered any attention-grabbing article like yours.

It's lovely value enough for me. In my opinion, if all webmasters and bloggers made excellent content as you probably did, the web can be a lot more helpful than ever before.

Visit my web page: Skin cream

Anonymous said...

We are a group of volunteers and opening a new scheme in our
community. Your website offered us with valuable information to work on.

You have done a formidable job and our whole community will be thankful to you.


my blog: Internet Money Path Reviews

Anonymous said...

Howdy! I simply want to offer you a big
thumbs up for your great info you've got right here on this post. I am returning to your blog for more soon.

Feel free to surf to my web site; Buy Garcinia cambogis

Anonymous said...

My programmer is trying to persuade me to move to .net from PHP.
I have always disliked the idea because of the expenses.
But he's tryiong none the less. I've been using Movable-type on a
variety of websites for about a year and am anxious
about switching to another platform. I have heard good things about blogengine.net.
Is there a way I can transfer all my wordpress posts into it?
Any kind of help would be really appreciated!


Visit my page - mold testing manhattan (www.youtube.com)

Anonymous said...

"I think a good image is it's based on paranoia and surveillance. Read further to learn what the symptoms are when a drive shaft goes bad. If you're a teenage girl, you would need persuasion techniques to convince your parents to buy you that dress.

Check out my website :: performance texas wrightway auto carriers inc (http://www.letsp.net)

Anonymous said...

Have you ever thought about adding a little bit more than just your
articles? I mean, what you say is valuable and all. Nevertheless imagine if you added some great visuals or video
clips to give your posts more, "pop"! Your content is excellent but with pics
and video clips, this blog could certainly be one of the best in its niche.
Great blog!

Here is my homepage :: click here for more info

Anonymous said...

of course like your website but you need to take a look
at the spelling on quite a few of your posts. A number of them are
rife with spelling problems and I find it very bothersome to inform the reality then again I will
surely come again again.

Look into my web-site ... Beli etude murah; Http://alangbtk.livejournal.com/,

Anonymous said...

I think the admin of this web page is in fact working
hard in favor of his web page, as here every data
is quality based data.

Here is my blog post; santa cruz theta healing