Incorrect Date Detection and Inconsistency

[ibrahim-sadiqi]

Description

The parser inconsistently detects date values, leading to mismatches with Excel behavior.

---

Case 1

• Input: "01.01.01"
• Expected (Excel): Not parsed as a date
• Actual (Library): Parsed as a date

---

Case 2

• Input: "1-1-1"
• Expected (Excel): Parsed as a date
• Actual (Library): Not parsed

---

Notes

• Date detection rules are inconsistent and do not align with Excel’s implicit parsing logic
• Separator handling and pattern recognition need refinement
• The parser should better distinguish between valid and invalid date patterns based on Excel behavior