[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|NEW |ASSIGNED AssignedTo|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 --- Comment #11 from Roman Eisele b...@eikota.de 2012-08-21 15:04:00 UTC --- (In reply to comment #10) Could we please stick to the original topic of this bug [...] @Eike: Sorry! @Rainer: Could you please file a separate enhancement request including your considerations from comment #3? They should not get lost here. And CC me for this new report, please! Thank you! @Mikeyy: Please add your request for support of Croation date format 31.08 either to bug 52240, if necessary (don’t forget to mention that this is a common date format in Croatian), or file a new bug report for it which should then block bug 52240. Thank you! -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 Roman Eisele b...@eikota.de changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||b...@eikota.de Ever Confirmed|0 |1 --- Comment #5 from Roman Eisele b...@eikota.de 2012-08-20 09:44:37 UTC --- (In reply to comment #3) IMHO for date formatted cells we should have a very aggressive date recognition, may be to be activated by an extra checkbox. I agree completely with Rainer. But NB: for date formatted cells only, right! In my eyes, this is a valid and very reasonable enhancement request, therefore I change the status of this report to NEW. (In reply to comment #4) I have about 300 LO users in my company and they are ALL used to enter date as 31.08 in cells which don't have date format (they have general format). Please let me ask a simple question, because I just don’t understand why the situation seems so clear to you. If a cell has date format, 31.08 should be recognized as August 31, of course. It might also be reasonable to recognize 31.08. (NB the final dot) as August 31 even in cells of general format. But if a cell has both general format and contains 31.08 without the final dot -- why should 31.08 then be recognized as August 31? It could be equally well be recognized as 31.08 (the numeric value), and IMHO this would be even more reasonable ... There are even German users who prefer '.' as decimal separator, '.' is the decimal separator in most languages of the world, and if you would present to me a paper with the figures 31.08 on it and ask me to guess what it means, I would just say: Most probably the numeric value 31.08; maybe a date (August 31), but the final dot is missing, and therefore this is very improbable. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 --- Comment #6 from Mikeyy mikeyy@gmail.com 2012-08-20 10:37:14 UTC --- If a cell has date format, 31.08 should be recognized as August 31, of course. It might also be reasonable to recognize 31.08. I have nothing against all date recognition on date formated cells. You can even recognise 31,08, as 31.08 of this year for all I care. That would even be nice feature since some keyboards (croatian style for example) have comma , instead of dot . on numerical keyboard between 0 and ENTER. But if a cell has both general format and contains 31.08 without the final dot -- why should 31.08 then be recognized as August 31? It could be equally well be recognized as 31.08 (the numeric value) In croatian language, dot . is used only as thousand separator, never as decimal separator. And dot . is never used on date endings (31.08. is wrong, 31.08.2012 is right). So, if I enter 31.8 or 31.08 you cannot make a mistake with recognising it as date and entering 31.08.2012 as value in general formated cell. For example, in Excel 2003 (newer versions probably behave same) if you enter 31.08.2012. (with dot at end) Excel will not recognise it as date even with date formatted cell. But why do I need to explain all that, you have it already is 3.5.6 version and you started tempering with it for unknown reason. You won't increase intuitive usage for users, it will be worse. You won't decrease time needed for user to enter date, you'll increase it. All in all, you'll make whole experience longer and less intuitive and you still think it's good thing to do. There are even German users who prefer '.' as decimal separator, '.' is the decimal separator in most languages of the world... There are probably croatian users which preffer dot . instead of , because they do accounting for english speaking area, but they can always change their preferences and enable dot as decimal separator. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 --- Comment #7 from Mikeyy mikeyy@gmail.com 2012-08-20 10:51:28 UTC --- Also, user in bug 52240 which tested 3.6.1 version complains that even in date formatted cells 16.8 isn't recognised as 16.8.2012 . -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 Michael Meeks michael.me...@novell.com changed: What|Removed |Added CC||er...@redhat.com, ||michael.me...@novell.com --- Comment #8 from Michael Meeks michael.me...@novell.com 2012-08-20 12:02:56 UTC --- Any thoughts Eike ? :-) (now a MAB) -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 --- Comment #9 from Roman Eisele b...@eikota.de 2012-08-20 13:46:01 UTC --- (In reply to comment #6) In croatian language, dot . is used only as thousand separator, never as decimal separator. And dot . is never used on date endings (31.08. is wrong, 31.08.2012 is right). So, if I enter 31.8 or 31.08 you cannot make a mistake with recognising it as date and entering 31.08.2012 as value in general formated cell. I may have overseen it, but you never mentioned here that you are talking specifically about the Croation locale. So let us assume that the date recognition you are talking about (to recognize 31.8 even in general fields as date) should be enabled only when the language of the document/cell is Croation. If it is true that in the Croatian language 31.8 is a valid and usual way to write August 31, then you are right: it would be reasonable to recognize 31.8 as August 31, even in general fields. So we all need to recognize how important the locale is. When you write: 31.08. is wrong, this may hold true for Croation (I just don’t know); in German, e.g., it is completely different: 31.8 is not a valid way to write a date, we *always* need the periods after the day number and after the month number. This may explain the misunderstanding why I (and other users) don’t understand why you insist on recognizing 31.8 as a date so heavily; and on the other hand, it explains why you don’t understand that we don’t understand that ;-). So, let’s state the following result: the locale, I mean, the current language setting for the document (or the part of the document we are editing), is very important and needs to be honored also for these special questions of date recognition. This is already done by LibreOffice in many respects, but not in all, as you example of 31.8 shows. For example, in Excel 2003 (newer versions probably behave same) if you enter 31.08.2012. (with dot at end) Excel will not recognise it as date even with date formatted cell. This is not disputed, and I never said anything like that; after the year number, even in German is never placed a period. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 Eike Rathke er...@redhat.com changed: What|Removed |Added Severity|enhancement |normal Version|3.6.0.2 rc |3.6.0.0.beta3 --- Comment #10 from Eike Rathke er...@redhat.com 2012-08-20 14:20:28 UTC --- Could we please stick to the original topic of this bug, which is about allowing a hyphen as date separator if the locale's separator is something else to allow date input on numeric keypad, and not mix in various other observations? Thank you. Related issues of abbreviated date input were already discussed in bug 52240 and especially for locales using the '/' separator already solved. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 --- Comment #4 from Mikeyy mikeyy@gmail.com 2012-08-19 19:34:23 UTC --- Looks to me that you are trying harder and harder to turn people away from LO. You took a simple feature which exists for who knows how many years in all Office suites and started making nuclear fysics out of it. I have about 300 LO users in my company and they are ALL used to enter date as 31.08 in cells which don't have date format (they have general format). Why are you trying to remove feature which is good and force upon users feature which is slower and worse? Where is the sense in that? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 Rainer Bielefeld libreoff...@bielefeldundbuss.de changed: What|Removed |Added Severity|normal |enhancement --- Comment #3 from Rainer Bielefeld libreoff...@bielefeldundbuss.de 2012-07-21 06:16:31 UTC --- IMHO for date formatted cells we should have a very aggressive date recognition, may be to be activated by an extra checkbox. Of course it will not be easy to get a quick solution for all localizations, but IMHO there exit some very plausible assumptions. a) Users who are very interested in this feature are experienced, use well prepared and so well formatted spreadsheet templates b) These templates have well defined cells only used for a particular kind of data. For example a cash account book has a column for - amount of money, only currency inputs - income date, only date values - payed date: only date inputs - subject, only text inputs. c) In these columns it is clear that the only exception for inputs differing from the selected formatting can be a text, no date input makes sense in a currency field and vice versa. Draft: d) so for a date field you can assume: da) A single number always will represent the Day number of the current Month of the current year db) 2 numbers separated by an arbitrary separator always will represent the Day number and the Month of the current year dc) 3 numbers separated by the same arbitrary separator always will represent Day and Month and current year e) in a document related property nearby the activate aggressive date recognition user has to define whether such inputs have to be uninterpreted as - Y M D (ISO, default) - D M Y - M C Y (I do not believe that other ones are used very often?) f) For all other inputs and for cells not formatted as date the more restrictive date recognition started in LibO 3.6 will be used. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 --- Comment #1 from Rainer Bielefeld libreoff...@bielefeldundbuss.de 2012-07-20 07:22:08 UTC --- I just see that my main did some exception handling without involving my brain ;-) T thought to type MM-DD (12-31) with 3.5. but actually I type DD-MM (31-12). Although I have become really used to do so, I would prefer some ISO8601 truncated input MM-DD, and I would have no problem at all to change my typing Since I started thinking about all this I now have problems with date typing with 3.5.5 This really is something for ux-advise! -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 --- Comment #2 from Johannes Weberhofer jweberho...@weberhofer.at 2012-07-20 07:58:13 PDT --- You example is not correct. Until 3.5 (and all Excel versions since 4.0, Staroffice and OpenOffice versions), the input (using the german locale) was tried to be interpreted as as DD-MM: therefore 12-31 resulted in a string 12-31, but 31-12 resulted in 31.12.2012 (31st December of the current year). In German language it is common to say a date is on the 31th of march or at the 31st 3rd (normally in german ;-) ) when you are speaking about the current year. So everything is consistent except the fact that minusses are used to seperate the values. Until 3.5 it didn't play any role if minuses or dots have been used for seperation. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard
https://bugs.freedesktop.org/show_bug.cgi?id=52288 Rainer Bielefeld libreoff...@bielefeldundbuss.de changed: What|Removed |Added CC||LibreOffice@bielefeldundbus ||s.de Blocks||52240 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
