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: Spreadsheet (show other bugs)
Version: 4.2.0.3 rc
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
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:
i915 platform:
i915 features:

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

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.