# When I type X1 in calc it turns into 01.10.2001 (Slovak or Polish locale)

When I type X1 in calc it turns into 01.10.2001 how to disable auto format? How do I disable this bug? Any work around? Will they fix this bug?

(Reported behaviour experenced with LibO V4.2.3)

edit retag close merge delete

Would you mind to tell what locale you actually worked in?
Would you mind to tell what your 'Date acceptance patterns' field contained exactly?
Would you mind to tell if you actually had entered a space between the X and the 1?
All this is information needed by the next user visiting this thread to judge if it is relevant for him. Communities are not one-way.

( 2017-07-31 13:23:24 +0100 )edit

Having used up about 1 hour with this I can tell:
(I hvave no V4.2.3 - the V posted in a comment below - still at hand.)
With V4.2.8 Portable (which I had preserved for special reasons). I actually got the above reported behaviour under the default settings created by choosing the 'Slovak' or the 'Polish' locale. It was a bug!
I cannot tell which version first got fixed the bug. Recent versions (oldest one tested was V4.4.7) don't show it.

( 2017-07-31 13:33:17 +0100 )edit

Nobody should delete this topic. It may be helpful for another user who sticked to an older version.
This was not an autoformat and not a AutoCorrect issue but one of bad "recognition" of special input as dates.

( 2017-07-31 13:40:23 +0100 )edit

Sort by » oldest newest most voted

Why do people always call their ignorance the software's bug?

LibreOffice converts user input to dates based on cells' locale and settings located in Options-Language Options-Languages (Date acceptance patterns). You may change them as it fits you. Btw: you didn't mention neither version of LO, nor OS, nor your locale to be able to assist you further.

more

The OQer seems to work with a Polish locale. Date acceptance pattern M Y will then cause the described behaviour if the space also is entered.I cannot find a way to get the "recognition" work without the space, however. But why should a questioner disclose all his secrets to us?

Down with that silly localitis! It only helps to perpetuate stubborn sticking to bad practice - and to induce puzzling problems with general purpose software pretending to support the "simple user"..

( 2017-07-31 09:33:17 +0100 )edit

Using common and uniform patterns universal for all users over the world could make our lives better and simpler... if only users agreed :) I see too much users insisting on their right to use unreadable local letter sequences instead of unreadable English letter sequences (e.g. in Calc functions) - e.g. on grounds of less layout switches. Since 5.3, Russian localization started to include Calc localized function names because of that. Sigh...

( 2017-07-31 09:39:35 +0100 )edit

Other than that, we have localized format specifiers characters. Decimal/thousands separators are locale-specific; and also for some locales, the format keywords themselves (e.g. HH, MM) are localized, too! This makes e.g. TEXT function unportable!

But we live in real world. And there is no one great authority here who might pretend to know the Ultimate Good solution to everyone's requirements. C'est la vie.

( 2017-07-31 09:43:00 +0100 )edit

There is no ask.libreoffice.org.ru to date as far as I know. Did you worry about https://listarchives.libreoffice.org/... Will serve the demand? Yes, there surely are forums in Russian/Cyrillic ... Ukrainian? Will they be lively enough. How many contributors?
There are branches for Spanish, Italian and German. Have a look into them.
I sometimes refuse to search for German function names when I answer in ...de.
Questioners understand nonetheless. A miracle?

( 2017-07-31 09:55:58 +0100 )edit

Personally I don't care too much about local ask sites; I prefer answering in locale-independent way, and overall, my duties are more developer-related. I only support in my spare time. So, all these locale-specific issues are more of a hobbyist observations and wishes :)

( 2017-07-31 10:03:35 +0100 )edit

Similar with me. Except that I'm not a developer, and not only disregard locales a far as possible, switch off 'AutoCorrec' ..., but also argue against the ways "l10n" goes.
Even having set Esperanto as my locale I didn't manage to get a 4-digut-year into the default date format (which is ISO extended otherwise). German norming authority made ISO 8601 extended the standard. LibO ignores. The 2-digit-mess ("Y2k") is long forgotten....
There are 253 equally idiotic locales in V5.4.0.3 now.

( 2017-07-31 10:35:49 +0100 )edit

Can I safely delete this whole question topic since Mike helped me fix this and it's no longer needed?

( 2017-07-31 13:01:03 +0100 )edit

I suppose you can. Good to hear that you solved your issue!

( 2017-07-31 13:02:21 +0100 )edit

So here's version: Windows 7 64bit LO: Version: 4.2.3.3 Build ID: 882f8a0a489bc99a9e60c7905a60226254cb6ff

Options-Language Options-Languages (Date acceptance patterns) yes I know about this, i tried changing it but what pattern X1 matches? D.M.Y;D.M.;D. M.;D. M. Y;D. M.;D. M. Y does not seem to match any. Happens in English or Slovak settings in autocorrect. I have disabled all options in all tabs in autocorrect. I use English locale.

My ignorance? If it's my ignorance then, why so many people complain about auto format of date?

Update to 5.4.0.3 fixed my problem thanks Mike!

more

The main reason why I mentioned ignorance is inability to ask good questions. I described what you omitted in your question in my comment; and even then you didn't tell your locale in your answer. I only have to guess that @Lupp is right in his assumption.

And only given your information (version), and Lupp's guess (locale), can I see that 4.2 did have a problem absent in later versions. So no, "they" will not fix what is already fixed.

( 2017-07-31 10:12:31 +0100 )edit

And users will always have questions WRT locale-specific topics, e.g. on grounds described by @Lupp. And also on any non-trivial topic in life. And there will always be people that like things that drive you nuts. So the mere fact that something gives rise to multiple questions doesn't make something a bug per se.

( 2017-07-31 10:14:36 +0100 )edit

I tried doing really everything but I couldn't find anything other than LO devs are disconnected from reality and simmilar style of answers to this date auto format topic, me disabling autocorrect didn't do anything so after lot of frustration I decided to post question where I got answer that it was fixed with an update. I didn't think it would help so I'm doing it right now.

Updating fixed my problem thanks Mike!

( 2017-07-31 12:51:31 +0100 )edit