The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,854 other subscribers

Archive for the ‘Hardware’ Category

Excel 2010/2007: Convert text to a table or vice versa (via: Word – Office.com)

Posted by jpluimers on 2012/05/21

The introduction of the Ribbon in Office 2007 and 2010 often makes me ask “why are things so complicated now, that were so easy until Office 2003”.

One of the things that were very close together in Word 2003, was converting text to and from tables: they were in adjecent menu items.

Not any more, as you can see in the Convert text to a table or vice versa  topic on the Microsoft site. There is even a Dummies article on this topic.

Summarized:

Convert text to a table

  1. Tab Insert,
  2. Group Tables,
  3. click Table,
  4. then click Convert Text to Table.

Of course the keyboard shortcuts are “easy” to remember: Alt, N, T, V

Convert a table to text

  1. When you have a (portion of a) table selected, you get a new contextual tab set called Table Tools.
  2. Tab Layout,
  3. Group  Data,
  4. click Convert to Text.

Of course the keyboard shortcuts are “easy” to remember: Alt, J,L, V

Word 2007/2010: Convert Table to Text

–jeroen

via: Convert text to a table or vice versa – Word – Office.com.
Naming of ribbon UI elements
Naming of ribbon UI elements

Posted in Keyboards and Keyboard Shortcuts, Office, Power User, Word | Leave a Comment »

