Skip to main content

Posts

Downgrading of the project: Calc has a fatal bug - it cannot reliably link workbooks

The project is to build a Linux Mint machine to have the identical functionality and ergonomics as the existing Windows 10 machine. This stage relates to on-going work to make LibreOffice Calc workable. Unfortunately, it turns out that LibreOffice isn't fit for purpose.  Specifically, it cannot reliably link workbooks, even in its own native workbooks. As a consequence, the project is now downgraded.  My time is now better spent doing other, more productive things, with a greater chance of success. Background On 29Jul2018, I complied a detailed test using fresh, sample data created specifically for the purpose, in Excel on Windows 10, then had a virtual machine running LibreCalc on Linux Mint to import it. The basic spreadsheet functionality of linked workbooks failed haphazardly. I logged the test results on 29Jul2018 on AskLibreOffice  and, to date, have yet to see any evidence of anybody taking ownership of recognising the issue and thus fixing it. The s...

Googe Drive Backup & Sync (more like Google File Steam): ocaml-fuse

The project is to build a Linux Mint machine to have the identical functionality and ergonomics as the existing Windows 10 machine. This stage relates to Google Drive. Environment & required functionality Google Drive needs to be used on the following machines: The Linux Mint Xfce 18.3 laptop " Gandalf "; The Windows 10 laptop " Legolas "; The Linux Mint Xfce 19 virtual machine " Bilbo ", on host Windows 10 laptop " Saruman " (that's the employer's laptop, by the way; the clue's in the name). The Linux Mint Xfce 18.3 virtual machine " Gimli ", on host "Legolas". Another Windows 10 machine, name withheld to protect the guilty. The synchronisation agent is Google Drive in Windows 10.  In a prior test , the sync agent has been grive2. But grive2's functionality was too limited: files held in more than one folder in Google Drive cloud are symbolic links to the synchronisation agents installed on...

Case-in-use study: filing a UK tax return online

The project is to build a Linux Mint machine to have the identical functionality and ergonomics as the existing Windows 10 machine. This is a case-in-use study.  The case-in-use relates to the online filing of a UK tax return. Environment & required functionality This case-in-use study featured the following machines: The Linux Mint Xfce 18.3 laptop " Gandalf "; The Windows 10 laptop " Legolas "; A Linux Mint Xfce 18.3 virtual machine " Gimli " running within VirtualBox on Legolas. The synchronisation agent is Google Drive in Windows 10, and grive2 in Linux Mint. This case-in-use study featured the following apps: Chromium internet browser (on Gimli); Google Chrome internet browser (on Gandalf and Legolas); FoxIT PDF browser (on Gandalf and Legolas); Xreader document viewer (on Gimli, pre-installed in Linux Mint); GIMP image editor (on Gandalf, pre-installed in Linux Mint); the printer service. Alternatives The sole alternati...

Re-filing files

The project is to build a Linux Mint machine to have the identical functionality and ergonomics as the existing Windows 10 machine. This stage relates to re-filing files. Environment & required functionality Re-filing needs to happen on the following machines: The Linux Mint Xfce 18.3 laptop " Gandalf "; The Windows 10 laptop " Legolas ". The synchronisation agent is Google Drive in Windows 10, and grive2 in Linux Mint. Alternatives There is no useful alternative to filing. Some hardcore IT bods file nothing, in the vague hope that they'll find it anyway.  This is the digital equivalent of the "heap" approach to paperwork. In the real world, normal people tend to structure their paperwork - and e-paperwork - into some sort of order.  The most common method is typically to group documents with a common purpose into a single folder. Software selection Whilst there is a tonne of utilities for both Linux and Windows that rename fil...

Google Earth

The project is to build a Linux Mint machine to have the identical functionality and ergonomics as the existing Windows 10 machine. This stage relates to Google Earth. Environment Google Earth needs to be used on the following machines: The Linux Mint Xfce laptop " Gandalf "; The Windows 10 laptop " Legolas "; Another Windows 10 machine, " Albertsquare ", used exclusively by another user. The synchronisation agent is Google Drive in Windows 10, and grive2 in Linux Mint. Because of the known limitation in scope, another Linux Mint machine was created, named " Gimli ".  Gimli is a Linux Mint Xfce 18.3 Sylvia 32-bit virtual machine running in Oracle VirtualBox on Gandalf. Required functionality Google Earth is a useful desktop-based tool by which to design walking routes, to capture results of the pilot walk and to document required changes to the route's design. The routes range from 6 miles to 12 miles and use  public rights ...

No burning through the data allowance

An unexpected result! My internet service went down yesterday, so I ended up facing the prospect of going internet cold turkey for a night, getting close to the desperate level of giving up and reading a book. At the last minute, it occurred to me to test whether the Linux Mint machine ("Gandalf") would connect seamlessly to a new wifi device (an Android hot spot).  And, because the device is metered, it gave me the chance to have a feel for Gandalf's data consumption. Findings Gandalf connected seamlessly to the new wifi device. Upon checking the wifi useage meter the following day, I saw that in the month to end 29 June 2018, the total data transmitted was 0.31Gb (of an allowance of 2Gb). Obviously, there's no useful comparable.  The Android normally connects to a wifi connection, so is  seldom on the mobile data network.  This means that the bulk of the 0.31Gb was consumed by Gandalf. The use of Gandalf was to grive data twice, with ten internet sessi...

Dual monitors

Whereas Windows 10 assumes auto-detection of a secondary monitor to be on, Linux Mint Xfce assumes that it is off. In Linux Mint Xfce, menu > display > "configure new displays when connected" = on .  Plug in the monitor, follow the screen.  Dead easy. Completed Jun2018.