Ask Your Question

How to get calc to recognize pasted input as date, not text?

asked 2016-06-13 10:10:04 +0100

Thomas K. gravatar image

updated 2016-06-13 10:10:41 +0100

I'd like to enter dates formatted "TT.MM.JJJJ" into libre office calc.

Inserting a single date works. two dates seperated by a tabulator (so 1 row, 2 columns) works fine to. But as soon as I try to insert multiple rows I get this nice open csv wizard view and no matter what options I choose in there my dates are recognized as text instead of date.

Please help. I'm working on Linux Mint 18 (~ Ubuntu 16.04) which comes with:

Libre Office Version: Build
ID: 1:5.1.3-0ubuntu1 CPU Threads: 8;
OS Version: Linux 4.4; UI Render:
default;  Locale: en-US (en_US.UTF-8)
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-06-13 10:14:29 +0100

Thomas K. gravatar image

Hah! I thought I tried that before, but this time it worked:

  1. select language "German (Austria)" and
  2. check "detect special numbers"
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-13 10:10:04 +0100

Seen: 202 times

Last updated: Jun 13 '16