To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63368 Issue #:|63368 Summary:|Bug in Lookup table with Time data Component:|Spreadsheet Version:|OOo 2.0.1 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|TASK Priority:|P3 Subcomponent:|programming Assigned to:|spreadsheet Reported by:|poon_ferrari
------- Additional comments from [EMAIL PROTECTED] Sun Mar 19 04:06:59 -0800 2006 ------- I have found 2 bugs in 2.0.1 Cals (trantition chinese zh-tw version) Bug 1: | A | B | C | D --|------------------------------ 1 | 00:00 | 01:00 | 03:00 | 23:00 2 | 1 | 2 | 3 | 4 3 | 4 | 5 | 00:00 | 4 | Cells A1:D1 are time value (cells formatted as HH:MM) and cells A2:D2 are general values and A1:D2 as a LOOKUP table. Cells A5 is a input field (input a time value) and B5 is a output field. The FUNCTION of B5 is "=HLOOKUP(A5;A1:D2;2;TRUE())" The bug is when A5 input 00:00, the B5 = 1 and then input 23:00 the result = 4. (correct action) but then A5 input 24:00 and hit Enter, A5 was changed to 00:00 (correct), but B5 cannot lookup the correct value 1 and it is still 4. Bug 2: When I copy some data from version 1.1.5 and then paste to 2.0.1 used "Paste As" the 2.0.1 was halted. --------------------------------------------------------------------- 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]