[sc-issues] [Issue 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103295 --- Additional comments from viren...@openoffice.org Mon Jul 6 17:35:10 + 2009 --- @tomwb: I have tested it in Excel 2007, and this problem does surface. If you require I can attach the sheet. And it doesn't occur in Soffice either. @wope: I am not sure if issue 103213 and this, are one and the same. @jbfaure: I have tried all, i.e. writing into spreadsheet, copying from a text editor, and pasting in html format etc. etc. All show the same results. As far as using a workaround is concerned, well, people need a work around, when there is an issue / defect / problem with the usual functioning of the application, which again confirms that this indeed is a defect. Also, as I said earlier, leave alone auto-formatting not sensing the date format correctly, its also about manual formatting not working either !! Do you still prefer not to consider it a defect ? If so, please go ahead and mark it as Not A Defect and feel happy about it. But, I must say that, focus is more here on closing the issue than resolving it, and this way products don't improve. thanks. Viren - 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 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103295 --- Additional comments from viren...@openoffice.org Sat Jul 4 18:40:03 + 2009 --- I would still consider it a defect, since OOO is incorrectly assuming it to be a month in first place, than a date. If the locale is set to EN(US), it shouldn't be that one has to paste the dates always in MM/DD/ format. Secondly, even if OOO assumes that the date is in MM/DD/ format, it should at least allow the formatting to be change when someone manually attempts to change it. Even that isn't happening here. Third, if locale was to control that you put the date always in one particular format, then how has MS Excel or Sun's Soffice got it right ? This problem doesn't occur in soffice or MS Excel. - 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 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103295 User viren297 changed the following: What|Old value |New value Status|RESOLVED |REOPENED Resolution|INVALID | --- Additional comments from viren...@openoffice.org Fri Jul 3 14:14:49 + 2009 --- if the intention of closing the issue is to show off that it was 'resolved' in a record time, then I have no problem with that. But then do not expect that OpenOffice will ever be treated a good quality product, and users like me will be discouraged to further report (and help) issues !! I already mentioned, that I even tried to apply formatting of different kind and there wasn't any effect of that on the row no. 13 and below. - 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 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103295 Issue #|103295 Summary|Date conversion Error while pasting dates in MM/DD/YYY |Y format Component|Spreadsheet Version|OOO310m11 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|formatting Assigned to|spreadsheet Reported by|viren297 --- Additional comments from viren...@openoffice.org Thu Jul 2 19:09:32 + 2009 --- While pasting dates in the DD/MM/ format into a new calc spreadsheet, the dates in the first 12 rows get automatically converted to MM/DD/YY, but the from 13th row onwards, neither the dates convert automatically nor do they convert even on applying specific formatting on them: Sample Inputs dates: 01/06/2009 02/06/2009 03/06/2009 04/06/2009 05/06/2009 06/06/2009 07/06/2009 08/06/2009 09/06/2009 10/06/2009 11/06/2009 12/06/2009 13/06/2009 14/06/2009 15/06/2009 16/06/2009 Erroneous Output: 01/06/09 02/06/09 03/06/09 04/06/09 05/06/09 06/06/09 07/06/09 08/06/09 09/06/09 10/06/09 11/06/09 12/06/09 13/06/2009 14/06/2009 15/06/2009 16/06/2009 - 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