Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to paste data in Openoffice Calc but it doesn't seem to work.

The example with the first row (of 124 rows), this is the data in a .dat-file:

   0.592    0.349    1.333    0.617

When I want to insert it in openoffice (either through copy + paste or open and then select the .dat-file) I got a screen with several options to paste the data: screenshot openoffice. There I selected that a space marks as separation (to put the data in four columns and not in 1). When I press 'OK', all the zeros and commas disappear: screenshot openoffice 2. Does anyone knows how to solve this?

share|improve this question
Does OpenOffice (or your whole computer) believe that it is in a locale where the thousands’ separator is . (period) and the decimal point is , (comma)? That would cause it to interpret “2.013” as the current year, rather than a number slightly more than two. – Scott Jun 1 '13 at 1:50

It looks like your values are simply multiplied by one thousand.

You could just divide them all by one thousand again.

share|improve this answer
Yeah, but what causes the problem? – Janos Braem May 31 '13 at 12:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.