Функция "Открыть файл удаленно" отлично организованна и открывает файлы на удаленных серверах, но при ссылке на такой файл в другой книге Calc результат не возвращается. Было бы отлично, если бы можно было ссылаться на файлы хранящиеся на серверах, точно так же как это сделанно локально. пример: ='file:///E:/Exempl/XXX.ods'#$'1'.A1 возвращает значение ячейки A1 на листе 1 в книге XXX.ods в папке EXEMPL. даже без явного открытия файла XXX.ods НО ='vnd.libreoffice.cmis://XXX@gmail.com@https:%2F%2Fwww.googleapis.com%2Fdrive%2Fv2%23GoogleDrive/XXX.ods'#'1'.A1 возвращает значение #ССЫЛ! даже при открытом файле XXX.ods c сервера Google Drive
Gloss'd using Google translate... The "Open file remotely" perfectly organized and opens files on the remote server, but when you link to the file in another book Calc nothing is returned. It would be great if you could refer to files stored on servers in the same way as it is made locally. example: = 'File: /// E: /Exempl/XXX.ods'#$'1'.A1 returns the value of cell A1 on sheet 1 in the book XXX.ods in EXEMPL folder. even without explicitly opening the file XXX.ods BUT = 'Vnd.libreoffice.cmis: //XXX@gmail.com@https:% 2F% 2Fwww.googleapis.com% 2Fdrive% 2Fv2% 23GoogleDrive / XXX.ods' #' 1'.A1 returns #REF! even with file XXX.ods c Google Drive server
Hi everyone, I have a similar situation. I have one book whit two sheets, one of them have the formulas to the other sheet and I can see all the results that I wish, but when I copy this sheet to another book, I get an error 504. I will attach an image that show my problem and the file if you need it.
Created attachment 135779 [details] This is the image
Created attachment 135780 [details] This is the file If you take this file and move or copy the sheet "Mensual" to another file all the results will be "Error 504" And I have no idea why. In addition, when I save the new file and use Excel to open it, it will show a message informing that the source of external link is missing and I can select again the file source and excel will be correct all the link and after that it will be ok.
Sounds like a reasonable request so setting to NEW. Emersson's issue is completely unrelated to this, so I marked the comments as off-topic.