Ask Your Question
0

Importing English numbers into a German spreadsheet [closed]

asked 2016-03-04 16:20:14 +0200

Vex gravatar image

Hi all,

I am receiving an English csv and want to open it with a German version of Libre Office, as the output should be German.

Even with the option to "detect numbers" checked, I am getting the English numbers as text, not as a number. Currently I am using Find and Replace "." to ",", but there's plenty of obscure errors happening instead (sometimes, the "." disappears but the "," isn't set, suddenly resulting in a number that's 1000 times higher than expected).

Is there a way to convert English to German more easily?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Vex
close date 2016-03-08 10:43:06.991599

4 Answers

Sort by » oldest newest most voted
1

answered 2016-03-04 16:31:50 +0200

JohnSUN gravatar image

updated 2016-03-04 18:25:45 +0200

Of course it is possible! Just set type of column as English (settings of import filter)

English To German

See movie. WIDW?

StepByStep

edit flag offensive delete link more

Comments

Aaaah okay, that helps, thanks! Then I have to change the format in the spreadsheet itself back to German again.

Is there a way of automatically import US English numbers in German format?

Vex gravatar imageVex ( 2016-03-04 16:37:38 +0200 )edit

Why?!! No need! Just set Sprache=Deutsch (second field) and see result of this

JohnSUN gravatar imageJohnSUN ( 2016-03-04 16:55:58 +0200 )edit

Sadly that doesn't work. I can now import English numbers as English numbers, but they retain the "." instead of getting a ",". I need to manually format these rows only and switch them back to German numbers.

This is Libre Office 4.4.5.2, locale: de_DE

Vex gravatar imageVex ( 2016-03-04 17:48:27 +0200 )edit

This solution works in Open Office just fine, by the way - I tried it, thanks!

Libre Office still doesn't want to perform this without manually reformatting the cells. But thanks!

Vex gravatar imageVex ( 2016-03-08 10:38:25 +0200 )edit
1

answered 2016-03-04 16:40:04 +0200

karolus gravatar image

updated 2016-03-04 16:42:53 +0200

Hallo

Select or doubleclick the Columnheader[s] in the preview-area at bottom of CSV-Import-dialog and change the type from Standard to US-english

[edit: to slow ;-) ]

edit flag offensive delete link more
0

answered 2016-03-05 01:17:30 +0200

m.a.riosv gravatar image

What works fine for me it's use in the import window English (UK), instead in my case Spanish (Spain), it works for numbers with dot and with dates in an European format.

edit flag offensive delete link more
0

answered 2016-03-04 18:51:54 +0200

petermau gravatar image

By German numbers do you mean 111,34 rather than 111.34? This is the way of displaying numbers rather than two different numbers. Excuse my contribution as I am not a spreadsheet person, but the way I do it is to import the CSV as English as suggested above and then you will have straight numbers but displayed as "English". Sorry to give the example below in English as my German is not up to the taks.

You can then adjust the way they look by selecting the required columns and then in my English version, FORMAT CELLS > NUMBERS Choose the English version of number > Then select Language GERMAN (Germany) and edit the format code, changing (.) to (,). Select OK and the number display will be in German.. seems to work for me in English to French... Peter

edit flag offensive delete link more

Comments

This is correct, but it's a complicated way to do when it's not a single row or column but several different columns spread across the entire sheet. I was hoping for a solution to automatically import English (10.99) numbers to German (10,99) numbers without the need to manually reformat affected cells afterwards.

This way of course works, at least, so that's something!

Vex gravatar imageVex ( 2016-03-08 10:41:24 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2016-03-04 16:20:14 +0200

Seen: 525 times

Last updated: Mar 05 '16