Excel: copy paste of cells with multiline text show up with quotes "

Current workaround is to copy paste into word and then into any editor/terminal of your choice.



Again I have not been able to copy the cells as how they are shown, i.e. not quotes, without going through word. 

Excel: Transpose anyone? Much needed feature easily accessed

I started it all wrong with some excel table and decided I need to switch rows with columns and thought that it takes me some time to actually do it manually or find a feature in excel to do it.

Excel to the rescue: Transpose

Just select the table or rows/columns then CTRL-C, go to a new Sheet or wherever and CTRL-V, then select T or transpose icon. Done.

I just have not been able to do this without choosing another place or Sheet, i.e. no same place transpose? Anyone any idea?

for fun: use beautiful google datacenter pictures as windows 7 login screen image

The process is quite simple but I like this little utility much more:

http://www.julien-manici.com/windows_7_logon_background_changer/



I even did not have to reboot to check out if it works, just used WIN+L and boom there it was

links:
http://www.intowindows.com/how-to-change-windows-7-logon-screen-easily-without-using-hacks-tools/

End of the debate: Microsoft SMB can work over tcp/445 period, over and out.

The many discussions you're facing if you don't want to open ports udp/137, udp/138 and tcp/139 in your firewalls end here:

http://technet.microsoft.com/en-us/library/cc940063.aspx

Direct hosting over TCP/IP uses TCP port 445 instead of the NetBIOS session TCP port 139.

Direct hosting has been available since Windows 2000!

Ok, but just yesterday we have had a machine that we could not teach to use tcp/445 for SMB it always defaulted to NetBIOS over TCP/IP. Was a W2K8 R2 and has some registry corruption issue that prevented it to connect to any fileshare. Solution to that was to set the server to DHCP and then back to static, but it now only goes over 137-139.

Sony Ericsson T610 reset code: 0000

Excel: row numbering

It took me more than 5 minutes to actually find the right link for my problem to number rows automatically with some correction on where to start.

=ROW()-9

If placed in A10, this will give you 1.

Here's the original article, where I found it from:

http://agsci.psu.edu/it/news/2010/11/automatically-number-rows-in-excel

Did apple steal the clock design in iOS 6 for iPad from Mondaine?

The first thing you'll notice after upgrading to iOS 6 on iPad will probably be the clock application. Since it is the biggest improvement for many people not having to rely on other clock applications and stop watches. (No you probably only have to wait for iOS 7 to deliver the weather app).

But for any swiss person or someone having travelled through switzerland it's apparent that the design is from our official swiss rail clock (mondaine), which we have come to love.

Is it licensed or just ripped of?

tcpdump: output to pcap file and display on console

Many thanks for this blog entry where it explained on how to use tcpdump to write to a file and simultanously print on the console.

tcpdump -U -w - host 1.2.3.4 | tee file.pcap | tcpdump -r -

http://jbits.se/blog/2010/02/19/tcpdump-output-to-file-and-console/

Google Calendar sync issue: Use DocMessageClass to resolve the issue

You might notice that some entries are not synced from outlook to google and this is because Outlook has different Message classes especially for meeting requests.

I use a free portable app DocMessageClass to fix these items, but it is a manual process and I've seen some scripts on the web but have not made the effort to actually put them to work.





http://www.publicshareware.com/public-share-outlook-utilities.php

Google Calendar sync with Outlook tool: Really great for keeping your Business/Private calendar in sync

http://support.google.com/calendar/bin/answer.py?hl=en&answer=98563

Using for a long time with almost no issues.

Checkpoint proxy arp and manual nat

In checkpoint if you have a manual NAT entry the firewall will not do proxy ARP, which means it will not answer to arp requests on the network where the NAT will take effect.


Solutions are:

- use automatic NAT rule
- there's article on Checkpoint support that describes on how to correctly add an entry to a file that the firewall will do the proxyARP, apparently different for single or Cluster XL
- define a static host route to the firewall from the other device.

