Ask Your Question

Seriously's profile - activity

2019-06-28 19:52:19 +0200 received badge  Famous Question (source)
2019-06-28 19:52:19 +0200 received badge  Notable Question (source)
2019-01-09 16:46:15 +0200 marked best answer Copy Date from csv

Hi,

I have a .ods sheet containing (among lots of other stuff) three columns with the following formats: Text; Date; Currency.

I also have a .csv file with only the same three columns.

What I now want, is to simply open the .csv with LibreOffice Calc (preferably without any import tinkering) and only copy all the stuff from the .csv to the .odt sheet.

Using Special paste and there clicking "Values Only" works for the text and currency to be pasted correctly. However, the date is prefixed with a ' and shifted to the left (and therefore treated as text?).

The .odt target date Format is DD.MM.YY (however, when I click on the cell it is represented as MM/DD/YY) The date string in the .csv is DD.MM.YY. I can modify this during the creation of the csv if this would help.

2019-01-09 16:46:15 +0200 received badge  Scholar (source)
2019-01-09 16:46:13 +0200 commented answer Copy Date from csv

Thanks. Changing how the .csv is imported seems to be the quickest way for me. I was hoping since it already worked out

2019-01-09 14:58:11 +0200 received badge  Popular Question (source)
2019-01-08 18:59:30 +0200 received badge  Organizer (source)
2019-01-08 18:57:59 +0200 asked a question Copy Date from csv

Copy Date from csv Hi, I have a .ods sheet containing (among lots of other stuff) three columns with the following form