Category Archives: office

Venn diagrams online

Posted on 2020-11-04 by

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. … Continue reading →

Posted in Academic, office | Tagged , , | Leave a comment

Shorten contents of spreadsheet cells

Posted on 2020-08-05 by

I have a spreadsheet file with a list of species’ Latin names. I want to automatically create abbreviations for each species, by shortening both the genus and specific epithet to a certain number of characters. Here’s how to do it.

Posted in Academic, office | Tagged , , , , , | Leave a comment

Remove new lines from a text file

Posted on 2019-10-08 by

I want to copy some text from a PDF file into a word processor. Copying works, but the line breaks from the PDF formatting are also copied. This messes up the text and results in disconnected text with many rows. … Continue reading →

Posted in office | Tagged , , , | Leave a comment

Syntax highlighting

Posted on 2019-08-04 by

I’ve been writing a text document, where I want to paste an excerpt of a shell script. I want to put it in a frame as a separate “figure”, referred to in the text as “Box ##”. To make it … Continue reading →

Posted in office, system | Tagged , , , , , , , | Leave a comment

WPS Office dictionary

Posted on 2017-10-15 by

I have been using WPS Office for quite some time now, and I am really not looking back. The default spellcheck that comes with the office is American English (en_US). I wanted to add a spell check in Writer for … Continue reading →

Posted in office | Tagged , , , | 1 Comment