ElMaestro
★★★

Belgium?,
2010-03-03 22:02

Posting: # 4857
Views: 7,639
 

 Getting tabulated data into OpenOffice Calc [Tips / Tricks]

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.
Helmut
★★★
avatar
Homepage
Vienna, Austria,
2010-03-04 15:33

@ ElMaestro
Posting: # 4861
Views: 5,950
 

 Converting decimal point to comma

Ahoy!

Ha, that will cost you a bottle of your ol' reserve.
The problem is evident only on localizations of the operating system (M$-Windows, Linux) with the comma as the decimal separator. You were on the right track: import from the clipboard (unformated text) > separator: blank > combine separators >
Now you have to select each column and set the type to "US-English" > OK
Screenshot from my German version of OO Calc:
[image]
This procedure should convert the decimal separator from "." to the one in your localization (Belgium: ",")...

Cheers,
Helmut Schütz
[image]

The quality of responses received is directly proportional to the quality of the question asked. ☼
Science Quotes
Activity
 Thread view
Bioequivalence and Bioavailability Forum |  Admin contact
19,685 posts in 4,176 threads, 1,351 registered users;
online 8 (0 registered, 8 guests [including 5 identified bots]).
Forum time (Europe/Vienna): 08:44 CEST

Normality is a myth; there never was, and never will be,
a normal distribution.    Roy C. Geary

The BIOEQUIVALENCE / BIOAVAILABILITY FORUM is hosted by
BEBAC Ing. Helmut Schütz
HTML5