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
