I’m using owncloud 10.1.1.1 server, and accessing my excel files (csv, xlsx) using webdav in windows 10.
But the excel app cannot display anything (blanks).
Steps to reproduce
- install owncloud in debian stretch in odroid c2
- define local storage which connect to external hard drive
- map drive to the storage using windows 10 laptop
- open the folder in windows explorer
- double click the excel file to view the content using microsoft excel
- microsoft excel app open but did not show anything
Expected behaviour
File content shown in microsoft excel
Actual behaviour
File content not show in microsoft excel (blanks)
Server configuration
Operating system: Debian 9.12
Web server: Apache
Database: MariaDB 10.1.44
PHP version: 7.0.33-0+deb9u7
ownCloud version: 10.1.1.1
Updated from an older ownCloud or fresh install: fresh install
**The content of config/config.php:**
https://github.com/alexissinglaire/odroidc2owncloud/blob/master/config.json
Log in to the web-UI with an administrator account and click on
‘admin’ -> ‘Generate Config Report’ -> ‘Download ownCloud config report’
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.
or
If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder
ATTENTION: Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove all host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.
**List of activated apps:**
If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.
**Are you using external storage, if yes which one:** local/smb/sftp/...
**Are you using encryption:** no
**Are you using an external user-backend, if yes which one:** no
#### LDAP configuration (delete this part if not used)
With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder
Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM oc_appconfig WHERE appid = ‘user_ldap’;
Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.
### Client configuration
**Browser:**
**Operating system:** Windows 10
### Logs
#### Web server error log
Insert your webserver log here
[04/Apr/2020:08:48:29 +0000] “GET /owncloud/remote.php/webdav/nasstorage1/dummy_data1.xlsx HTTP/1.1” 200 14464 “-” “Microsoft-WebDAV-MiniRedir/10.0.18363”
[04/Apr/2020:08:48:29 +0000] “GET /owncloud/ocs/v2.php/apps/notifications/api/v1/notifications?format=json HTTP/1.1” 200 1114 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36”
[04/Apr/2020:08:48:41 +0000] “PROPFIND /owncloud HTTP/1.1” 301 586 “-” “Microsoft-WebDAV-MiniRedir/10.0.18363”
[04/Apr/2020:08:48:41 +0000] “PROPFIND /owncloud/ HTTP/1.1” 405 743 “-” “Microsoft-WebDAV-MiniRedir/10.0.18363”
[04/Apr/2020:08:48:41 +0000] “PROPFIND /owncloud/remote.php/webdav/nasstorage1 HTTP/1.1” 207 1173 “-” “Microsoft-WebDAV-MiniRedir/10.0.18363”
[04/Apr/2020:08:48:41 +0000] “PROPFIND /owncloud/remote.php/webdav/nasstorage1 HTTP/1.1” 207 1173 “-” “Microsoft-WebDAV-MiniRedir/10.0.18363”
[04/Apr/2020:08:48:41 +0000] “OPTIONS /owncloud/remote.php/webdav/nasstorage1/ HTTP/1.1” 401 1313 “-” “Microsoft Office Excel 2014”
[04/Apr/2020:08:48:41 +0000] “OPTIONS /owncloud/remote.php/webdav/nasstorage1/ HTTP/1.1” 401 1307 “-” “Microsoft Office Excel”
[04/Apr/2020:08:48:41 +0000] “OPTIONS /owncloud/remote.php/webdav/nasstorage1/ HTTP/1.1” 401 1307 “-” “Microsoft Office Excel 2014”
[04/Apr/2020:08:48:41 +0000] “OPTIONS /owncloud/remote.php/webdav/nasstorage1/ HTTP/1.1” 401 1031 “-” “Microsoft Office Excel”
[04/Apr/2020:08:48:42 +0000] “HEAD /owncloud/remote.php/webdav/nasstorage1/dummy_data1.xlsx HTTP/1.1” 401 598 “-” “Microsoft Office Excel 2014”
ownCloud log (data/owncloud.log)
Insert your ownCloud log here