On Tuesday 01 November 2005 17:27, Hendra Tan(Internal Audit, FEED, Medan) wrote: > Hello all, > > I have a problem in linking files (i.e. there is a formula in file > Hatch.ods, cell A4, ='file:///C:/Documents and Settings/hendra/My > Documents/Cost09-05.ods'#$Box.F22+'file:///C:/Documents and > Settings/hendra/My Documents/KK HTC PKU 0905.ods'#$Cost.AC21), then when I > save it in the same file Hatch.ods, I always get the error message that > inform the file can't be save, but in excel everything go without any > problem, please help me,
Hi, I've just tested it using 3 files, and it works. Here's my formula: ='file:///home/fajar/Documents/test1.ods'#$Sheet1.A3+'file:///home/fajar/Documents/test2.ods'#$Sheet1.B5 Make sure that the referenced files are already saved first. -- Fajar Priyanto | Reg'd Linux User #327841 | Linux tutorial http://linux2.arinet.org 00:12:35 up 1:00, 2.6.11-1.1369_FC4 GNU/Linux Let's use OpenOffice. http://www.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
