Thursday, August 14, 2014

Mac - Ms Excel 2011 - Add new line in the cell

While typing in the cell of excel worksheet, alt+enter will feed the cursor a next-line in windows version, however in mac version the shortcut is ctrl+alt+enter.

Monday, August 22, 2011

email archives from Thunderbird to Evolution

When days go along, my mailbox getting full easily, and it's time to get upkeeping by store the mails elsewhere. It's just kind of big trouble for me to get through the email archives. And here's the way i tried so far.

Get the emails manager such as Evolution (linux), Thunderbird(both windows & linux) etc for archive or emails local storage. Select the mails and move to local folders, or archives(some managers have this option).

When you need for backup of this local mails, go to the storage folder and get copy from it.
For Evolution (ubuntu), common method is look at the files at:
~/.evolution/mail;
but in fact for my case, the Evolution is built-in with Ubuntu Natty Narwhal 11.04, which stored i else where:
~/.local/share/evolution

For Thunderbird, the archived mails would be in:
(Windows) C:\Documents and Settings\(user)\Application Data\Thunderbird\profiles\...\Mail\Local Folders\
(Ubuntu) ~/.thunderbird/xxxxxxxx.default/Mail/

*the symbol "~" means the home folder of the user directory.

Another one knowledge, archived mails transfer from Thunderbird to Evolution, just copy the files (of Thunderbird) without any extension and import in Evolution. Generally, for each archives folder in Thunderbird, 2 files created, one with the extension of .msf, another one is without any extension, eg: 2008 & 2008.msf

Monday, June 27, 2011

Sync iPad/iPhone with Google calender

Here's to share the method, out of thousands of forums out there teaching us the way.

Step1 - in iPad/iPhone:

Settings > Mail, Contacts, Calenders > Add Account
choose either
1. Microsoft Exchange or
server: m.google.com; username: your_gmail_domain with "@gmail.com"
2. Gmail or
just key in your gmail login info
3. Other
Add CalDAV Account; server: google.com; plus the remaining userinfo of gmail account.

Step2 - in Safari:
goto: m.google.com/sync
A list of smartphone devices belongs to your gmail account would be listed, selected the one you prefer and tick the calendar(s) you need to sync with, up to 25 calendars. Then click Save.


Step3 - in apps: Calendar:
on top left of the touch screen, click the box "Calendars", all the selected to sync calendars in step2 would be here, then select those needed, click "done" on top right, wait for the sync to perform.

All events would be shown and able to be update, create, edit, delete, etc, and sync with the google calendar all time (unless no wifi/3G access).


Friday, July 2, 2010

Too long sync of iphone with itune

It spends very long time for the sync and the system seems out of time or "hanging" somemore.

Normally most of the time of every sync is on the "back-up", even before the sync. And the back-up wouldn't need to be executed everytime, as we always update the content and apps between the two from time to time. Thus, the simple way to make the progress faster is to click the little cross "x" behind the "back-up" progression bar. Then it will continues with the sync afterward.

Just found the very useful info from some forum that, this long-time-syncing (or better refered as back-up) is caused by itune sending error report to apple and it takes very long time.

Good luck!

Monday, June 28, 2010

Transfer contacts from Iphone to SE-W300

I have my Iphone sent to factory for hardware checking via warranty. So, in the mean time waiting my Iphone to be returned, I wouldn't have a phone to use. Thus I turn to use the old Sony Ericsson W300, which even its own software PC Suite cannot be configured and connected via my laptop. Anyway, thanks for the drivers shared by others that I can download and install into my laptop.

Before I turn the Iphone off, it had been back-up via Itunes, to my Vista Contact, in format of ".contact". In fact, I transfered all .contact into my laptop of XP, and XP unable to read the contacts. I tried to export all .contact to Vcard and transfer in XP, but still unable to read it all, because most of my contacts are in chinese names (both simplified and traditional type).

Here I share out the way I'd done to restore my contacts into my W300.

I downloaded and installed the Windows Live Mail in my XP laptop, because Live Mail able to read the import all the .contact files. Then I export the contacts from the Live Mail as Vcard format. at this point all chinese filenames of my Vcard is preserved.

Afterward, I linked the W300 with my laptop via bluetooth connection. And sent the Vcard files to my W300 via blueetooth. But the limitation is 26 Vcards per transaction as I found so far.

Of course, I have some other problem as some numbers fall in incompatible categories (in Vcard category, there's no phone number called as "Iphone" as stored in Iphone contact, etc) had lost, end up with contacts with just name but no number to call to. Therefore, some checking or modification work needed to be done before back-up the contact via itune to Vista's windows contact. Else, Outlook or other supported Contact Manager may solve this problem too. Please share more if you really have this.

Good luck!



Friday, April 9, 2010

The best bread in my baking history


Initially, thinking of having slices of bread of ordinary square in shape, just to fit in the normal cheddar cheese my sister brought.

Last week, I tried to bake with the loafpan, after so many months left it aside, and baking without it. In my mind, to make the dough grow well entirely, I did it in some special way, which saw from other website, divide the dough into few small pieces, and turn it become rolls, and put together in the loafpan.




The set is nice after an hour, but I'd forgotten the actual baking duration for this suppose to be 40mins. Thus, the bread was wet in the middle part.



Yesterday, just tried to use back the loafpan again. I prepared the biga in the morning before leaving home to office. When i back home around 6pm, roughly after 12 hours, the yeast in biga looks so active. I mix in all the ingredients and start to work with the dough, proving, shaping the dough in rolls, and prove for another one hour.

Biga: 1/4 teaspoon of instant yeast + 1 cup flour (i used wholemeal) + 1 cup water

Dough: Biga + 1 cup wholemeal flour + 2 cups white flour (=50% wholemeal bread) + 1 cup water + 1/2 teaspoon salt + 3 tablespoons of olive oil + 3 tablespoons of sugar + 1/4 cup of milk powder

I think the most essential point for this round is the baking temperature and time. I set the oven to 180degree celcius, and baked for 40mins totally, which the first 30mins loafpan with cover, and remaining 10mins with loafpan cover opened, to have some nice colour on the top.



I guess the flour is too much until no more space for the dough to grow during the baking time.
Maybe for next bake i'll try to reduce it to 3 cups of flour.
Anyway, the round shape of each roll still visible on the loaf.