https://bugs.freedesktop.org/show_bug.cgi?id=86220
Bug ID: 86220
Summary: LO Calc <> MS Excel cell addressing incompatibility
Product: LibreOffice
Version: 4.3.3.1 rc
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
on MS Excel I need:
=INDIREKT(VERKETTEN("KW";TEIL(ZELLE("FILENAME");FINDEN("KW";ZELLE("FILENAME"))+2;LÄNGE(ZELLE("FILENAME")))-1&"!A1"))
on LO Calc I need:
=INDIREKT(VERKETTEN("KW";TEIL(ZELLE("FILENAME");FINDEN("KW";ZELLE("FILENAME"))+2;LÄNGE(ZELLE("FILENAME")))-1&".A1"))
To make the difference short (last part of formula):
Excel: !A1"))
Calc: .A1"))
Difference of first sign there: ! <> .
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
