https://bugs.documentfoundation.org/show_bug.cgi?id=159039
Eike Rathke <er...@redhat.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |er...@redhat.com Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #2 from Eike Rathke <er...@redhat.com> --- (In reply to chris.seiferth from comment #0) > When I open the file in Excel 2016, > the summary sheet counts and displays the data correctly without any errors. > However, when I open the same file with the latest version of LibreOffice > Calc (Windows and Linux) AND strangely the latest version of Microsoft > Excel, I encounter an error in the summary sheet. That also the latest Excel version complains rather suggests an error in the formula syntax that for whatever reason was silently accepted by earlier versions. Fwiw, Err:504 is "Error in parameter list". Can you provide the formula expression where the error occurs first, along with its arguments passed? You can trace errors using Tools -> Detective -> Trace Error on a cell with error. Then on the originating cell use the Function Wizard to inspect what arguments are passed. -- You are receiving this mail because: You are the assignee for the bug.