https://bugs.documentfoundation.org/show_bug.cgi?id=92915
raal <r...@post.cz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |r...@post.cz Ever confirmed|0 |1 OS|Windows (All) |All --- Comment #25 from raal <r...@post.cz> --- When opening file Kasse SV 2015_Test-Copy.xlsx in excel 2010 I get error "excel found unreadable content, recovery ... etc." After recovery is file opened. File Kasse SV 2015_Test-Copy.xlsx, Sheet Auswertungen, Cell D28 LO: =SUMIFS(Betrag;[0]!konto;2110;VA;"M") excel 2010: =SUMIFS(Betrag;'Kasse SV 2015_Test-Copy.xlsx'!Konto;2110;VA;"M") => the problem is in reference 'Kasse SV 2015_Test-Copy.xlsx'!Konto - it's reference to the same file. For example cell D29 contain formula =SUMIFS(Betrag;Konto;2110;VA;"G") and this formula is recognized in LO correctly (=SUMIFS(Betrag;Konto;2110;VA;"G")). Konto is named range =Kasse!$D:$D. To "fix" this file you can delete 'Kasse SV 2015_Test-Copy.xlsx'! - so D28 =SUMIFS(Betrag;Konto;2110;VA;"M") Setting as new / formula works in excel, doesn't work in LO. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs