Issue 14975

Summary:	Date processing is iffy on imported files using =sumif()
Product:	Calc	Reporter:	lduperval <lduperval>
Component:	code	Assignee:	oc
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 Beta2
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description lduperval 2003-05-27 17:09:58 UTC

I've got some data that is exported from a database and which I import in a
spreadsheet. I'm using the sumif() function to do calculations based on date
values and for some reason, my file does not recognize dates as being the same.
For example, in the attached file, Calc never recognises the dates after April
27, even if the date is cut and pasted from the cell in column A.

I'm attaching the faulty document and the imported CSV file.

Comment 1 daniel.rentz 2003-05-28 06:45:57 UTC

double

*** This issue has been marked as a duplicate of 14974 ***

Comment 2 daniel.rentz 2003-05-28 06:46:10 UTC

double->closed