#REF! between MSOffice an LOffice (Diff. characters . / !)

[icebear1981]

hi there, is ther anyone who could help me with a problem between libreoffice and MS office ?? =INDIREKT(“Essensliste!C”&+C20+2) makes a #REF! in LOffice and =INDIREKT(“Essensliste.C”&+C20+2) makes it correct in LOffica but gets an #REF! in MSOffice

[qubit1]

@icebear1981,

What format are you using for your spreadsheets?

[mariosv]

Hi @icebear1981,
The issue is with the name sheet separator “.” in LIbreOffice and “!” in Excel, we need to find a way that works in both.
Construct the address with the function I think must work, but I have not excel to verify:
=INDIRECT(ADDRESS(C20+2;3;1;1;“Essensliste”))
remember translate in your language the function names.