WPS Office bold fonts problems
Posted: 2024-08-10 Filed under: office, ports, system | Tags: bold, freetype, WPS Office 13 CommentsI use WPS Office for my work and so far have been quite happy with it. However, I noticed that it has some problem with certain fonts, when bold. I am not sure when this started, but apparently it happened after a certain freetype update. So, I decided to look around for a solution.
Read the rest of this entry »
Spreadsheet: if cell contents is greater
Posted: 2023-08-31 Filed under: office | Tags: excel, if, spreadsheet Leave a commentI have a spreadsheet, where I want to check if the contents of each cell is greater than a certain value. If TRUE, I’d like to return “YES”, so I filter on these cells. I googled a bit and found the following instructions.
Read the rest of this entry »
Automatic transliteration
Posted: 2023-06-04 Filed under: desktop, office | Tags: alphabet, ASCII, cyrillic, detox, file name, latin, rename, uconv Leave a commentRecently, there was an interesting discussion in #slackbuilds @libera.chat with lockywolf about Cyrillic to Latin transliteration. I never name files or folders in Cyrillic (a habit left from the Windows 9* times), but others do, so it’s not a bad idea to be able to automatically achieve this.
Read the rest of this entry »
Column to cell in a spreadsheet
Posted: 2023-04-30 Filed under: office | Tags: Cell values, excel, gene, row, sc-type, spreadsheet, transpose Leave a commentI 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 »
Split text in Inkscape
Posted: 2022-01-31 Filed under: drawing | Tags: inkscape, split, text Leave a commentI have a block of text in Inkscape that represents a single selection. However, I want to split it, making each individual row as a be separate entry, so it can be selected independently. It is actually quite easy to do, I just keep forgetting it.
Read the rest of this entry »
Slackalaxy 