When one uses SharePoint's "Export to Excel" feature to export lists, the URI returned by server cannot be open in LibreOffice. The reason is that the resource isn't usual WebDAV document, and its IsDocument property cannot be taken using PROPFIND (the method fails). Also, the data hasn't XML declaration (starting with "<?xml"). The exported list has > Content-Disposition: attachment > Content-Type: application/xml in its HEAD. A patch is submitted: https://gerrit.libreoffice.org/36090
The patch mentioned in comment 0 fixes the WebDAV part (dealing with failing PROPFIND). Another patch (https://gerrit.libreoffice.org/36101) deals with detection of XML files without XML declarations.
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fbc04c97231d629c1b5e9e57203dbe8d8eb06714 tdf#106955: Open WebDAV resources on which PROPFIND fails It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=156f778593ca9c57845076a88c6b544a63e12e7a tdf#106955: Detect XML by MediaType It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Is this issue solved? Also, I guess this is the "Native connector for: SharePoint lists" on the Microsoft office- LibreOffice comparison page?: https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_Microsoft_Office#Spreadsheet_applications:_LibreOffice_Calc_vs._Microsoft_Excel
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/cf64fe2d02dcb7f3126026dc1face21ce3562392 ucb: webdav-curl: tdf#106955: Open WebDAV resources on which PROPFIND fails It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.