LibreOffice – Formulae Auditing

If you have a excel sheet with lot of formula’s and you are trying to audit them, then a simple solution is to press “ctrl+`” (i.e. control key with back tick). This will put the excel sheet in Formula auditing mode and hence all the cells will show the formula rather than the values which will make it easier to audit them. Hope that helps.

Enhanced by Zemanta

procmail filters – apply to received mails.

If you already have some mail in your maildir and you have set procmail filters, then it is difficult to apply the procmail filter, right? Not so, you just need to go to the Inbox directory and then execute the command.

for i in *; do cat $i|procmail; rm -f "$i"; done

This will pass all of your e-mail through procmail again and then your filters will get applied. Mails will go to their appropriate directory and you will be one happy man, I hope.

 

Enhanced by Zemanta

quick notepad in firefox.

If you quickly need to note something and you do not want to leave your browser then just add a bookmark to :

data:text/html, <html contenteditable>

and whenever you need to get the notepad, just open this bookmark. Sorry, I do not remember, where I got this from, but this is something that I did not discover but since I do not remember where I got this from, I am not able to credit the authour.

 

Enhanced by Zemanta