Issue 14975 - Date processing is iffy on imported files using =sumif()
Summary: Date processing is iffy on imported files using =sumif()
Status: CLOSED DUPLICATE of issue 14974
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-27 17:06 UTC by lduperval
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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