In my case they forgot to that and the SYN traversed 2 firewalls but the SYN/ACK was lost due to one firewall not being able to find via ARP a MAC address to talk to.

Rant: Windows 8

I have just read a very nice piece on somebody's experience in regard to windows 8 and some parts feel like they are my thoughts.

image found on google images: http://i-dothink.com/index.php/windows-8-phone-functionality-spotted/

iOS and MacOSx are definitely advanced in many aspects, but the major improvements are still missing in regards to information connectivity.

The article talks about Dashboard that could have been the windows 8 tiles UI. And I think he's right. I never was able to really make use of the dashboard and today mostly land on it by error. I use the iPad daily between 1 to 5 hours over a 16 hour period, 99% consumption. And clearly the presentation of the information on the main screen is lacking, the integration between apps and data is lacking, best example is try to install a pinterest bookmark, i.e. it should just be natural to click on whatever to share with whatever that's out there.

The windows 8 UI will probably help me avoid going into my top 5 applications all the time. Also notification in iOS and OSx are less than optimal. I want to have all information on one big screen. I don't think the widgets of android are going to do the trick, since most of them take to much screen real estate and have a non identifiable form.

I will install the 90 days windows 8 evaluation version tonight and try to spend another few hours to try and see if I get the same productivity as the author said he does.

Maybe at one point some really good guy will develop an OS where all information can be used in whatever form we like and multiple times in different places but all linked to the same info. As an example the worst thing today is that a reminder is not really a note, not really appearing in the calendar, not really an alarm entry, not being editable by penultimate, not able to print using the papers app .....

Microsoft tried in some office version to actually put tasks onto the calendar at the bottom but not in the calendar. I still crave for this that the tasks will actually be put into the calendar and reflect the actual time spent or whatever I want it to be and if completed will change color, allow tagging and more.

Most probably we won't get most of this for another decade or so, as it took from the perfect Palm Pilot to a somewhat great iPhone. Is it really that people forget this so soon. Everything was here and it took 20 years to improve.

Well here is the link to the article:

http://www.theverge.com/2012/8/16/3246185/this-is-my-next-windows-8

virtual cd rom: win cd emu

http://wincdemu.sysprogs.org/

disk performance utilitiy: crystel disk mark

http://crystalmark.info/software/CrystalDiskMark/index-e.html/

USB: Boot disk utilities - Rufus

http://rufus.akeo.ie/

Filezilla, Websense: Using ftp upload/download over websense proxy using filezilla client

http://www.websense.com/content/support/library/web/v75/wcg_help/conf_ftp_clients.aspx

The most important is the part:

FTP Proxy:
Custom:
USER %u@%h
PASS %p

proxy host: server:2121

user and password sometimes have to be defined and sometimes not, in my case the user was important but not the password.

Apple Wireless Keyboard mapping under Windows

http://support.apple.com/kb/HT1171

Mac OS X: iTunes keep an extra copy in addition to time machine (Updated 2014-11-29)

Actually this was a good idea, but it takes a millennia to start to copy actually something.

rsync -avr --delete /Volumes/Toshiba/iPhoto\ Library/ /Volumes/LACIE/iPhoto\ Library/

Then I had to copy two backups and was fed up about the rsync never actually to start copying for hours.

I found this article

http://blog.brettalton.com/2013/08/05/how-to-speed-up-rsync-on-your-mac-and-stop-the-dreaded-building-file-list/

and installed homebrew and then the new rsync and am using the following command now:

rsync -a --info=progress2 /Volumes/WD_2TB/ /Volumes/Toshiba/

Now there is some action, but disappointingly it crawls and I don't know why. Is it because there are gazillions of small files or is something else broken?

Let's wait and see.

Don't know but I feel more comfortable with this command as it actually does go ahead for now (still don't understand enough about the processing):

rsync -aP /Volumes/WD_2TB/ /Volumes/Toshiba/

and this with rsync 3.1.1