Ask Your Question
0

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

asked 2013-08-05 09:30:17 +0200

icebear1981 gravatar image

updated 2013-08-05 14:28:26 +0200

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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-05 23:09:04.241613

Comments

@icebear1981,

What format are you using for your spreadsheets?

qubit gravatar imagequbit ( 2013-08-05 15:06:58 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-08-05 15:58:37 +0200

m.a.riosv gravatar image

updated 2013-08-05 15:58:58 +0200

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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-08-05 09:30:17 +0200

Seen: 79 times

Last updated: Aug 05 '13