I have written a small spreadsheet app on my PC (windows 10) using LibreOffice calc. This spreadsheet contains three separate sheets within the app, one for individual player scores, a second cross-ref showing who has played who, the last the computed average for each player. I have moved the spreadsheet into a Dropbox folder and use LibreOffice on my PC to update the spreadsheet. The app works exactly as required and tabbing between sheets absolutely no problem.
Now I wanted to be able to display only, (edit Not allowed), the 3 sheets on an android, an iPad, iPhone or another PC. I wrote a blog in wordpress.com and gave the user the option to click a link that pointed directly to the Dropbox file. It worked! The first sheet displayed beautifully on all the devices.
My big mystery is why? None of the tablet devices had wordpress.com, Dropbox or LibreOffice installed. All they had was a browser and a link. How did the device know how to interpret the LibreOffice file in Dropbox?
Bigger mystery was that none of the devices would display sheet 2 and sheet 3. By accident I tried it on a device that happened to have Dropbox installed ( Not LibreOffice or wordpress.com) and strangely enough now I could display all 3 sheets.
I'm not complaining, I've got a superb app that all players can easily access and get up-to-date results with little if any change on their device. Just curious to know how it is working!