YouTube Videos

FILTERS:
ALL
Android Devices
Android Mouse
Galaxy TAB S 10.5"
Galaxy TAB S - Rooting
Galaxy TAB S2 8"
Galaxy TAB S4 10.5"
Main N7 Homescreen
Mini PC - MK908
Moto G 2014 - Rooting
Moto G5 Phone
Moto G6 play Phone
Nexus 7 Homescreen
Nexus 7 Tablet
Nexus 9 patch boot failure
Nexus 9 Tablet
Nexus 9 - Rooting
Overheating - Nexus 9
Recap Android TV
SONY Bravia Android TV
Android Apps
Air-Share/Launch Sideload
AnDOSBox
aFreeBox
Chrome Remote Desktop
Cloud - Edit Spreadsheets
Dropbox Cloud Sync
Facebook or Google+
Falcon Twitter Feed
Flashing ROM:s
Hulu outside the US
InstantRemote - WiFi Mouse
iPlayer outside UK
KODI MediaCenter
Pandora outside US
Portal - File Transfers
PushBullet
Recap Android
SMB shares - ES File Mgr
Smart Keyboard Pro
Spotify Mobile
TapaTalk Forums
TV App Repo
WhatsApp without SIM
XBMC MediaCenter
Android-x86
Backup Cloning
Chromecast
Dual Boot MultiBoot
Linux
Messaging IM SMS
Misc. Soc Media
Music Jazz MPB
Remote Controls
Screen Recording
Smart-TV IPTV
USB Flash Drives
Windows

Krister's Blog
krister at hallergard dot com


Last Updated:
2019-07-29
Prev version
Cloud Editing of Spreadsheets

Creating and editing Office files is mainly a job for the PC, but at times I want to do some smaller edits on the Android Tablet (or Android phone), and this is what do:
View Video 3 min

Cloud Apps

I am using three cloud apps: Dropbox, Google Drive and MS OneDrive. For editing Office files I prefer Dropbox for cloud synchronization of (now max free) three of my devices: PC, Mobile phone and Tablet. The main reason is that Dropbox actually downloads the files I want available offline. Google Drive and OneDrive require WiFi to edit on Android devices, which could be inconvenient when travelling.

Office Programs and Formats

I prefer using the free LibreOffice which works fine on Windows and Linux. The Google Apps and MS Office apps do not run on Linux. On Android I use the Google Apps, but in Office compatibility mode.

With LibreOffice I am using the MS Office 2007-2019 formats, xlsx Excel spreadsheets and docsx Word documents. If I were to use the MS Excel app on the tablet to edit files created by LibreOffice as per above, it would sometimes require conversion to a newer xlsx version. This forces me to choose default, and is LibreOffice considering also Linux as per above.

An alternative would be the Google Sheets and Google Docs formats, gsheet and gdoc, but this would sometimes require conversion to the Office formats, especially when sharing.


Office Compatibility


The PC - Windows and Linux

When booting Windows or Linux from another partition than the main one, one has to remember that any edit with LibreOffice will not be synchronized until the main partition is rebooted. And make sure this has happened before editing on the Tablet!

The Tablet - Galaxy TAB S2

To enable synchronization with the Dropbox cloud, each Office file to be made available offline, has to be marked. Dropbox downloads those spreadsheets to this directory:

/Android/data/com.dropbox.android/files/u40850631/scratch/xls

After editing on the tablet I run the Dropbox app to ensure synchronisation.


Offline Availability