Ask Your Question

calc date separator [closed]

asked 2013-03-10 15:37:05 +0200

Grouch gravatar image

updated 2015-10-26 19:35:54 +0200

Alex Kemp gravatar image

In LibOffice 3.5.1 I could format a cell as Date | Dec 31, then enter a date such as 3-10 and it would convert to Mar 10. In my newly installed LibOffice, the format requires that the separator be a slash (/) rather than a hyphen (-). Why the change? Why not accept either? Sincerely/TheOldGrouch

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 19:36:30.172527


2 Answers

Sort by » oldest newest most voted

answered 2013-03-11 06:18:43 +0200

ROSt52 gravatar image

In Version (Build ID: 5b93205)

I can enter dates like 13-3-11 or 13/3/11 and get the date in the format of the cell which could be e.g. mmm dd leading to Mar 10. Thus all works fine.

However, I need to enter yy/m/d or yy-m-d. If I only use m/d or m-d the entered string is not recognized as a date but as text.

edit flag offensive delete link more

answered 2013-03-11 00:43:09 +0200

horst gravatar image

They changed alot from 3.6 to 3.6 in date acceptance pattern. Check out this question and the answers from manj_k.

edit flag offensive delete link more

Question Tools


Asked: 2013-03-10 15:37:05 +0200

Seen: 359 times

Last updated: Mar 11 '13