Log in
Register|
ElMaestro ★★★ Denmark, 2010-03-03 23:02 (5160 d 09:16 ago) Posting: # 4857 Views: 10,857 |
|
|
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 ★★★   Vienna, Austria, 2010-03-04 16:33 (5159 d 15:46 ago) @ ElMaestro Posting: # 4861 Views: 8,563 |
|
|
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]](img/uploaded/image39.png) This procedure should convert the decimal separator from "." to the one in your localization (Belgium: ",")... — Dif-tor heh smusma 🖖🏼 Довге життя Україна! ![[image]](https://static.bebac.at/pics/Blue_and_yellow_ribbon_UA.png) Helmut Schütz ![[image]](https://static.bebac.at/img/CC by.png) The quality of responses received is directly proportional to the quality of the question asked. 🚮 Science Quotes |
Ing. Helmut Schütz