Column to cell in a spreadsheet

I have a list of gene names in a spreadsheet column hat I need to transform to a row. Using the transpose function does not do the job, because gene names should be in a single cell, comma separated. So, I searched a bit and found the TEXTJOIN function.
Read the rest of this entry »


Gnome legacy icon theme

When I started with Linux, back in 2005, the desktop environment that came with the distro was Gnome 2.6. I was very impressed with its icon theme, and won’t lie to say that I fell in love with it. At Gnome 2.16, the next generation, Tango-like theme was introduced. I do like it, I also like Tango very much. However, I made an attempt to revive the pre-2.16 theme.
Read the rest of this entry »


Managing git

I appreciate git’s power, but I still find it unnecessarily complicated. I am not going to whine or complain here about that. Instead, I decided to outline a few steps about setting up keys and some basic commands. I am using GitHub as an example.
Read the rest of this entry »


.xprofile settings

Before discovering Slim I usually just used lxdm, which is nice and feature rich. However, login managers like lxdm (and I hear this applies to GDM, LightDM, and more…) do not obey any settings I put in, for example, ~/.xinitrc. Therefore, ~/.xprofile seems to be the solution for such graphical login.
Read the rest of this entry »


CRUX ports added to portdb

My collection of CRUX ports has been just added to the portdb section at CRUX’s web-site, as ppetrov. I also maintain Xfce 4.12 for CRUX 3.7, but decided that it will not be of much interest, so it’s not there. Anyway, both repos are available at GitHub.