Bug 86220 - LO Calc <> MS Excel cell addressing incompatibility
Summary: LO Calc <> MS Excel cell addressing incompatibility
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.3.1 rc
Hardware: Other All
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-12 20:36 UTC by Johannes Obermayr
Modified: 2014-11-12 22:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Johannes Obermayr 2014-11-12 20:36:47 UTC 
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: ! <> .
Comment 1 m_a_riosv 2014-11-12 22:04:15 UTC 
Hi @Johannes, thanks for reporting.

You can use the option in Menu/Tools/Options/LibreOffice calc/Formula - Formula Options - Formula sintax - Excel A1.

Dot is the sheet separator in LibreOffice and in their predecessor from the origin, I'm sure it won't be changed.