The end of the classic ThinkPad Keyboard layout (#Lenovo #Fail)

Posted by jpluimers on 2012/05/18

(Thanks to a “Missed Post” problem on WordPress.com, this one didn’t get posted on the scheduled date. Sorry for any inconvenience)

First Lenovo did away with 1920×1200 screens. Now they done away with the ThinkPad keyboard layout.

Both were my compelling reasons for buying Lenovo.

In fact, they are now marked as forum.thinkpads.com • non-ThinkPad Lenovo Hardware.

New Lenovo X1 keyboard. No more ScrLk, Pause and local-menu keys, PrtScr key moved to impossible place. 6-key navigation split.

New Lenovo X1 keyboard. No more ScrLk, Pause and local-menu keys, PrtScr key moved to impossible place. 6-key navigation split.

–jeroen

PS: Anyone in The Netherlands who has a new ThinkPad W701 with 1920×1200 screen for sale?

Posted in Keyboards and Keyboard Shortcuts, Missed Schedule, Power User, SocialMedia, WordPress | 2 Comments »

Mac keyboard shortcut to move things to the Trash – Mac Guides: command-backspace #mac #keyboard #shortcut

Posted by jpluimers on 2012/05/18

Some shortcuts on the Mac are difficult for me to remember. For instance the one to move something from the Finder to the Trash.

The guides on Trash at MacRumours.com to the rescue:

Deleting items

You delete files and folders by moving them to the Trash. You can:

Drag and drop a file on the trash icon in the dock

Control-click on a file and select “Move to Trash” from the menu

Select a file or files and use the keyboard shortcut: command-backspace

Select a file or files and choose “File > Move to Trash” from the menu bar

Notes:

Read the rest of this entry »

Posted in Apple, Keyboards and Keyboard Shortcuts, Mac OS X / OS X / MacOS, Mac OS X 10.5 Leopard, Mac OS X 10.6 Snow Leopard, Mac OS X 10.7 Lion, Power User | Leave a Comment »

Microsoft Excel 2007/2010 – Protecting Workbooks and Worksheets

Posted by jpluimers on 2012/05/04

One of the things about the Office 2007 and 2010 Ribbon is that it makes the things that you have remembered for 10+ years go into hard to find places.

My point is that according to the ribbon documenation:

A ribbon can replace both the traditional menu bar and toolbars.

Microsoft has decided to read the “a ribbon can replace” as “the ribbon replaces”. Thereby also introducing a whole new naming for the UI elements used in ribbons (see at the bottom).

Tab "Review"; Group "Changes"; Commands "Protect Sheet" / "Protect Workbook"

Tab “Review”; Group “Changes”; Commands “Protect Sheet” / “Protect Workbook”

Protecting a worksheet and workbook have been in the menu “Tools”, submenu “Protection” forever. But alas: No more “Tools” menu, and accompanying keyboard shortcut productivity (and I needed “unprotect workbook” because you cannot copy workbooks inside a protected workbook).

As “password protect worksheet” shows, it is now under:

  1. Tab: Review
  2. Group: Changes
  3. Commands: Protect Sheet / Unprotect Sheet / Protect Workbook / Unprotect Workbook

–jeroen

via: Microsoft Excel 2007 – Protecting Workbooks.

Naming of ribbon UI elements

Naming of ribbon UI elements

Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »

Start a New Line Inside a Spreadsheet Cell in Excel | Excel Semi-Pro

Posted by jpluimers on 2012/03/16

Unlike most tools where you use Shift-Enter to add a line break character (ASCII 10: line feed), Excel is different:

Sometimes it’s necessary to have more than one line inside a worksheet cell, which is easily done with a line break.

Add a new line by holding down the Alt key while you press enter. It’s the keyboard shortcut Alt+Enter. In Excel 2008 and 2011 for Mac use Cmd+Option+Enter.

–jeroen

via: Start a New Line Inside a Spreadsheet Cell in Excel | Excel Semi-Pro.

Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Office 2000, Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Power User | Leave a Comment »

When are the 12.5mm 1.5 TB and 14.8mm 2 TB notebook drives coming? (via: Marvell 4Q 2012 – Hard Drives Coming Back, SSD Controller Sales Double – Storage Forums)

Posted by jpluimers on 2012/03/09

Since about 9 months, 2.5 inch notebook drives ship that have 500 gigabyte platters.

With that technology, these drives ship:

they easily could manufacture these configurations:

Read the rest of this entry »

Posted in Hardware, Power User, SSD, ThinkPad, W701 | 2 Comments »

#@xs4all only over AnnexB with FRITZ!Box 7340 #fail: line sync issues; offline most of the time, max 4 mbit. @xs4all needs to give me some compelling arguments to regain trust in them. @xs4all_HD

Posted by jpluimers on 2012/03/08

xs4all won’t tell you up front, but they changed a couple of things that will bring your 10 mbit down / 1 mbit up to something that hardly connects, and if it does less than half the speed.

This is also a post on how XS4ALL treats long lasting (15 years!) customer relations. Badly.

05.03.12 16:08:01 DSL-Synchronisierung beginnt (Training).
05.03.12 16:06:05 Internetverbindung wurde getrennt.
05.03.12 16:06:05 Internetverbindung IPv6 wurde getrennt, Präfix nicht mehr gültig.
05.03.12 16:06:05 Internetverbindung wurde getrennt.
05.03.12 16:06:05 DSL antwortet nicht (Keine DSL-Synchronisierung).
05.03.12 15:56:30 Internetverbindung IPv6 wurde erfolgreich hergestellt. Präfix: 2001:980:43d9::/48
05.03.12 15:56:30 Internetverbindung IPv6 wurde erfolgreich hergestellt. IP-Adresse: 2001:980:43d9::be05:43ff:fe70:9b53
05.03.12 15:56:26 Internetverbindung wurde erfolgreich hergestellt. IP-Adresse: 82.161.132.169, DNS-Server: 194.109.6.66 und 194.109.9.99, Gateway: 194.109.5.205
05.03.12 15:56:21 DSL ist verfügbar (DSL-Synchronisierung besteht mit 4804/1029 kbit/s).
05.03.12 08:44:20 DSL-Synchronisierung beginnt (Training).

They advertised XS4ALL ONLY (since it on the copper pair you only run DSL, no phone, so you don’t need a splitter) as faster, cheaper and more stable internet and VOIP connection.

It is not. Read the rest of this entry »

Posted in Fritz!, Fritz!Box, Network-and-equipment, Opinions, Power User | Leave a Comment »

“Cannot navigate to definition” annoyance in Visual Studio 2010 – (did it implement the mouse equivalent to Delphi code browsing? No, it didn’t)

Posted by jpluimers on 2012/03/08

This use case drove me nuts in Visual Studio 2010 for a while, but can be solved.

Use cases:

  1. Cannot navigate to definition.double click on a word to select it
  2. press Ctrl-C to copy the selected text
  3. result is either of these two dialogs:

    ---------------------------
    Microsoft Visual Studio
    ---------------------------
    Cannot navigate to definition.
    ---------------------------
    OK
    ---------------------------

    Cannot navigate to definition. The cursor is not on a symbol.or

    ---------------------------
    Microsoft Visual Studio
    ---------------------------
    Cannot navigate to definition. The cursor is not on a symbol.
    ---------------------------
    OK
    ---------------------------

The reason is that Visual Studio 2010 still thinks I am clicking the identifier (which I’m not, I just released the mouse button) while pressing the Ctrl key. Read the rest of this entry »

Posted in .NET, Delphi, Development, Keyboards and Keyboard Shortcuts, Power User, Software Development, Visual Studio 2010, Visual Studio and tools | Leave a Comment »

#WordPress Editor #keyboard #shortcuts

Posted by jpluimers on 2012/03/05

Both the WordPress Visual editor and HTML editor accept keyboard shortcuts. The built in WordPress Visual editor is based on TinyMCE where some of the shortcuts come from.

Since I’m a keyboard guy, I collected some information on keyboard shortcuts over time, and below is a table with what I collected for both editors.

That, combined with distraction free writing really gives WordPress a boost.

Most of the shortcut keys use the modifier keys ALT plus SHIFT.

Note that on a Mac, you will have to use the “command” key in stead of the “CTRL” key.

Visual Editor

You can see what these shortcuts do in the WordPress Visual Editor support page.

Function Shortcut Keys Alternative Shortcut Keys
Undo CTRL + z
Redo CTRL + y
Headers (H1, H2, H3, …, H6) CTRL + 1 … 6
Paragraph CTRL + 7
Format CTRL + 8 (doesn’t work on a Mac)
Address CTRL + 9
Bold ALT + SHIFT + b CTRL + b
Italic ALT + SHIFT + i CTRL + i
Underline CTRL + u
Strike through with red (delete) ALT + SHIFT + d
Align left ALT + SHIFT + l
Align center ALT + SHIFT + c
Align right ALT + SHIFT + r
Blockquote ALT + SHIFT + q
Unquote/outdent ALT + SHITF + w (doesn’t work on a Mac)
Code ALT + SHIFT + c (doesn’t work, is “align center”)
Unordered List (ul) ALT + SHIFT + u
Ordered List (ol) ALT + SHIFT + o
List item (li) ALT + SHIFT + l (doesn’t work, is “align left”)
A Hyperlink (a) ALT + SHIFT + a
Line break SHIFT + Enter
Read more ALT + SHIFT + t
Next page ALT + SHIFT + p
Media insert (image/video/…) ALT + SHIFT + m (on a Mac, it also inserts a Ã)
ins ALT + SHIFT + s (doesn’t work on a Mac)
del ALT + SHIFT + d (doesn’t work on a Mac)
Distraction free writing ALT + SHIFT + g
Enable “Kitchen Sink” Toolbar ALT + SHIFT + z
View HTML code ALT + SHIFT + e (doesn’t work on a Mac)
Advanced Editor ALT + SHIFT + v (doesn’t work)
Spell check ALT + SHIFT + n
Rich Editor Help ALT + SHIFT + h
  • Unused ALT + SHIFT + letter combinations: f, y, j, k, x.

HTML editor (don’t work on a Mac)

Though the sources I used (see bullets below) indicate the below table should work, they don’t.

So: no HTML shortcuts on Mac or PC, which is a shame.

The only reason I use the HTML editor once in a while are these:

Function Shortcut Keys Alternative Shortcut Keys
Bold ALT + SHIFT + b
Italic ALT + SHIFT + i
Strikethrough ALT + SHIFT + d
Blockquote ALT + SHIFT + q
Code ALT + SHIFT + c
Unordered List ALT + SHIFT + u
Ordered List ALT + SHIFT + o
A Hyperlink ALT + SHIFT + a
Read more ALT + SHIFT + t
View HTML code ALT + SHIFT + e
Headers (H1, H2, H3, …) Ctrl + corresponding number
Insert date/time ALT + SHIFT + s
Insert IMG URL ALT + SHIFT + m
List Item (li) Alt + SHIFT + l
Publish the Post Alt + SHIFT + p
Redo CTRL + y
Undo CTRL+z

–jeroen

via:

Posted in Keyboards and Keyboard Shortcuts, Power User, SocialMedia, WordPress | 1 Comment »

When writing applications, include Keyboard Shortcuts for both the CUA and Windows/Apple shortcuts

Posted by jpluimers on 2011/12/06

When you write applications, it is important to include both the CUA and the Windows/Apple keyboard shortcuts, and get the tab order of keyboard accessible user elements right.

Many modern applications seem to put less and less emphasis on the most efficient user input device: the keyboard.

You should: it makes your application much more pleasant to use.

I wrote about CUA before, but the Windows and Mac shortcuts are just as important.

A small table (please post a comment if you know additions):

Read the rest of this entry »

Posted in .NET, Delphi, Development, Hardware, IBM SAA CUA, Keyboards and Keyboard Shortcuts, KVM keyboard/video/mouse, Power User, Software Development, xCode/Mac/iPad/iPhone/iOS/cocoa | Leave a Comment »