Bug 103739 - Allow references to remote files
Summary: Allow references to remote files
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.3.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CMIS
  Show dependency treegraph
 
Reported: 2016-11-06 20:00 UTC by grions
Modified: 2018-06-21 17:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
This is the image (254.71 KB, image/png)
2017-08-24 22:52 UTC, Emersson Augusto Suarez Ortiz
Details
This is the file (19.59 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-08-24 22:57 UTC, Emersson Augusto Suarez Ortiz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description grions 2016-11-06 20:00:07 UTC
Функция "Открыть файл удаленно" отлично организованна и открывает файлы на удаленных серверах, но при ссылке на такой файл в другой книге 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
Comment 1 V Stuart Foote 2016-11-06 23:40:31 UTC
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
Comment 2 Emersson Augusto Suarez Ortiz 2017-08-24 22:51:21 UTC Comment hidden (off-topic)
Comment 3 Emersson Augusto Suarez Ortiz 2017-08-24 22:52:29 UTC Comment hidden (off-topic)
Comment 4 Emersson Augusto Suarez Ortiz 2017-08-24 22:57:00 UTC Comment hidden (off-topic)
Comment 5 Buovjaga 2018-06-21 17:55:10 UTC
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.