| Summary: | SUMIF() doesn't work with references in a range from a linked CSV file. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | m.a.riosv <mariosv> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED FIXED | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | libreoffice |
| Version: | 4.2.0.3 rc | Keywords: | regression |
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: |
File sample with formulas
Linked CSV file |
||
Created attachment 92705 [details]
Linked CSV file
Linked CSV file.
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.
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