WPS Office v11.* dictionary

I 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.

Read the rest of this entry »


bioRxiv docx template

I’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”.

Read the rest of this entry »


Average every n number of rows in a spreadsheet

I 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 »


Venn diagrams online

I’ve been preparing some figures, where I need to include Venn diagrams. I am looking to make them proportional to the values. So far, I have not found a way to do this in Gnumeric, WPS Office LibreOffice or OpenOffice.org. I guess, I should find the time to learn a little bit more of R. Meanwhile, I’ve been searching for a quick solution online.

Read the rest of this entry »


Keep lines thickness in Inkscape

I am preparing some figures in Inkscape. Something that always gets on my nerves is fixing lines (border) width when scaling objects. The solution is quite simple and actually obvious.
Read the rest of this entry »