LibreOffice Basic escape characters

As Visual Basic doesn’t have an escape sequence LibreOffice Basic doesn’t have one neighter. So find out the Unicode code point for the character and use ChrW to convert it to the character. On Windows you can use charmap.exe to find out the  Unicode code point or have a look here.

For example, for the Copyright sign (U+00A9) you’d write:

Dim Copyright AS String
Copyright = Chr(&H00A9)
...
Cell.String = "Copyright sign: " & Copyright
..

Advertisements

Notepad++ Column Mode

Use <Alt>+<Shift>+Arrow key or <Alt> + Mouse to select and edit text in column mode with Notepad++.

Clean local Maven repository

Delete artifacts in local Maven repository and get new ones:

mvn dependency:purge-local-repository -DreResolve=false -DactTransitively=true -Dverbose=true clean install

Deleting the Windows.old directory and setup files after upgrading to Windows 8

• Go to your Computer
• Right click on C and select properties
• Click on Disk Cleanup.
• Click on Clean up system files. This will change the options in the ‘Files to delete:’ section.
• Select ‘Older version of Windows’ option and press OK.

Disable the lock screen in Windows 8

• Hit Window Key + R, type gpedit.msc into the box and hit Ok. The Local Group Policy Editor appears.
• Navigate to Computer Configuration -> Administrative Tools -> Control Panel -> Personalization.
• Double click on ‘Do not display the lock screen’.
• Select Enabled and click Ok.

Start Windows 8 with Desktop

Download the File Explorer Command File from here and move it to C:\ProgramData\Microsoft\Windows\Start Menu\Programs\StartUp.

Another easy way to go to the Desktop is to press the Escape key.