https://bugs.freedesktop.org/show_bug.cgi?id=74004

          Priority: medium
            Bug ID: 74004
          Keywords: regression
          Assignee: [email protected]
           Summary: SUMIF() doesn't work with references in a range from a
                    linked CSV file.
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.2.0.3 rc
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 92704
  --> https://bugs.freedesktop.org/attachment.cgi?id=92704&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to