Bug 74004

Summary: SUMIF() doesn't work with references in a range from a linked CSV file.
Product: LibreOffice Reporter: m.a.riosv <mariosv>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: medium CC: libreoffice
Version: 4.2.0.3 rcKeywords: regression
Hardware: Other   
OS: Windows (All)   
Whiteboard:
i915 platform: i915 features:
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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.