[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from mr_sm...@openoffice.org Fri Feb 19 12:17:40 + 2010 --- It will be fixed for 3.3? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from bodri...@openoffice.org Wed Sep 23 13:13:38 + 2009 --- If somebody likes to have autorecognition, it shoud be. But can you add a checkbox "turn off automatic date recognition" in configuration which switch off by default? And if I don't need it I'll can switch it off. Thanks. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from h...@openoffice.org Tue Sep 22 17:57:07 + 2009 --- Problem presists since 2004. Why is that? To discourage people from using Calc from OpenOffice (and use some commercial product instead)? This is a major bug, a blocker. I have work to do, and it can not be done with OpenOffice. Work is simple. I have lots of data tables in PDFs. They all should be copied and pasted for further manipulation. But every cell containing sequence like 01- is converted to date - not on display formatting level - but original value is DESTROYED (if the conversion was made only on display level - without touching original data - there would be no issue at all) Dear OpenOffice team. Why do you keep on ignoring since 2004 that we, the users, want to have AN OPTION of converting pasted data to dates - OR NOT! Do you really think you know better what should be done with user's data than the user himself? Do you realize, that there are other countries, you know, "outside USA". Not all the world uses the same date format. Microsoft knows that. There are no problems with dates in any Microsoft product - no matter which language you use. It's 2009 now. 5 years. Can you please add a small checkbox to configuration ("turn of automatic date recognition") in 3.1.2? For now I must quit using OO for a while and look for an other spreadsheet software to finish my job. Shame. BTW, questions about my OS or locale should be irrelevant here. This issue is not about INCORRECT date recognition. It's about UNWANTED date recognition. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from and...@openoffice.org Wed Aug 19 18:21:32 + 2009 --- reaction to ped's comments certainly, to automatically apply any correction assumes that 1) the correction will always be appropriate and 2) the user is not intelligent enough to learn the appropriate entry It seems to me to be much more appropriate to demand confirmation before applying each autocorrection. (This is already done for formulas in calc.) Doing so : 1) incorrect corrections will not be applied and 2) the user will learn the appropriate entries. Of course, having undo is a VERY useful feature, as any user could inadvertantly confirm an unwanted "correction" By the way, in my calc all autocorrections undoable under tools:autocorrection_options are undone, as few are wanted in the best of times. Unfortunately the automangling into dates of numbers under certain circumstances is not undoable. Yet. my 2ยข - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from p...@openoffice.org Wed Aug 19 08:18:22 + 2009 --- This is driving me insane for years... I mean not just the obsession of calc by turning almost everything into date (while a single way "14/" would absolutely suffice me and would be welcome), but generally all the auto corrections. (For example capitalization of "x" is one of those things I have no more energy to fight with, I gave up) Because there's no Undo. Yes, we can discuss the formats which are "corrected" and should be not, or aren't and should be, but in the end, when you are using calc, no matter how smart the conversions are, you will hit a case when they are not welcome. At that point the missing Undo leads to epic fail. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from vladsavit...@openoffice.org Tue Jul 21 12:32:39 + 2009 --- Stupid and annoing thing! Fix it please! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 User rainerbielefeld changed the following: What|Old value |New value OtherIssuesDependingOnTh| |13671 is| | - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from mfra...@openoffice.org Fri May 8 13:25:27 + 2009 --- @regina but why is this bug report marked as 'ENHANCEMENT'? I would say that a program that changes a number like '13.2' into a date and a postcode into a currency value must not just be enhanced but corrected... and by the way if this issue is corrected according to the interpretation of andr55, you can also close issue 87999 (marked as DEFECT). @egle what would Lithuanians type that they expect to be interpreted as their currency? same question regarding zip codes. would it be case sensitive? aren't there in Lithuania people who -like me- seldom use capital letters? exponential notation is something that makes me cautious: maybe in the solution to this series of bugs it would be best to offer switching on/off automatic interpretation of formatted data per format. maybe also offer adding/removing formats (I mean: list of formats has variable length) and allowing the user to specify the conversion rules. selecting national settings would activate the standard list of rules for that nation and no other (built in) rules would be applied. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from and...@openoffice.org Fri May 8 12:28:57 + 2009 --- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is -mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) I would not call this issue an enhancement. In terms of normal use of a spreadsheet, it is an obvious bug. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from and...@openoffice.org Fri May 8 12:17:36 + 2009 --- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is -mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) --- Additional comments from and...@openoffice.org Fri May 8 12:26:39 + 2009 --- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is -mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) I would not call this issue an enhancement. In terms of normal use of a spreadsheet, it is an obvious bug. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from and...@openoffice.org Fri May 8 12:13:08 + 2009 --- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is -mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) --- Additional comments from and...@openoffice.org Fri May 8 12:14:36 + 2009 --- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is -mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from and...@openoffice.org Fri May 8 12:09:04 + 2009 --- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is -mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) --- Additional comments from and...@openoffice.org Fri May 8 12:10:53 + 2009 --- @regina with all due respect, the essence of the issue is automatic special formatting (be it dates, currency or whatever) interfering with a normal entry of data. There may be some users that prefer this behavior, but it should be optional, and preferably off by default. By the way, often ordinary numbers or texte + numbers is reformatted as dates when it doesn't even match any of the registered date formats. I've also encountered entries being unexpectedly converted to currency. (My locale is fr-CA.) e.g., if the calc date format is -mm-dd (using - as separator), entering 1.1.16 will be incorrectly formatted as the date 2001-01-16, even though it does not have the correct separators. Then changing the format to texte will result in some bizarre number, totally unrelated to what was entered. If someone wants a date format, they should be prepared to format the field as date before entering. Similar for currency. Or at least make this sort of behavior optional. If the solution is restricted to only dates, the problem is only partially solved -- a complete solution involves the same section of code. (That is, number formatting.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 User regina changed the following: What|Old value |New value CC|'andr55,cornouws,discoleo,|'andr55,cornouws,discoleo, |er,mantas,mykolasok,pagalm|er,mantas,mykolasok,pagalm |es,thing' |es,regina,thing' --- Additional comments from reg...@openoffice.org Thu May 7 20:22:47 + 2009 --- @egle: Your problem is a different one. The examples you have given are all texts and the user can avoid problems by formatting the cells to text-format before entering the texts or by using a prefix apostrophe to determine it as text. The issue here is about handling of numbers, whether they are recognized as date and time or not. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 User egle changed the following: What|Old value |New value CC|'andr55,cornouws,discoleo,|'andr55,cornouws,discoleo, |er,mantas,pagalmes,thing' |er,mantas,mykolasok,pagalm | |es,thing' --- Additional comments from e...@openoffice.org Thu May 7 19:37:14 + 2009 --- Problems are not only with date - Calc should also have "Ability to turn off Number Recognition for Currency and Scientific numbers in Calc". Lots of Lithuanian OOo users don't understand why they can enter their postal code with OpenOffice Calc - for examply my postal code is LT-3000, but Calc automatically changes this to Lithuanian currency (Lt) -3000,00 Lt Users even can't copy-paste text from OOo Writer's table :( Same problem is when entering E letter between numbers - Calc automatically changes this to Scientific numbers :( It's very important for Lithuanians to have user friendly ability to turn off such autoreplacing: lt3000 is replacecd to 3000 Lt LT-12012 to -12.012,00 Lt 120E12 to 1,20e+014 9E9 to 9,00e+009 Lots of users don't understand why there are no way to turn off this unintuitive Calc feature and are starting to user other Spreadsheet software, like Gnumeric, see discussion at Lithuanian support mailing list - https://lists.akl.lt/pipermail/naudotojai/2009-April/001776.html Please tell me, if I should report "Ability to turn off Number Recognition for Currency and Scientific numbers in Calc" as another bug or just change summary of this bugreport? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 User egle changed the following: What|Old value |New value CC|'andr55,cornouws,discoleo,|'andr55,cornouws,discoleo, |er,pagalmes,thing'|er,mantas,pagalmes,thing' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from to...@openoffice.org Mon Jan 19 11:14:17 + 2009 --- fijam: I have attached a screen shot of the import dialog showing that the selection of the "US English" is made after selecting a field column in the window. This enables the "Field Type" Dropdown box where you can make the Selection for "US English". I should have been more explicit in my previous post. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from to...@openoffice.org Mon Jan 19 11:07:05 + 2009 --- Created an attachment (id=59474) Screen Shot of Calc Import Dialog - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from fi...@openoffice.org Mon Jan 19 08:43:21 + 2009 --- Thank you for your prompt responses and guiding me in the right direction, Tom. Choosing "Western Europe(ASCII/US)" (I did not find US English there) in the import dialog did the trick. I should've probably stated my locale in the first place but I thought it was not relevant. Apparently, the Number Recognition works differently with different decimal separators - the default one for my locale is "," while the problematic file used ".". However, I believe the option to disable the Number recognition is desirable in the long run since it confuses the average user (as depicted). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from mfra...@openoffice.org Mon Jan 19 08:31:46 + 2009 --- I tried the same file and the behaviour of my version of open office (OOO 300m9 build 9358) is still very surprising! I have a Dutch localized system, have unchecked the "same as local settings (,)" check box for the decimal separator key (tried also with checking this box, but it makes no difference whatsoever), have no intention to inform the system that I am using anything else than the Default Locale (this is something I can't expect my colleagues to buy!) and my locale dictates this: number: 123 456 789.00 (space separates thousands, dot is decimal separator key) short date notation: 2009-01-19 (dash as date separator key) all right then, the line to be imported is ACCOUNTS CHEM RES;0001-4842;24129;16.214;1.736;148;7.3; in the text import preview this shows as ACCOUNTS CHEM RES | 0001-4842 | 24.129 | 16.214 | 1.736 | 148 | 7.3 when imported it actually gives ACCOUNTS CHEM RES | 0001-4842 | 24129 | 16214 | 1736 | 148 | 2009-03-07 why does that dot in '7.3' get interpreted as a date separator? why does that dot in 24.129 show in the import preview? is the import preview using '.' as thousands separator? how's that? why do the decimal dots in 16.214 and 1.736 disappear in the imported data? please note again that in my system locale I have a space for thousands separator, a dot for decimal separator and a dash for date separator! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from to...@openoffice.org Mon Jan 19 02:37:30 + 2009 --- fijam: After I found a "locale" in my language settings that would replicate the issue shown in your jpg, I found that I could import the file correctly by changing the field type in the import dialog to "US English". As noted before, My US English system imported the file with out issue. Whether your systems language includes the "US English" in the Import Dialog is unknown to me. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from fi...@openoffice.org Sun Jan 18 20:37:42 + 2009 --- Indeed, it does not. I attached a screenshot to better illustrate the problem. Windows XP SP3, OOO300m9 build:9358 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from fi...@openoffice.org Sun Jan 18 20:37:03 + 2009 --- Created an attachment (id=59461) screenshot - conversion to dates - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from to...@openoffice.org Sun Jan 18 15:02:37 + 2009 --- fijam: The file you provided does not contain any dates. It imports properly in OOO2.4.1 and OOO300m9 on Vista. Need better information: OS, OOO version, and file that does not import properly. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from fi...@openoffice.org Sun Jan 18 14:12:51 + 2009 --- This is ridiculous. I just wasted 45 minutes of my time trying to open a single file with semicolon-separated values in Calc only to find out that it is impossible. Well, it is technically possible, but the data are useless. Trying to change the cell's data format from "date" to standard numeral is hopeless either, because the value itself is changed, not just its representation. Here is the file, for your own amusement: http://fijam.eu.org/other/jcr_recs.txt I can't see how this could have got past any Q&A team. I ended up writing a python script to parse my file into something useful. Productivity, right. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 User andr55 changed the following: What|Old value |New value CC|'cornouws,discoleo,er,paga|'andr55,cornouws,discoleo, |lmes,thing' |er,pagalmes,thing' --- Additional comments from and...@openoffice.org Mon Jan 12 03:23:08 + 2009 --- To me, the issue seems to be best described as turning off date/time recognition, at least for dates and/or times that are not properly formatted. Maybe the best way to do this is add a more detailed date/time recognition format, where all permissable formats are enumerated in detail. (Something like for normal number formats, but separately.) And adding the option of permissive date format, and maybe permissive time format, where alternate separators could be accepted. e.g. for date one could have : yy/mm/dd mm/dd yy-mm-dd /mm/dd would only accept as dates strings such as 09/02/22 (as 2009/02/22) or 09/21 (as 2009/09/21) or 08-11-23 (as 2008/11/23) or 2007/05/25, but not 2007-05-25 unless the permissive flag is set (wrong separator) (These examples all being in order year-month-day. Other orders could be used.) Similarly for time. An option to use system defaults would be useful, with the same option for permissive separators. Thus for those who wish to avoid auto-format of dates, one could select system defaults in non-permissive mode, or even no formats (no system defaults and empty list of formats) (My personal option would be probably be the last.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 User er changed the following: What|Old value |New value CC|'cornouws,discoleo,pagalme|'cornouws,discoleo,er,paga |s,thing' |lmes,thing' Summary|Ability to turn off Number|Ability to turn off Number | Recognition in Calc | Recognition for incomplet | |e dates in Calc --- Additional comments from [EMAIL PROTECTED] Wed Sep 3 11:25:31 + 2008 --- You don't want to turn off number or time recognition, but incomplete dates. Adapted summary. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]