Ask Your Question
0

formula error office vs calc [closed]

asked 2013-03-28 22:00:27 +0200

chance gravatar image

updated 2013-07-07 16:25:07 +0200

manj_k gravatar image

hi everyone first of all sorry for my bad english...

I have a problem.. I work with 10 files, something like 1 server file and 9 client files linked to the server file to sum the numbers contained in every one

The problem is: if I open one of those with excel and I accept to upgrade everything works but if I do the same with calc it's like I lose formula and I have something like #REF

The same happens if I prepare a file with calc at home and then try to use with office at work where I have both installed but can't use calc with this files

Do you have some good advice??

Tks

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-27 20:16:48.553403

2 Answers

Sort by » oldest newest most voted
0

answered 2013-03-29 09:39:10 +0200

chance gravatar image

it'something like "=\server\directory[file.xls]AF'!$L10"

this works with excel but not with libre office tks

edit flag offensive delete link more

Comments

And how does it look when it is open in LibreOffice?

m.a.riosv gravatar imagem.a.riosv ( 2013-03-29 23:58:21 +0200 )edit

='file://SERVER/SL/file.xls'#$AG.$L14 libre office

='\SERVER\SL[file.xls]AG'!$L14 excel

chance gravatar imagechance ( 2013-04-03 16:36:02 +0200 )edit

The LibreOffice syntax seems right, I can link in my net with the same syntax. Can you open the linked file from LibreOffice?, are Calc and excelI in the same computer with the same user?. I think could be an issue about access rights.

m.a.riosv gravatar imagem.a.riosv ( 2013-04-03 21:13:23 +0200 )edit

sorry but I can't find the link

chance gravatar imagechance ( 2013-04-05 18:00:48 +0200 )edit

calc and excel are in the same pc and with the same user. but with calc I have the error. tks very much

chance gravatar imagechance ( 2013-04-05 18:02:45 +0200 )edit

Try creating the link in calc and see how it looks en excel.

m.a.riosv gravatar imagem.a.riosv ( 2013-04-05 22:04:02 +0200 )edit
0

answered 2013-03-29 00:23:07 +0200

m.a.riosv gravatar image

Maybe the links are made in a non compatible way between applications, or in one which LIbreOffice is not able to translate from a xls file.

Can you show some formula/content links here?

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-03-28 22:00:27 +0200

Seen: 500 times

Last updated: Mar 29 '13