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.
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
Keywords: regression
Depends on:
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:

File sample with formulas (26.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-24 00:41 UTC, m_a_riosv
Linked CSV file (312 bytes, text/csv)
2014-01-24 00:43 UTC, m_a_riosv

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: Build ID: c63c03decdf780d8fb80823950665b782ec9ecd0
also with:
Version: 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: 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, several patches for solve other recalculation issues haven't solved this one.