[sc-issues] [Issue 87999] In "standard" data type cs v import should never convert items with one d ot to dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 --- Additional comments from mfra...@openoffice.org Mon Jun 8 07:32:18 + 2009 --- a possibly relevant link: http://specs.openoffice.org/calc/ease-of-use/enhance_number_recognition.sxw - 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 87999] In "standard" data type cs v import should never convert items with one d ot to dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 --- Additional comments from mfra...@openoffice.org Thu Jun 4 19:29:52 + 2009 --- no-one likes to be called names, that's clear and should be avoided... I assume on the other hand that most of us reporting bugs here are working as advocates of openoffice.org, each of us inside of our respective companies, and we feel the duty to defend something we sometimes don't like and (as in this case) don't understand. please note that issues like this one have been opened and quickly closed as a "works for me" since April 2003 (check http://www.openoffice.org/issues/show_bug.cgi?id=13929), this is over 6 years ago. you maybe can understand some impatience on users' side. any plan to schedule a solution to this for any specific future release? thanks a lot for your attention, Mario Frasca - 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 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 89057] Di3, Ma3, Vr3, all become 2008-05-03 (Dutch system)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89057 Issue #|89057 Summary|Di3, Ma3, Vr3, all become 2008-05-03 (Dutch system) Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|mfrasca --- Additional comments from [EMAIL PROTECTED] Tue May 6 08:41:26 + 2008 --- I have a Dutch version of Windows, on this I have installed the English version of OpenOffice 2.4.0 and I have set it to English (Eire) to avoid problems with the '.' being seen as a separator for dates. what is the reason for which importing or typing Ma3 Di3 Wo3 Do3 all result into 2008-05-03 ? I understand that in Dutch Ma-andag = Monday, Di-nsdag = Tuesday, Wo-ensdag = Wednesday, Do-nderdag = Thursday... but then, I don't want automatic interpretation of data and I don't want Dutch to be used by OpenOffice. moreover, the 3rd of May 2008 was a Saturday (Zaterdag in Dutch) so each of the above examples are in error. on my home system (en_DK.UTF-8 locale, English OO) I see the same behaviour for the longer codes Mon1, Tue1, Wed1, etc... all incorrectly translated to 2008-05-01 (a Thursday). - 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]
[sc-issues] [Issue 87999] In "standard" data type cs v import should never convert items with one d ot to dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 User mfrasca changed the following: What|Old value |New value Issue type|ENHANCEMENT |DEFECT --- Additional comments from [EMAIL PROTECTED] Thu Apr 24 05:58:41 + 2008 --- regina, would you agree marking this back as a 'defect' rather than 'enhancement'? 'defect', in the sense of removing/modifying a surprising behaviour, not 'enhancement' in the sense of adding a feature. friendly regards. Mario. - 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]
[sw-issues] [Issue 4579] Special Character Shortcuts
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4579 User mfrasca changed the following: What|Old value |New value CC|'asrail,gudmund,kamataki,m|'asrail,gudmund,kamataki,m |anens,markmushakian,pescht|anens,markmushakian,mfrasc |ra,pmike,redi2go,regina' |a,peschtra,pmike,redi2go,r | |egina' - 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]
[sw-issues] [Issue 4579] Special Character Shortcuts
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4579 --- Additional comments from [EMAIL PROTECTED] Wed Apr 23 16:28:49 + 2008 --- ok, points taken... but just partially... About the frustration: I also have to use windows at office, but then I'm lucky I have to write just in Dutch or English, where the accents are rarely needed... the way Compose works is not dependent on the locale settings, as far as I know. admittedly, there are keys I cannot produce with Compose-key1-key2, like some Vietnamese vocals topped by two or three accents, or all Arabic characters. ... Even if I think I understand frustration and the need for a better solution than something which is only available on Linux and is not at all complete, I still think this should be solved somewhere in the operating system, not in each of its client applications. In my opinion, doing so (offering this option in each client of the OS) leads to a configuration nightmare. I don't know if there are any extensions to Windows (nor to Linux) than enable us to configure our keyboards in a more complete way, but if I were a windows user (or if I needed typing Vietnamese), I would look for something like that, I would not ask openoffice to provide me with something which will only work within openoffice and which I would miss in abiword, emacs and vi. until I find such a tool, I would use your macro, very probably. ciaociao. - 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]
[sw-issues] [Issue 4579] Special Character Shortcuts
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4579 --- Additional comments from [EMAIL PROTECTED] Wed Apr 23 11:37:30 + 2008 --- ... but: is this really a problem within OpenOffice? or isn't it an operating system issue? on Linux, there's no such need: I type Compose ' a and get á, Compose " U -> Ü, Compose / L -> Ł, Compose b a -> ă, Compose ' r -> ŕ... you name them, you learn them... other example? take the small Nokia N810, it's the module of the operating system taking care of handling keyboard input that allows the user to write national characters. keep the 'chr' key pressed and hit the 'a' four times to get the fourth accent available on the 'a'... a bit clumsy, but it also works in all programs. IMHO it really should not be a concern of the application developer to fill in the blanks left by the operating system... I think this is a MSWindows issue, not OpenOffice's. so if you are affected by this issue, you might consider running OpenOffice on Linux... just a hint. :) (obviously the 'Compose' on my keyboard is marked 'Caps Lock'!) - 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]
[sc-issues] [Issue 87999] In "standard" data type cs v import should never convert items with one d ot to dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 --- Additional comments from [EMAIL PROTECTED] Tue Apr 15 11:12:39 + 2008 --- if you are affected by this issue, please vote for it! - 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]
[www-issues] [Issue 1145] Date recognition broken - " feature" should be configurable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1145 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:13:03 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 1145] Date recognition broken - " feature" should be configurable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1145 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:13:03 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 88020] Wrong formatting of dates in CSV import when "Column type" field is disa bled
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88020 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:12:54 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 25201] csv decimal values importe d as date value
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=25201 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:12:50 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 23945] Currency cell converts 3.7 9 to date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=23945 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:12:44 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 23328] Spreadsheet converting tex t to dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=23328 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:12:41 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 23024] CSV import into spreadshee t application: date values instead of numbers
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=23024 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:12:24 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 22725] On french Win2k, typing a decimal number with dot (.) give a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=22725 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:12:21 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 20804] CSV Import: Values >= 1 ar e not recognized as numbers but as date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20804 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:12:17 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 13929] unable to get back to numb er after some kind of autoconvert to date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=13929 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:12:03 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. - 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]
[sc-issues] [Issue 13509] date type autoformat error s
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=13509 --- Additional comments from [EMAIL PROTECTED] Fri Apr 11 07:11:35 + 2008 --- if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 and vote for it. - 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]
[sc-issues] [Issue 87999] In "standard" data type cs v import should never convert items with one d ot to dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 --- Additional comments from [EMAIL PROTECTED] Tue Apr 8 14:17:18 + 2008 --- well, this would be a clear enhancement _for us_, but if a user is using DIN 5008 data prior to the 1995 correction, he might have reasons to complain... as for Leonard, it's the "never" which worries me a bit. I would say "never if the locale does not say date:==dd.mm.", i.e.: "only if the locale explicitly says so". maybe "in case on non match with locale, prefer converting to number above converting to date" I agree with Leonard when he says that it would be nice if we could specify our own date format(s) -overruling the locale- and that input data (imported or typed) is recognized as date if and only if it matches and absolutely not otherwise. if you offered this option, I would define these formats and be happy: dd/mm dd/mm/ -mm-dd - 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]
[sc-issues] [Issue 87999] OOo calc interprets numers as dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 --- Additional comments from [EMAIL PROTECTED] Mon Apr 7 11:58:15 + 2008 --- also check this: http://www.cl.cam.ac.uk/~mgk25/iso-time.html where it is stated that the German format dd.mm.yy(yy) has been obsoleted in May 1995. - 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]
[sc-issues] [Issue 87999] OOo calc interprets numers as dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 --- Additional comments from [EMAIL PROTECTED] Mon Apr 7 11:52:37 + 2008 --- no, I do not instruct OpenOffice to import my data (see original post) as US English and the whole point is that I would like not needing that. the data is not US English data and my colleagues here see this behaviour in OOo as an extra non obvious step as compared to M$Excel. at home I have a linux-powerpc machine, with locale set to 'en_DK.UTF-8' and I don't experience this defect there. here at office they gave me a windows machine (XP), Dutch localized. I installed the English version of OOo 2.4 (same as at home). I don't know where to look, in windows, for the answer to "What is the local setting of your OS?" but I assume it's Dutch (context menus in explorer are in Dutch). the OOo locale is set to Default Is in "Tools>...>Decimal seperator key" the option "Same as local setting" checked? setting or unsetting this option does not alter the behaviour "type/import 1.13 and get 13-01-08" as I see it, my locale settings say that I should type "13-1" to mean 13th of January of the current year. the same setting also say that I should type 13,1 if I mean 13+1/10. so actually the string 13.1 should either be left uninterpreted as a string (does not respect any known format) or if the program wants to be kind and helpful, it could be interpreted as a floating point number, which I believe would be the case in most cases. interpreting it as a date is based on the German format for dates, where the Germans use the '.' to make an ordinal number out of the preceding cardinal number, but the fact is that: 1) both day and month should be followed by that dot in the German notation for dates 2) Dutch, Italian, French, Spanish, are all not German and we all don't understand why 13.1 should mean January 13th at all... I notice that the English (Eire) locale comes quite close to what I expect and I think I can live with this. but I insist that you reconsider the fallback to parsing as date (using a sloppy rule from a different locale) as a default behaviour for unparseable input (which would be parseable as float in the most widespread locale) - 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]
[sc-issues] [Issue 87999] OOo calc interprets numers as dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 User mfrasca changed the following: What|Old value |New value Status|RESOLVED |UNCONFIRMED Resolution|WORKSFORME| --- Additional comments from [EMAIL PROTECTED] Mon Apr 7 10:35:37 + 2008 --- I understand that it is possible to select each of the columns containing numbers like 17.03 and 6.12, inform the importer that the column contains "US English" data, but the problem is: rule for date: dd-mm- rule for number: x,d (but on the same system M$Excel uses x.d) input 17.03 does not respect either. having this interpreted as a date is surprising... I tried with this option: Tools->Options->Language Settings->Languages->Decimal separator key even if I leave it unchecked, it still does not work for me. moreover, this behaviour is not only in the importer but also for typed data. again: really no European would expect 1.13 to mean January 13th... - 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]
[sc-issues] [Issue 87999] OOo calc interprets numers as dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87999 Issue #|87999 Summary|OOo calc interprets numers as dates Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|mfrasca --- Additional comments from [EMAIL PROTECTED] Mon Apr 7 09:47:33 + 2008 --- I have a CSV file holding this line: 20-12-2007,22:44:00,007,24.08,0.0,24.85 the types are, respectively: date, time, string, float, float, float I cannot tell the csv importer that the last three columns are floats, so I leave that as 'standard'. the importer produces these types: date, time, string, date, float, float I am aware that this issue is a duplicate of 23024, but I really have a problem accepting this as a "works for us!"... it's true that the locale of most European languages dictate that ',' is the separator for decimal, but it's only in Germany where the locale dictates that the '.' separates dates! when scalc parses a '24.08' and sees it does not conform to 'decimal' (expecting comma) nor to 'date' (unless in Germany, but then they would write '24.8.', with TWO points, not just one), why don't you just make it choose for decimal? I can assure you that this is the least surprising behaviour for most Europeans!!! thanks a lot for this otherwise beautiful piece of software, running also on my linux-powerpc! - 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]
[sw-issues] [Issue 55482] New - tools-options-view-s cale != 100%
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55482 Issue #:|55482 Summary:|tools-options-view-scale != 100% Component:|Word processor Version:|OOo 1.1.4 Platform:|Macintosh URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|viewing Assigned to:|mru Reported by:|mfrasca --- Additional comments from [EMAIL PROTECTED] Tue Oct 4 23:25:40 -0700 2005 --- when I set the scale to anything else than 100%, the display does not get updated correctly. there are cases where the text does not seem to be updated at all, but at times the remainder of the line being edited just messes up with random patterns. I'm working with wmaker. if I go to an other workspace and come back to the one containing open office, then the text is updated. this happened immediately after installation on Debian GNU/Linux (unstable). I now switched to scale=100%, even though the characters are a bit too small for my taste. I think I could generate a screen dump, is there a place where I can put it? thanks for the great piece of software, Mario Frasca - 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]