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.

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
9:59 PM
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
6:07 AM
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
1:27 PM
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
4:04 PM
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
9:54 PM
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
10:13 PM
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
5:28 AM
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)
9:02 PM
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)
3:48 AM
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
10:25 AM
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
7:15 PM
Post a Comment

Popular posts from this blog

Base64 decode to file

The internet sometimes sucks. I spent about 20 minutes searching the internet for an easy way to decode a base64 file in linux. Shouldn't be that hard. In fact, there is a base64 command. But fuck me, I sure couldn't get it to work with the file I had (which was supposed to decode into a .jpg). There is tons of nonsense about the theory and some stupid unhelpful web applications, but no practical examples. That is, until I stumbled upon this little gem - which gave me exactly what I wanted. perl -MMIME::Base64 -ne 'print decode_base64($_)' < file.txt > out A one-liner in Perl (of course). The fact that this info was so easy, yet it was so hard to find pisses me off. I'm sure there are other ways to do this. In fact, if you know of other ways to do this, then please leave me a comment telling me how. I hate when good info gets buried under the load of crap clogging the internet tubes. Technorati Tags: linux , base64 , perl
Read more

Swiftboating from the Left - Paul Harris's "The Real McCain"

The teaser of Harris's article is this: "To his fans he's a lovable patriot with a maverick streak. But to his critics he's an anti-abortion Creationist who surrounds himself with religious extremists. Paul Harris uncovers the dark side of John McCain" I'm an Obama supporter, but merely from the teaser I already want to run to McCain's defense. An "anti-abortion Creationist"? Really?? Bullshit. This is like the Obama "Terrorist fist jab" teaser on Fox - its utterly stupid. And provably so from a not-to-long ago debate: The rest of the article is blindingly obvious in its propagandistic machinery. Briefly mention a few reasons someone might think he's not such a bad guy (make sure to put it in the subjunctive). Claim this is all a facade to "propel him to the Oval Office". Expose the "dark side" that "lies behind his public mask". Pull out any dirt you can and start slinging. Precisely this formula is ...
Read more

Installing Virtualbox's Guest Additions on Debian and getting shared folders to work

Follow these steps to install the Guest Additions on your Debian virtual machine: 1. Login as root; 2. Update your APT database with apt-get update; 3. Install the latest security updates with apt-get upgrade; 4. Install required packages with apt-get install build-essential module-assistant; 5. Configure your system for building kernel modules by running m-a prepare; 6. Click on Install Guest Additions… from the Devices menu, then run mount /media/cdrom. 7. Run sh /media/cdrom/VBoxLinuxAdditions.run, and follow the instructions on screen. Once you install and reboot, then you can add shared folders from the device menu, and mount it with the following command: # mount.vboxsf [the_name_of_the_shared_folder] /media/[name_of_mount_point]
Read more