[libreoffice-users] A function doesn't work on cell whihc is a link to another cell

Hi, 

Grade_CellBehavior.ods
<http://nabble.documentfoundation.org/file/n4061013/Grade_CellBehavior.ods>  

In the uploaded Calc file 'Grade_CellBehavior.ods' the column AE and BH are
just simple cells with number values.

The Sheet '1.'  in this file is a sheet from another, bigger Calc file (
called here 'file1' ) in which I have such sheets for every pupil.

I have also a Calc file 'file2' in which I have too such columns, as AE and
BH, but cells in these columns are not just cells with number values, but
links for 'file1'.

So, in the school I fill out the cells in the 'file1' file, come home, copy
the 'file1' into approppriate directory, open the 'file2' Calc file and get
the values into it from 'file1' automatically.

I hope this is cleare so far. 

As one can see in 'Grade_CellBehavior.ods' when one change the value '3' in
AE6 to value '2' then the value in AD6 changes automatically to value "!?".
This shows me that that a teacher closed the grade for that Subject badly.

But this doesn't work in the 'file2', because eg. the value in AE6 is not
just a number, but a value that we get is a link from 'file1'.

I hope this is clear. 

How can I solve this to works in the 'file2' too?



-----
Best Regards from
Pál
--
View this message in context: 
http://nabble.documentfoundation.org/A-function-doesn-t-work-on-cell-whihc-is-a-link-to-another-cell-tp4061013.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted