The Linux Rain Linux General/Gaming News, Reviews and Tutorials

Articles found under tag: spreadsheets

Shifty dates in Microsoft Excel

By

Microsoft has used two different starting points on the calendar for calculating dates in different versions of their Excel spreadsheet program. Really. Microsoft explains the difference here. One version used 1 January 1900 for serial day numbering, the other used 1 January 1904. Of course, up to…

Read Article

Scottish Country Dancing stats

By

My wife has been in the same Scottish Country Dancing group for many years, and back in 2005 she began keeping a record of the dances done at each meeting. She lists a fair bit of information in her "dances done" spreadsheet (screenshot below). She recently asked me "Would it be…

Read Article

Gnumeric: a filter-and-export script

By

My wife likes to organise and store information in Gnumeric spreadsheets. Every now and then she needs to filter her data and save the result to a new spreadsheet. Gnumeric doesn't have a simple way to do that. It has a complicated way to do it ('Advanced Filter'), but nothing so straightforward as…

Read Article

Software is not data

By

You know that trick where the magician snatches the tablecloth from the table, leaving the plates, cutlery and glassware in place? Watch as I do something similar on my computer. The screenshot above shows the top left corner of a large data table of mine in a spreadsheet. Drum roll, please... …

Read Article

On dates and stuffed non-dates

By

Nothing gives my wife the Screaming Meemies like dates in spreadsheets. Unless she formats the target cell in advance as text, the spreadsheet will turn a perfectly innocent, non-date string like 23/2/6 into '23-Feb-2006'. When she types 6420-11-3, according to both LibreOffice Calc and Gnumeric,…

Read Article

News Elsewhere

Linuxtoday.com

4 Ways to Disable Root Account in Linux

The root account is the ultimate account on a Linux and other Unix-like operating systems.

How To Remove Docker Containers, Images, Volumes, and Networks

Linuxize: Docker doesn't remove unused objects such as containers, images, volumes, and networks unless you explicitly tell it to do so.

On the low adoption of automated testing in FOSS

For projects of any value and significance, having a comprehensive automated test suite is nowadays considered a standard software engineering practice.

Android Integration Extension For Gnome GSConnect v13 Stable Released

 LinuxUprising: The latest GSConnect v13, released today, is a rewrite with with changes to the architecture, settings and default behavior, and it requires Gnome Shell 3.28 or 3.30.

How to start a vnc server for the actual display (scraping) with TigerVNC

HowToForge: VNC is a desktop sharing application

How the CISO of Xerox is Improving Security

eWEEK: Alissa Johnson knows full well that when it comes to securing a diverse, distributed enterprise like Xerox, there is no one single technology that is sufficient.

How To Browse And Read Entire Arch Wiki As Linux Man Pages

ostechnix: Arch-wiki-man program helps you to browse and read entire Arch Wiki as Linux man pages.

Linux: Find Out Which Port Number a Process is Listening on

As Linux users, we sometimes need to know which port number a particular process is listening upon.

How to Search and Remove Directories Recursively on Linux

Tecmint: This short tutorial describes how to find and delete directories recursively in the Linux file system.

GamingOnLinux Latest Articles

A statement from HOF Studios about the Depth of Extinction Steam key removal, plus thoughts

Tags: Steam, Misc, EditorialAfter writing about how the developer of Depth of Extinction revoked a user’s externally purchased Steam key after…

Game developer revokes a user's Steam key after negative review

Tags: Misc, Steam, Indie Game, EditorialHere's a case of how to definitely not deal with getting negative feedback. A developer of Depth of…

Control a magical flying door in To Leave, a mystifying difficult adventure now available on Linux

Tags: Steam, Platformer, Adventure, Puzzle, Indie Game, ReviewFreaky Creations recently released To Leave, a mystifying narrative-driven adventure…

Squally, a 2D game which has you hack it will be on Linux, demo available

Tags: Steam, Coming Soon, Indie Game, Early Access, Puzzle, Action, RPGI'm always curious to see how hacking mechanics make it into games and Squally…

A look at some interesting games and bundles on sale for Linux gamers

Tags: Game Sale, Game BundleHere's your (almost) weekly look at some interesting games and bundles that are currently on sale that have an…

You can try HITMAN free for a limited time in the Colorado location with the Halloween Pack

Tags: Steam, Feral Interactive, Stealth, ActionThe Halloween Pack pack for HITMAN goes live today giving you a chance to try it for free, which…

The excellent space-colony sim 'Oxygen Not Included' has a Space Industry update along with a new short

Tags: Steam, Indie Game, Early Access, Strategy, SimulationMy love for Klei continues on, with Oxygen Not Included getting another big update named…

Magic battle arena 'Magicae Mundi' has entered Early Access with Linux support

Tags: Early Access, Steam, Indie Game, ActionMagicae Mundi, a PvP magic battle arena game from developer Renan Sylvestre just entered Early Access…

Holy Potatoes! A Spy Story?! from Daylight Studios to release for Linux on November 7th

Tags: Coming Soon, Steam, Casual, Simulation, Strategy, ComedyThe wacky spy-agency sim Holy Potatoes! A Spy Story?! [Official Site] from Daylight…

Relaxing puzzle game inspired by Sudoku and Kakuro 'Puzlogic' to leave Early Access on November 2nd

Tags: Puzzle, Indie Game, Steam, Early AccessFor those who love to test their brain, the rather nice puzzle game Puzlogic which is inspired by…

Canonical have released some statistics from the Ubuntu installer survey

Tags: MiscWhen installing Ubuntu 18.04, Canonical's installer will offer to send some statistics to them. Canonical have now released some of this.…

Fight over the Iron Throne and swipe left or right in Reigns: Game of Thrones out now

Tags: GOG, Steam, Adventure, RPGReigns: Game of Thrones is the new entry to the Reigns series that has you swiping left and right to make decisions…

Rocket League's Halloween event is live, cross-platform 'RocketID' feature delayed and more news

Tags: Humble Store, Steam, Update, SportsThere's a few bits of Rocket League news to go over today, with the start being the Halloween event which is…

Hand of Fate 2 - The Servant and the Beast DLC is out extending the already great experience

Tags: DLC, GOG, Steam, Action, RPG, Indie GameReady to face the Dealer once again? Hand of Fate 2, the excellent mix of card-based board game…

The Steam Controller on Ubuntu 18.10 (and other distributions using Linux Kernel 4.18) needs a quick fix

Tags: HOWTO, HardwareAfter updating to Ubuntu 18.10 today I noticed that a lot of games were either crashing to the desktop, not detecting my Steam…