https://bugs.freedesktop.org/show_bug.cgi?id=41841
Bug #: 41841
Summary: Mark invalid data mislabels numbered-valued cells.
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.3 release
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 52383
--> https://bugs.freedesktop.org/attachment.cgi?id=52383
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
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
