Category Archives: office

Shorten contents of spreadsheet cells

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

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

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

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

WPS Office

With the latest SlackBuilds.org update, WPS Office was added to the repository. I decided to give it a try, as I have never been too happy with Impress. The SlackBuild script just repackages the binaries provided from upstream. So far, … Continue reading

Posted in office | Tagged , , , , , , , | 1 Comment