Bug 41841 - Mark invalid data mislabels numbered-valued cells.
Summary: Mark invalid data mislabels numbered-valued cells.
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-16 13:43 UTC by Allan Jacobs
Modified: 2011-10-16 15:20 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Input for the data detective to validate. (8.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-10-16 13:43 UTC, Allan Jacobs 		Details
Spreadsheet of number-valued cells after validation. (9.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-10-16 13:43 UTC, Allan Jacobs 		Details
Screenshot of validated spreadsheet. (105.50 KB, image/png)
2011-10-16 13:44 UTC, Allan Jacobs 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Allan Jacobs 2011-10-16 13:43:01 UTC 
Created attachment 52383 [details]
Input for the data detective to validate.

Tools->Detective->Mark Invalid Data marks most valid number-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:C11
Data->Validity...
Criteria tab
Allow: Whole Numbers
Allow blank cells

Select cell range D3:F11
Data->Validity...
Criteria tab
Allow: Decimal Numbers
Allow blank cells

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
Comment 1 Allan Jacobs 2011-10-16 13:43:43 UTC 
Created attachment 52384 [details]
Spreadsheet of number-valued cells after validation.
Comment 2 Allan Jacobs 2011-10-16 13:44:35 UTC 
Created attachment 52385 [details]
Screenshot of validated spreadsheet.
Comment 3 Allan Jacobs 2011-10-16 15:20:27 UTC 
My mistake.  The validation rules were not correct.