Bug ID: 115841
           Summary: sumif across multiple sheets using named range not
           Product: LibreOffice
           Version: release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc

I have a workbook which works in MS Excel 2013. But not working in LibreOffice.
This workbook has following sheets
1. Summary sheet with contains list of all items to be procured.
2. Multiple sheets for each products being manufactured. One sheet for each
Working of this workbook:-
Each individual product sheet has bill of material which has all the component
used in that product. Each product has many component common to many other
products. I populate all the individual product sheet with required quantity.
Then I have a summary sheet which has list of all components used in all the
products being manufactured. In this sheet requirement of all the components
used in all the products is calculated. Basically sumif across multiple sheets.
The formula used in MS Excel 2013 
where Products, Range, Sum_Range is a named range.  

Actual Results:  
It is summing a item from only one/first product workbook

Expected Results:
It should sum a item used in all product worksheet

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/61.0.3163.100 Safari/537.36

You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list

Reply via email to