Rotate text in Inkscape
Posted: 2021-11-27 Filed under: drawing | Tags: inkscape, rotate, text Leave a commentI am preparing a figure where I need to label several violin plots. I do not have enough space under the figure to fit everything without looking cluttered. So, I want to make the labels slanted at 45 degrees. How to do it in Inkscape?
Read the rest of this entry »
Spreadsheet cells’ contents length
Posted: 2021-11-07 Filed under: office | Tags: gnumeric, spreadsheet Leave a commentI need to compare a list of UniProt identifiers to a database of protein-protein interactions. All IDs in my list are 6 characters in length, while the database I am comparing to has many entries that are longer. I want to clean these up, since nothing from my list will match to them and I also want to speed searches by making the database smaller.
Read the rest of this entry »
WPS Office v11.* dictionary
Posted: 2021-04-03 Filed under: office | Tags: dictionary, libreoffice, spellcheck, WPS Office 9 CommentsI noticed that an old post of mine about adding dictionaries to WPS Office, has been receiving some attention recently. I quickly checked the links and it seems they are dead, also the file paths listed there no longer apply for WPS Office v11. Therefore, I decided to check how to add dictionaries to version 11.
EDIT (27 May 2023): check this much more recent post of mine, as well as the ready to use dictionaries at GitHub.
bioRxiv docx template
Posted: 2021-02-28 Filed under: academic, office | Tags: bioRxiv, doc, docx, template 2 CommentsI’ve been working on a manuscript in the last couple of months (more, actually). I am not going to discuss whether pre-prints are cool or not, however, they sometimes are necessary. For example, when writing a grant application, it definitely looks better to show the actual work in progress, rather than just stating “manuscript in preparation”, “submitted” or “under revision”.
Average every n number of rows in a spreadsheet
Posted: 2021-02-27 Filed under: academic, office | Tags: gnumeric, spreadsheet Leave a commentI have a long column of data that I want to make into a chart. The problem is that the column has over 50000 rows and processing it gets problematic. I looked for a way to average every Nth number of rows, in order to speed up things.
Read the rest of this entry »
Slackalaxy 