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

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+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