https://bugs.documentfoundation.org/show_bug.cgi?id=168218
--- Comment #9 from Pavel <[email protected]> --- Comment on attachment 203251 --> https://bugs.documentfoundation.org/attachment.cgi?id=203251 Calc spreadsheet with SUBTOTAL example saved in xls format Similar affect SUBTOTAL function, in file saved as XLS Example file where formula in "J6" cell is changed, when file is saved as XLS ODS Original J6 "=SUBTOTAL(9;J7:J21)" XLS format saved J6 "=SUBTOTAL(9;J6:J7)" Effect are in other SUBTOTALS formulas, where cells being added are located below the formula cell. Formula in J50, where SUBTOTAL adds cells placed over formula cell works well. If the XLS file open in LO 25.2.5.2, SUBTOTAL works corectly, same if open in MS Excel 2021 -- You are receiving this mail because: You are the assignee for the bug.
