[sc-issues] [Issue 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 User nn changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Fri Jul 21 02:06:20 -0700 2006 --- closing duplicate - 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 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 User nn changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Fri Jul 21 02:05:31 -0700 2006 --- The result in J6 is independent of the number format. DAY(1) isn't 1, see issue 26125. Use ROUNDDOWN instead. *** This issue has been marked as a duplicate of 26125 *** - 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 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |dr Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo 2.x --- Additional comments from [EMAIL PROTECTED] Fri Jul 21 00:19:13 -0700 2006 --- Hi Daniel, the problem is the userdefined numberformat in J2 making the result for the day to 1 and converting it to the date 1 which is the 31/12/1899. Frank - 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 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 --- Additional comments from [EMAIL PROTECTED] Thu Jul 20 10:30:21 -0700 2006 --- Rather quiet here. Has this been seen? - 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 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 User bobharvey changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |37783) screendump of same | |file opened in OOo --- Additional comments from [EMAIL PROTECTED] Sat Jul 15 07:19:17 -0700 2006 --- Created an attachment (id=37783) screendump of same file opened in OOo - 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 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 User bobharvey changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |37782) Screendump of this | |file opened in excel --- Additional comments from [EMAIL PROTECTED] Sat Jul 15 07:17:49 -0700 2006 --- Created an attachment (id=37782) Screendump of this file opened in 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: [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 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 User bobharvey changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |37781) Screendump of this | |file opened in excel --- Additional comments from [EMAIL PROTECTED] Sat Jul 15 07:17:45 -0700 2006 --- Created an attachment (id=37781) Screendump of this file opened in 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: [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 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 User bobharvey changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |37780) tiny portion of tim | |esheets extracted to demo | |bug --- Additional comments from [EMAIL PROTECTED] Sat Jul 15 07:16:54 -0700 2006 --- Created an attachment (id=37780) tiny portion of timesheets extracted to demo 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: [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 67399] Results different in calc/ excel - time functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67399 Issue #|67399 Summary|Results different in calc/excel - time functions Component|Spreadsheet Version|OOo 2.0.3 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|bobharvey --- Additional comments from [EMAIL PROTECTED] Sat Jul 15 07:15:42 -0700 2006 --- Enclosed find an excel spreadsheet taken from the timesheet I use at work - the cell with magenta text is normally white and invisible. Also enclosed are two screendumps, one taken from calc and the other from excel. You will notice that the calc example has 31 extra days worked - not an altogether bad thing, if I got paid for it, but I don't. What is going on? (the screen grabs from 2.02 because I have to use portable OOo, but the results are the same in 2.03) - 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]