| Summary: | Mark invalid data mislabels date and time-valued cells. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Allan Jacobs <jacobsallanster> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED INVALID | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 3.4.3 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Input file used to set up a mix of valid and invalid date and time values.
Data Detective marked too many cells invalid. Screenshot of validated spreadsheet. Validation result, for real. |
||
Created attachment 52389 [details]
Data Detective marked too many cells invalid.
Created attachment 52390 [details]
Screenshot of validated spreadsheet.
Created attachment 52392 [details]
Validation result, for real.
ValidatorOutputDate.ods, attached earlier, is a simple copy of ValidatorInputDate.ods.
Bad validation rules. |
Created attachment 52388 [details] Input file used to set up a mix of valid and invalid date and time values. All cells with date and time values are marked invalid even when they contain valid values. ValidatorInputDate.ods is an unvalidated copy of ValidatorOutputDate.ods. The input was generated as follows. Select range A3:A7 Format Numbers tab Date Format: Dec 31, 1999 Select range B3:B7 Format Numbers tab Time Format: 13:37:46 Select range C3:C7 Format Numbers tab Time Format: 12/31/99 13:37:46 Select range A3:A6 Data->Validity Allow: Date Allow blank cells Select cell A7 Data->Validity Allow: Date Uncheck Allow blank cells Select range B3:C6 Data->Validity Allow: Time Allow blank cells Select range B7:C7 Data->Validity Allow: Time Uncheck Allow blank cells Hand enter data in range A3:C7 Save as ValidatorInputDate.ods Save as ValidatorOutputDate.ods The output demonstrating the bug was generated using the following steps: Open ValidatorOutputDate.ods Select range A3:C7 Tools->Detective->Mark Invalid Data