Sunday, June 4, 2017

Fixing Google reminders suddenly stop displaying

I am using Google reminders since they were introduced. I really love them.

Today they suddenly stopped displaying on the web interface, although the Reminders entry still showed up in the My calendars list and was enabled. A quick look at the Calendars app on my smart phone showed that the reminders actually were still there, they just did not show up.

After googling around I found someone fixing that kind of issue by changing the time zone. That did not help in my case though. What has fixed the issue was, changing the displaying language to English (US). To do so open Settings. Then on the General tab change Language to English (US):


I hope that this will be of help for others, too. Please report back if this helped you.

Monday, February 6, 2017

How to open Excel files in separate windows

I like to be able to aero snap Excel files to compare its content or to have one as a reference for editing the other.

However in Office 2010 for example, the work books open in the same Excel instance not permitting this easy viewing. Using the view menu to tile the document windows within the application is not that flexible and easy to use.

All you have to do is to save this content to a file with the ending .reg and import it to the Registry by double-clicking (you have to remove " (x86)" from the program files path is you are using the 64-bit Office version):

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command]@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" \"%1\"""command"=hex(7):78,00,62,00,27,00,42,00,56,00,35,00,21,00,21,00,21,00,21,00,\  21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\  00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,56,00,69,00,6a,00,71,00,\  42,00,6f,00,66,00,28,00,59,00,38,00,27,00,77,00,21,00,46,00,49,00,64,00,31,\  00,67,00,4c,00,51,00,20,00,22,00,25,00,31,00,22,00,00,00,00,00
[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec]
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2]@="[open(\"%1\")]"
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2\application]@="Excel"
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2\topic]@="system"

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" \"%1\"""command"=hex(7):78,00,62,00,27,00,42,00,56,00,35,00,21,00,21,00,21,00,21,00,\  21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\  00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,56,00,69,00,6a,00,71,00,\  42,00,6f,00,66,00,28,00,59,00,38,00,27,00,77,00,21,00,46,00,49,00,64,00,31,\  00,67,00,4c,00,51,00,20,00,22,00,25,00,31,00,22,00,00,00,00,00
[-HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec]
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec2]@="[open(\"%1\")]"
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec2\application]@="Excel"
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec2\topic]@="system"
Now all your Excel files open in an own application window. Enjoy.

Thursday, July 7, 2016

One-liner to check when your Windows computer shuts down or goes to sleep

Once in a while you want to know when your computer shuts down or goes to sleep whithout watching him all the time. For example when you want to measure how long the batteries of your laptop or still hold.

A simple solution is to log the current timestamp in a file. The last timestamp is the one when the computer shut down. This is a simple PowerShell one-liner to do that:
echo "Start" > test; while (1) { date >> test ; sleep 60 }

It writes a timestamp to the file test (in the current folder) every minute until the program is stopped. If you don't stop it, then the OS does when it shuts down.

Wednesday, June 29, 2016

JW Library App: Easy Backup and Restore of Publications, Bookmarks and Highlights

Ever replaced your computer and started over with your studies in JW Library?

There is currently no official way to sync the bookmarks and highlights across devices.

It is however possible to manually backup and restore the JW Library. And it is really simple!

Please note that the following procedure only works if the user name is the same on the source and destination computer. 

Backing up the JW Library App

  1. Make sure that the JW Library App is closed.
  2. In Windows Explorer make sure that the option to show hidden items is enabled: on the View menu check Hidden items.
  3. Then browse to folder C:\Users\<your user name>\AppData\Local\Packages\WatchtowerBibleandTractSo.45909CDBADF3C_5rz59y55nfz3e
  4. Create a copy of the sub folder LocalState, e.g. to an USB stick.

Restoring the JW Library App

  1. Make sure that the JW Library App is installed but closed.
  2. In Windows Explorer make sure that the option to show hidden items is enabled (see above).
  3. Then browse to folder C:\Users\<your user name>\AppData\Local\Packages\WatchtowerBibleandTractSo.45909CDBADF3C_5rz59y55nfz3e
  4. Create a temporary backup of your current LocalState sub folder.
  5. Delete the content of the LocalState subfolder (Attention: do not delete the folder as it has special permissions assigned to it –  just delete its content)
  6. Copy the content of the LocalState folder from the source computer to the LocalState folder of the destination computer.
That's it. You are done. Start JW Library and enjoy all your publications, bookmarks and highlights. If anything goes wrong, you can easily restore your previous content on the destination computer from the temporary backup.