Created attachment 52398 [details] Input file that can be used as feed for data detective test. Tools->Detective->Mark Invalid Data marks some valid integer-valued cells as invalid. ValidatorInputNumber.ods was generated by hand-inserting headers and cells in the range A3:B11. Then Select cell range A3:C11 Right click Format cells... Numbers tab Category Number Format -1234 Select cell range D3:D11 Right click Format cells... Numbers tab Category Number Format -1234.12 Select cell range E3:E11 Right click Format cells... Numbers tab Fraction Format -1234 1/8 Select cell range F3:F11 Right click Format cells... Numbers tab Scientific Format -1.23E+03 Select cell range A3:C10 Data->Validity... Criteria tab Allow: Whole Numbers Allow blank cells Between -100 and 100 Select cell range D3:F10 Data->Validity... Criteria tab Allow: Decimal Numbers Allow blank cells Between -100.00 and 100.00 Select cell range A11:C11 Data->Validity... Criteria tab Allow: Whole Numbers Disallow blank cells Between -100 and 100 Select cell range D11:F11 Data->Validity... Criteria tab Allow: Decimal Numbers Disallow blank cells Between -100.00 and 100.00 Cell C3 has formula =A3/B3 Cells in C4:C11 have formulas derived from that of C3 using the fill tool. Cell D3 has formula =A3/B3 Cells in D4:D11 have formulas derived from that of D3 using the fill tool. Cell E3 has formula =A3/B3 Cells in E4:E11 have formulas derived from that of E3 using the fill tool. Cell F3 has formula =A3/B3 Cells in F4:F11 have formulas derived from that of F3 using the fill tool. ValidatorOutputNumber.ods was generated from ValidatorInputNumber.ods as follows: Copy ValidatorInputNumber.ods to ValidatorOutputNumber.ods Open ValidatorOutputNumber.ods in Calc Select range A3:F11 Tools->Detective->Mark Invalid Data The valid rows marked invalid are in cells C4, C9, and C10.
Created attachment 52399 [details] Output after data detective has finished validating.
Created attachment 52400 [details] Screenshot of output.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
I see the effect, but IMHO Detective works correct. I open reporter's sample document and see the red mark around C4, but not around C3 a) Validity criteria for both cells is "integer" between -100 and 100 b) Contents of C3 = 2/1 = 2 is valid c) Contents of C4 = 3/2 = 1,5 is INvalid Because of formatting "0 decimals" no decimals are shown, but contents of C4 is not an integer d) situation changes when in Tools -> Options -> Calc -> Calculate - Precision as shown' will be checked. Then the circle around C4 will no longer appear, because now C4 IS an integer number I did my tests with Server Installation of "LibreOffice 3.6.0.2 rc German UI/Locale [Build-ID: 815c576] on German WIN7 Home Premium (64bit) @Allan Jacobs: Can you help with some clarification? If you think that a mark as invalid is wrong, please substantiate your point of view for that particular cell.
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian