To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115308
------- Additional comments from [email protected] Wed Nov 10 04:10:31 +0000 2010 ------- I'm afraid you've missed my point. This defect is about *auto-type recognition*. If you don't click 'Auto', of course you won't trigger this bug! If you click 'Auto', then you'll encounter *wrong* behaviour. If you specify 10 max lines for auto-type recognition & OOo actually reads 11 lines, how correct can it be? This behaviour clearly violates the function's spec & needs to be fixed. Pls. be well aware that this defect did not exist in 300m9 if importing from Excel, i.e., if you specify 10 max lines in 300m9 & import from Excel, OOo will only take in 10 max lines for auto-type recognition. In later builds, however, it overshoots. More importantly, as mentioned before, this defect affects the more serious Issue #115420 which *does* result in data loss in certain cases. Pls. fix the current defect ASAP & see how it will change the results of Issue #115420. To help you better understand the scenario, I'm attaching here the test files used in Issue #115420, which incorrectly recognises text to have a date type. Data rows 5 & 10 contain an empty cell in the 'Date' column. You may repeat the current test with whichever sheet in those files with a modified step 5: 5. Set field types: a. Set max lines for auto-type recognition to 10. b. Click 'Auto'. c. Select the 'Desc' field. Note the field type has been incorrectly recognised as 'Date [ DATE ]', which matches the misbehaviour triggered by an empty date cell in the preceding column as described in Issue #115420. d. Repeat steps a-c with max lines = 9. One would expect the 'Desc' column to receive a correct type (Text) this time since data row 9 does contain a valid date in the 'Date' column (& therefore should NOT trigger wrong type recognition). However, we get the same wrong result with 'Desc' set to a date type. e. Repeat steps a-c with max lines = 8. This time 'Desc' has a correct type (Text). f. Repeat steps a-c with max lines = 5. One would expect the 'Desc' column to receive a wrong type (Date) since data row 5 contains an empty cell in the 'Date' column (& therefore should trigger wrong type recognition). However, we get a correct result with 'Desc' set to a Text type. g. Repeat steps a-c with max lines = 4. One would expect the 'Desc' column to receive a correct type (Text) this time since data row 4 does contain a valid date in the 'Date' column (& therefore should NOT trigger wrong type recognition). However, we get a wrong result with 'Desc' set to a date type. h. Repeat steps a-c with max lines = 3. This time 'Desc' has a correct type (Text). The above clearly confirms that auto-type recognition is reading /x/+1 lines of data instead of the specified /x/. If for some reason (e.g., my poor English) this explanation still doesn't seem quite clear to you, then pls. kindly ask someone else to look at it. Collective intelligence is always a good 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: [email protected] For additional commands, e-mail: [email protected]
