Getting tabulated data into OpenOffice Calc [Tips / Tricks]

posted by ElMaestro  – Denmark, 2010-03-03 23:02 (5138 d 17:37 ago) – Posting: # 4857
Views: 10,771

Dear HS and all,

one thing that troubles me occasionally is getting data presented on the forum in tabulated form (example here) into a spreadsheet application like OpenOffice Calc.
I just cannot get it working, and I more often than not end up typing the data manually into my spreadhseet.

There are different elements involved. Possibly a process like: Mark the table, copy it to memory, shift windows, paste into the spreadsheet, use a "text to columns" function and finally make the spreadsheet understand that what is now in cell this-and-that is not text but numbers.
I just cannot get the last two steps working in a coordinated fashion.
Any ideas how to do it in Calc (not Excel)?

Best regards, and many thanks for any hint you can offer,
EM.

Complete thread:

UA Flag
Activity
 Admin contact
22,957 posts in 4,819 threads, 1,638 registered users;
73 visitors (1 registered, 72 guests [including 5 identified bots]).
Forum time: 16:40 CET (Europe/Vienna)

Nothing shows a lack of mathematical education more
than an overly precise calculation.    Carl Friedrich Gauß

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz
HTML5