Bug 74004 - SUMIF() doesn't work with references in a range from a linked CSV file.
Summary: SUMIF() doesn't work with references in a range from a linked CSV file.
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.3 rc
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-01-24 00:41 UTC by m_a_riosv
Modified: 2015-01-22 21:25 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
File sample with formulas (26.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-24 00:41 UTC, m_a_riosv 		Details
Linked CSV file (312 bytes, text/csv)
2014-01-24 00:43 UTC, m_a_riosv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2014-01-24 00:41:16 UTC 
Created attachment 92704 [details]
File sample with formulas

Opening the attached ods file (csv attached in the next comment) in:
Version: 4.2.0.3 Build ID: c63c03decdf780d8fb80823950665b782ec9ecd0
also with:
Version: 4.3.0.0.alpha0+ Build ID: 77637324abc193d831bb4a0fa6f9a91ef3601960
         TinderBox: Win-x86@39, Branch:master, Time: 2014-01-22_16:19:04


Selecting Yes to update the link, SUMIF() with references to the range linked to CSV data gives 0.
Formulas with reference to the NotLinked sheet works properly.

Regression from:
Version: 4.1.6.0.0+ Build ID: 873be8f3ff28fd06b531b17d2c7cc41cbc1385e
Comment 1 m_a_riosv 2014-01-24 00:43:30 UTC 
Created attachment 92705 [details]
Linked CSV file

Linked CSV file.
Comment 2 m_a_riosv 2014-02-01 16:42:54 UTC 
Please Kohei, could you take a look.

Still in 4.2.0.4/4.2.1.0.0+/4.3.0.0.alpha0+2014-01-31_00:56:43, several patches for solve other recalculation issues haven't solved this one.