Bug 74004

Summary: SUMIF() doesn't work with references in a range from a linked CSV file.
Product: LibreOffice Reporter: m_a_riosv <miguelangelrv>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED    
Severity: normal CC: kohei
Priority: medium Keywords: regression
Version: 4.2.0.3 rc   
Hardware: Other   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: File sample with formulas
Linked CSV file

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.