Tuesday, December 27, 2011

excel mac:2011 "edit cell" keyboard shortcut

note-to-self: to edit the content of a cell in excel mac:2011, hit ctrl + U.
U
(comment: that's the equivalent to F2 in Windows land)

Monday, December 12, 2011

SAP Passport on OS X / iOS


note to self: since it's nowhere to be found how to operate the SAP marketplace, support portal or SDN with a certificate in Safari (OS X) or an iOS device:
when receiving another of them SAP S-User, do the following to make the SAP passport (aka public & private key) work on OS X (Safari and the like) and iOS:

  • use Firefox (here: 8.0.1), open the Support Portal and log in a subsequent fazillion times with your S-User-Id and password
  • (sorry, German coming up) mein Profil ➔ Single-Sign-On Zertifikate verwalten
  • put your password in the fazillionst time and generate your passport 
  • Firefox will install your new SAP passport (aka public & private key) in the background and notify you upon completion (ignore the notifications about invalid Certificate Authorities and bla; it's all a big useless bloat of shady issuer-companies anyway)
Now in Firefox Advanced preferences, (you guessed it, German again) Zertifikate anzeigen. Locate your S-User-Id in (yep, German) Ihre Zertifikate, highlight and backup.

This will export your SAP passport (aka public & private key) in PKCS12-format - not so easy to do with any other browser, including the MS cripples. Because usually your private key remains hidden in binary wonderland somewhere in the proprietary niche of the browser. But you'll need both public and private key for use with the OS X / iOS keychain.

Launch the latter and import your newly exported .p12 file. 

Now happily browse the SAP marketplace, support portal or SDN via SSO with your browser certificate in Safari or your favorite iOS device.


q.e.d