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+unsubscr...@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