Skip to main content

Index and project dashbook

The index is a spreadsheet available here.

Popular posts from this blog

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...
Post a Comment
Read more

Networking using OpenSSH

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 networking the Windows 10 machine to the Linux Mint machine. Environment & required functionality The network should be a local network - to share files and folders - between the following machines: The Linux Mint Xfce 18.3 laptop " Gandalf "; The Windows 10 laptop " Legolas ". The network is a local area network from a domestic router, the usual 192.168.x.x thing. This is the second attempt to share files and folders between Windows and Linux Mint. Thankfully, this attempt met the core objectives. Alternatives As with the first (failed) attempt , peer-to-peer networking (file sharing, simple two-way server-and-client relationship) is the most efficient way for bulk data transfers, so if the network doesn’t work, then the test has failed. Software selection Both machines needed to have ne...
Post a Comment
Read more

WPS Office Spreadsheet v Excel: at last, one that works!

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 finding a spreadsheet package that handles existing data - over 10 years-worth of data - to migrate from Windows to Linux.  LibreOffice failed to meet the required functionality , resulting in the project being downgraded.  Time became available to test WPS Office, the result of which is that the project may continue. Environment & required functionality Excel-like functionality - in particular the use of linked workbook references in formulae such as SUMIF() - needs to be used on the following machines: The Linux Mint Xfce 18.3 laptop " Gandalf "; A Linux Mint Xfce 18.3 virtual machine " Gimli "; The Windows 10 laptop " Legolas ". The synchronisation agent is Google Drive in Windows 10, and either grive2 or google-drive-ocamlfuse in Linux Mint. This test focussed on spreadsheets, with n...
Post a Comment
Read more