Hi Pál, Please check to see whether the problem can be fixed if you use " Shift + Ctrl + F9 " to recalculate all formulas in the file2.
Good luck and regards from Michael csanyipal 提到: > 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