Ask Your Question

10/09/2017 becomes 09/10/2017

asked 2018-09-18 08:20:25 +0200

sebybar gravatar image

updated 2018-09-18 08:21:38 +0200

Hello, in the cell B3 of this spreadsheet link text

I insert 10/09/2017 and when I press Enter it becomes 09/10/2017. The problem has arisen in the last 2 packages (Libreoffice 64 bit for windows)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-09-18 08:26:46 +0200

gabix gravatar image

updated 2018-09-18 08:27:49 +0200

And what is the problem actually? The behavior corresponds to the date format. Change the date format and/or language in the cell properties dialog.

edit flag offensive delete link more


ok now I know. Anyway I've been using this spreadsheet for a few years, always updating LibreOffice to the latest version, and I've never had this problem.

sebybar gravatar imagesebybar ( 2018-09-18 09:04:30 +0200 )edit

Maybe you switched the default locale on your system, for example from it-IT to en-US. The cell B3 is formatted to Italian (Italy) date GG/MM/AAAA (which is translated of DD/MM/YYYY); if your system is now en-US and the work locale is set to default (following the system locale) then likely your Date Acceptance Patterns contain M/D/Y so input is accepted as Mike explained but displayed differently.

erAck gravatar imageerAck ( 2018-09-18 22:35:45 +0200 )edit

answered 2018-09-18 08:34:55 +0200

You need to check two items:

  1. Date acceptance patterns (under OptionsLanguage SettingsLanguages): this setting allows program to understand which strings must be treated as dates, and parts of those strings mean what. I.e., an acceptance string like M/D/Y allows program to see that a string having three numeric parts separated by forward slashes is an accepted date, and in that date, month is the first part, then goes day, and then year. So it converts the entered matching string to a date with those parts (which is internally a number), and write the resulting number to a cell's value.
  2. Cell format's Format code: it tells the program how to display cell's value. So in case of a format code like DD/MM/YYYY, Calc would know that a number in this cell must be shown as date, and the day of the date must be shown first, then month, then year.

As I shown above, it's possible for these two settings to be out of synchronization, thus interpreting your input in one manner, and show it back in another. Correct them to be in accordance.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-18 08:20:25 +0200

Seen: 51 times

Last updated: Sep 18 '18