We use Sharepoint Online for our main company document storage and management. When a user opens an Office file (.xls, xlsx, .doc, and docx most commonly) it usually opens into Word or Excel Online. This is fine but limited. Often, the user will have to then go to Edit and then "Edit with Excel (Or Word) and those programs will open up.
The problem is 85% of my users don't use Microsoft Office for anything but basic editing. I AM looking into seeing if just using the Excel and Word online will be sufficient going forward, but it's frustrating to have to buy new copies of Microsoft Office Home and Business for $190-$220 a PC just so they can use this slightly added functionality.
Here is my question -are there any free or cheaper alternatives that will work with Sharepoint Online? I've tried LibreOffice and WPS Office and, while those programs can easily read all of those file types, Sharepoint Online simply doesn't see them as available. If I was to download the file I'm trying to open I could then edit it in WPS Office and then re-upload it, but I'm wondering if there is a way to force Share Point Online to see these other programs and function as if they were opening with Microsoft Office. (The programs are listed as the default application for each file type listed)
I understand Microsoft probably has gone out of their way to not allow a program other than Office proper to work with Sharepoint Online, but if anyone knows of a way to get Sharepoint Online to recognize a different program that would be very helpful as Office 2007 support is ending soon and I will have a very large expense coming up if I can't find a solution. More information below:
Dell PC with Windows 10 Pro
Have tried WPS Office 2016 and Libre Office
See screenshots below for result
Users have Office 365 Subscription K2 or E1 which gives them sharepoint access but not monthly Office 2016 installations