https://bugs.freedesktop.org/show_bug.cgi?id=41843
Bug #: 41843
Summary: Mark invalid data mislabels date and time-valued
cells.
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.3 release
Platform: x86 (IA32)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 52388
--> https://bugs.freedesktop.org/attachment.cgi?id=52388
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
--
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
