Chris 
In this post we will look at how to use Google Sheets conditional formatting to change the colour of cells based on the given date. Here’s an example of what we will achieve: The conditional formatting rules I have applied here are: And it’s actually much easier than you might think (and easier than I … Read more
Continuing with learning C#, lately I have been diving into interacting with the Chat GPT API from my C# command line applications. This was my first experience with working with JSON in C#, and in particular I wanted to convert the JSON response from Chat GPT into one (or more?) C# objects. This does, however, … Read more
When switching from Dot Net 6 to Dot Net 7 on Ubuntu, I found that the Dot Net manual installation process went fine, but JetBrains Rider was less than happy with the result. After upgrading, and changing my project to build for Net7, I got the following error when trying to run the project in … Read more
Until now I’ve been getting by right enough running .net version 6.0 on Ubuntu. However, today I wanted to use raw string literals, aka “”” quoted multi line strings: This involved installing .net 7.0 on Ubuntu, which was pretty easy honestly: And then: With that done: I then restarted Rider, and saw that it had … Read more
I made a previous post about how you can use a couple of actions built into Google Sheets to help you delete empty rows for a given column. In that post I got a comment asking if it’s possible to automate the deletion in some way. It is. And to do that, one way would … Read more
Today I faced an issue where I was copy / pasting rows from a LibreOffice Calc spreadsheet document into a new Google Sheets spreadsheet. The problem I faced was when I did this, I retained all the empty rows / gaps in between that I didn’t want. Here’s a basic example of what I started … Read more
Today I hit on an issue whereby I tried to bring up a new Docker project, using a named network, and hit the following error: Which isn’t the most helpful thing in flagging that I had hit the default maximum number of networks that a Docker host can have active. There’s a potential quick fix … Read more
Today I needed to reset a user’s password on a WordPress blog which uses MySQL as its backing database. The WordPress blog, the MySQL database, and the NGINX server are all running on the remote server via Docker. More specifically they use a docker-compose.yaml file. How this docker-compose.yaml file looks is not super important, but … Read more
In learning C# I have resisted using Windows, continuing to use Linux (Ubuntu) for all my software development, which in this case is no doubt holding me back in ways I do not yet even realise. For my C# coding I am using JetBrains Rider IDE. Having already installed the Dot Net Core runtime and … Read more
One really nice thing about C# is that it seems to cover many, many bases. I had heard about Xamarin in the past and was looking into whether it is a good choice for a simple mobile app idea I have that I’d like to explore. Well, it turns out Xamarin is deprecated, to be … Read more