WebDav and MSExcel

ℹ️ Support
, ,
1

Hello. There is an error when saving the MS Excel file via WebDAV.
If you select a disk (mounted webdav) in the review and select a folder with a Russian name, then there will be an error about the long path.
If you then open the overview and save it to another as a path, then everything will be fine.

  1. In case of an error:

    image
    image724×475 23 KB

  2. In case of successful saving:

    image
    image770×82 3.59 KB

Perhaps this is due to the fact that the Russian text is written in unicode and it turns out to be a terrible length in the logs. Example: “File accessed: "/\u0430\u0431\u0432\u0433\u0434\u0435\u0451\u0436\u0437\u0438\u0439/\u0424\u0438\u043d\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 23_24.xlsx"”

Sorry for the mechanical translation.

image.translated

2

If you use a path that contains only ASCII characters, there is no problem I suppose?

If you create a file with no-ascii characters, you can open it or write it using Windows webdav (not Word/Excel)?

Like this you can try to narrow down, if you can perhaps fix something on your server, or if there is a different problem.

One thing, when you try to save the file, is there something on your webserver access log?

3

There are no problems when using ASCII.

There are no problems when creating, copying, renaming. Even saving a file via a simple notepad or word, there is no problem. The problem only occurs when saving via Excel using a certain length of Cyrillic letters in the path.

In my opinion, the problem is being solved:
Or by changing the path handling by Windows itself.
Or teach NC to work with Cyrillic.

4

You mean shorter paths are no problem, even cyrillic?

5

/var/www/nextcloud/data/audit.log

"user":"--","app":"admin_audit","method":"OPTIONS","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/","message":"Login attempt: \"n.potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"N.Potapov","app":"admin_audit","method":"OPTIONS","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/","message":"Login successful: \"N.Potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"--","app":"admin_audit","method":"PROPFIND","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/","message":"Login attempt: \"n.potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"N.Potapov","app":"admin_audit","method":"PROPFIND","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/","message":"Login successful: \"N.Potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"--","app":"admin_audit","method":"PROPFIND","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/","message":"Login attempt: \"n.potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"N.Potapov","app":"admin_audit","method":"PROPFIND","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/","message":"Login successful: \"N.Potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"N.Potapov","app":"admin_audit","method":"GET","url":"/remote.php/dav/files/N.Potapov/%D0%9A%D0%BD%D0%B8%D0%B3%D0%B0_1.xlsx","message":"File accessed: \"/\u041a\u043d\u0438\u0433\u0430_1.xlsx\"","userAgent":"Microsoft-WebDAV-MiniRedir/10.0.19044","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"--","app":"admin_audit","method":"OPTIONS","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/123333.xlsx","message":"Login attempt: \"n.potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"N.Potapov","app":"admin_audit","method":"OPTIONS","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/123333.xlsx","message":"Login successful: \"N.Potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"--","app":"admin_audit","method":"PROPFIND","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/123333.xlsx","message":"Login attempt: \"n.potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
"user":"N.Potapov","app":"admin_audit","method":"PROPFIND","url":"/remote.php/dav/files/N.Potapov/%D0%B0%D0%B1%D0%B2%D0%B3%D0%B4%D0%B5%D1%91%D0%B6%D0%B7%D0%B8%D0%B9%D0%BA%D0%BB%D0%BC%D0%BD%D0%BE%D0%BF%D1%80%D1%81%D1%82%D1%83%D1%84%D1%87%D1%88%D1%89/123333.xlsx","message":"Login successful: \"N.Potapov\"","userAgent":"Microsoft Office Excel 2014 (16.0.5404) Windows NT 10.0","version":"27.1.2.1","data":{"app":"admin_audit"}}
6

If the folder + file name has more than 10 Cyrillic characters, it stops working.

7

Looking at the path, because the name is rewritten, this could be the max length limit of 255 characters, no?

I found this:

8

Unfortunately, I have already looked at the information about the “Maximum Path Length Limitation”. I checked regedit and it was already configured correctly.