Description: 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 product. 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 =IF($J$1<>"YES",SUMPRODUCT(SUMIF(INDIRECT("'"&Products&"'!"&Range),A3,INDIRECT("'"&Products&"'!"&Sum_Range))),"") 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
Created attachment 139984 [details] Excel file which work in MS Excel 2013, but not in LibreOffice Calc
When looking to your formula and name range, i see in X3 and Y3 only something like A3:A60 C3:C60. These are not formula or name range. I have a 504error. "no reference or text..." see the help file "F1" So for me its not a bug, if you not agree you can still reopen the report
Created attachment 140020 [details] Test file Not clear it is not a bug, seems bidimensional arrays doesn't work, at least when more than one multirange in the formula, although INDIRECT seems to get the right data. Only with COUNTIF seems to work and when the second dimension it's force. Please Eike some advice woul be appreciated.