I'm creating a spreadsheet of Excel using phpExcel() . When placing filters, the result of cell C3 and C4 where subtotal SUBTOTAL() is found looks like this:
No filter
WithFIltro 
Does anyone know why this happens?
I have already tried to change the file for several encodings, including UNICODE-UTF8 , ISO and WINDOWS .
When saving the file to .xls it works but needs to be saved to .xlsx
Sorry, buddy, but you were not very clear when presenting your problem, saying what the problem is and the expected result. However, let me know if this helps you in any way:
The SUBTOTAL () formula is an alternative to traditional formulas such as SOMA (), CONT.VALORES (), AVERAGE () ... when you want to perform operations on a filtered range. As I can verify, your SYBTOTAL () formula is performing a count operation (indicated by '3' in the first argument), so C3 will count all the visible items (not excluded in the filters) of the selected range. I also deduce that the above cell (C2), which has not changed its value in both figures, should have the formula =CONT.VALORES(B7:B878) . In short we have to:
SUBTOTAL(3;intervalo) > it will count the values of intervalo visible. Values hidden by filters are excluded. CONT.VALORES(intervalo) > it will count the values of intervalo , independent there are lines hidden by filters. NOTE: The SUBTOTAL () formula differs only in operations at filter-affected intervals. Manually hidden rows and columns will not have their values excluded from operations, returning identical results to other functions.