1. garryknight's Avatar
    I'm trying to find a way to share some databases between my PC, my laptop, and my phone, all running Windows 10 or Windows Mobile 10. I like to use LibreOffice for documents and spreadsheets, and especially because the Open Document Format used by LibreOffice supports password-protected files.

    And this seems to be a problem with Excel Mobile. It will open a non password protected .ODS file but when I try to open one that has a password, it says that the file is corrupted. The error message is "Can't open file. Your workbook couldn't be opened because the file is corrupted."

    I take it that Excel Mobile doesn't understand the format. Has anyone had a similar problem and found a workaround? Or do you know of another simple database program I could use in place of LibreOffice spreadsheets?
    Last edited by garryknight; 06-08-2016 at 11:37 AM.
    06-07-2016 04:28 PM
  2. Chintan Gohel's Avatar
    I'm trying to find a way to share some databases between my PC, my laptop, and my phone, all running Windows 10 or Windows Mobile 10. I like to use LibreOffice for documents and spreadsheets, and especially because the Open Document Format used by LibreOffice supports password-protected files.

    And this seems to be a problem with Excel Mobile. It will open a non password protected .ODS file but when I try to open one that has a password, it says that the file is corrupted. The error message is "Can't open file. Your workbook couldn't be opened because the file is corrupted."

    I take it that Excel Mobile doesn't understand the format. Has anyone had a similar problem and found a workaround? Or do you know of another simple database program I could use in place of LibreOffice spreadsheets?
    you haven't tried using MS office?
    06-08-2016 02:58 AM
  3. Dan Harris's Avatar
    Give office a chance, as for fairly basic spreadsheets even Office online works well.

    I think a lot of people don't give the online versions enough credit - It's free to use the online version
    Chintan Gohel likes this.
    06-08-2016 08:52 AM
  4. orlbuckeye's Avatar
    Well almost any cloud service like Google Drive, OneDrive or Dropbox allow you share files. Cloud services require a user name and password to access. We use Google Drive at work and share file we want others to see. You can also give view only or view and update to file you share. So as long as you have the app the file uses on the machines needing access to the files you can use them. Since you have Windows if you save the file to Onedrive you just need to use your MS account and you can view and edit on any device.
    06-08-2016 08:52 AM
  5. garryknight's Avatar
    AMBASSADOR said: "you haven't tried using MS office?"

    I don't have, and can't afford MS Office. I could have used the online one but I need to be able to encrypt and decrypt database files while not connected to the internet.

    Dan Harris said: "Give office a chance, as for fairly basic spreadsheets even Office online works well."

    Yes, thanks for your suggestion.

    orlbuckeye said:
    "Well almost any cloud service like Google Drive, OneDrive or Dropbox allow you share files"

    Sorry, I didn't make myself clear. I have no problem sharing the files. It's encrypting them and decrypting them that's the problem. And as I clarified above, I want to do this when I'm offline as well as online.

    I've actually solved my own problem. I didn't realise that the Office spreadsheet .xlsx format allows me to use a password. So I just keep my databases in .xlsx spreadsheets and both LibreOffice on my PC and laptop, and Excel Mobile on my phone, can both read and encrypt/decrypt them.
    Chintan Gohel likes this.
    06-08-2016 11:37 AM
  6. Bobvfr's Avatar
    I don't have, and can't afford MS Office. I could have used the online one but I need to be able to encrypt and decrypt database files while not connected to the internet.

    .
    I know you have sorted your problem but you did say you couldn't afford Office.

    Have you thought of Office 365, if you have family (Or maybe very good friends) you can get 5 uses of 365 for 79 per year (You will need to look up the dollar price).

    I have 2 of our five, my wife, one daughter and my son have 1 each, for that we get full blown Office including Access, Excel, Outlook, PowerPoint, Publisher and Word (Plus some other bits), also chucked in is 1 TB of OneDrive, and they throw in 60 minutes of Skype credit. And it's always the latest version.

    Don't know about you, but I think this is really good deal.
    06-08-2016 03:38 PM
  7. garryknight's Avatar
    Yes, thanks, I have thought of Office 365. It's just me. And not a lot of money. And not a lot of point since I like LibreOffice.
    Chintan Gohel likes this.
    06-08-2016 04:52 PM
  8. Chintan Gohel's Avatar
    Yes, thanks, I have thought of Office 365. It's just me. And not a lot of money. And not a lot of point since I like LibreOffice.
    office can be costly, especially if all the features you need are also available in other options.
    06-09-2016 01:50 AM

Similar Threads

  1. Windows central photo
    By andrew bainbridge in forum Ask a Question
    Replies: 5
    Last Post: 06-09-2016, 04:48 AM
  2. WM10 Apps Crash
    By Sir Lumia-a-Lot in forum Ask a Question
    Replies: 6
    Last Post: 06-08-2016, 12:17 PM
  3. You can create Microsoft's official Windows Insider t-shirt
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 0
    Last Post: 06-07-2016, 04:00 PM
  4. Amazon pulls Windows Phone app from search, but you can still get it for now
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 0
    Last Post: 06-07-2016, 03:00 PM
  5. Zootopia now available to rent or buy on the Windows Store
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 0
    Last Post: 06-07-2016, 01:42 PM
LINK TO POST COPIED TO CLIPBOARD