GOOGLE SHEET cell data linking

To make a link to ONE cell on another sheet (within the same spreadsheet file) in GOOGLE SHEET :

*  =SheetName!A1

*  ='Long Sheet Name'!A1


For a range (MORE THAN ONE) of cells :

=arrayformula('Long Sheet Name'!A1:C4)

For the whole columns :

=arrayformula('Long Sheet Name'!A4:C)

For the whole rows :

=arrayformula('Long Sheet Name'!A3:4)

Make sure that the target cells are empty when using =arrayformula, or it will give out error message.

==========

To make a link to a cell or a range of cell on ANOTHER file,  use =ImportRange function.

*  =ImportRange("file key";"Sheet Name!A1")

Blogging tool : Open Live Writer

I used Google Drive and Docs heavily.  I do blog occationally on blogger.com.  Both blogger.com and Google Docs are owned by the same company, but somehow, it is not possible to publish a Docs to blogger.com

Microsoft came to the rescue!!! :D

Their free product Live Writer can publish directly to blogger.com.  It was ported and called Open Live Writer (under .NET foundation).
Open Live Writer is like a mini and simplified word processor with the main feature of being able to publish to many major blog such as Wordpress and Blogger.com
This was my first test.

Place to find older version of iTunes (and other apps)

Maybe at some point in your life, you just want to downgrade your iTunes.  This is the place to go http://www.oldapps.com/itunes.php

Why do you want to downgrade your iTunes??  I don't know.... maybe you're trying to prison break???  :P

iPhone stucked and iTunes won't recognize it? It's DFU time! :D

Once in a while, when you're toying with your iPhone (for example trying to jailbreaking or trying to unlock a locked iPhone), your iPhone can get confused and it will just stuck like the image on the left.  Worse, your iTunes won't recognize your iPhone too.

What to do?

Do the DFU thing.

1.  Shutdown your iPhone by holding the power button until it shows "Slide to Power Off".  Slide to power off.

2.  Make sure that iTunes is running and the iPhone is connected thru USB to your computer.

3. This is important.  Press HOME and POWER button at THE SAME TIME for 10 SECONDS.  After that RELEASE the POWER BUTTON *BUT* KEEP PRESSING the HOME BUTTON.

4.  Keep pressing HOME button, until iTunes recognize your phone, and ask you whether you want to restore it.

A pretty good video guide can be found here :
http://www.idownloadblog.com/2010/12/01/how-to-put-iphone-in-dfu-mode/

or search YouTube.  There're tons of these videos.

How to softmod Wii so you can play "backup" games.

This site has pretty good instruction on how to do it : Complete Softmod Guide

Pic source : Life Hacker

How to downgrade iPhone 3G(S) from version 4.x.x to version 3.x.x.

Why do I want to do that? you may asked.
 1. If you don't know why, then why bother.
2. Because version 4 is way way to bloated for ya old iPhone. If ya aint gonna miss the extra feature, or if you don't know what's the different between 4 and 3, then why bother.

Article from Life Hacker

Installing VNC in Debian

To install VNC server in Debian :

apt-get install vnc4server

To install VNC viewer / client :

apt-get install xvnc4viewer

After installing the viewer, type
Xvnc4viewer [hostname]

Chat setting for Google Talk for my domain.

From http://www.google.com/support/a/bin/answer.py?answer=49147

*****

How do I configure Gaim to connect to Google Talk for my domain?

Once you download Gaim, you'll need to configure your client to connect to the Google Talk service. If you're not a Google Apps for Your Domain user, please visit the Google Talk Help Center for instructions.

To configure your account:

1. Open Gaim.
2. Click Accounts at the bottom of the login page.
3. Click Add from the Accounts window.
4. Enter the following information in the Add Account window:

* Protocol: Jabber
* Screen Name: Your Google Talk username (without any @ symbol or domain).
* Server: Enter the portion of your email address after the @ symbol. For example, gordon@example.com will enter example.com as the Server value.
* Password: We suggest leaving this field blank for increased security, but if you'd like to log in automatically, enter your password.
* Alias: Leave this field blank.
* Remember password: Check this box if you'd like Gaim to remember your password (you won't be prompted to enter it each time you log in, if you select this option).
* Auto-login: Check this box if you'd like to connect to the Google Talk service each time you use Gaim.

5. Click the + next to Show more options.
6. Enter the following information in the section that appears:

* Jabber Options: Select Use TLS if available and leave the other boxes unchecked.
* Port: 5222
* Connect server: talk.google.com
* Proxy type: Use Global Proxy Settings

7. Click Save.

Congratulations! You're now ready to connect to the Google Talk service using Gaim.

Have questions about Gaim? Learn from the experts! Check out Gaim's FAQs. The Google Talk Team can only assist you in configuring your client to work with the Talk service.

SquirrelMail with UW-IMAP problem

By default SquirrelMail will have problem when trying to login into UW-IMAP server.

This FAQ @ squirrelmail explain the work around : link

Basically :

- reconfigure uw-imap server to provide imaps :

dpkg-reconfigure uw-imap

- run /usr/sbin/squirrelmail-configure

- Select option D and set to the option to uw

- Return to Main Menu and select option 2. Server Option.


- Select option 4. IMAP Server

- Set 5. IMAP Port to 993, and 7. Secure IMAP (TLS) to true

- Save, and Quit.

This will connect the squirrelmail to uw-imap server.

By design, UW-IMAP server does not allow plain text login for the reason of security. And squirrelmail only support plaintext login because of some limitation from the php ssh module, and some restriction from squirrelmail IMAP implementation. (http://www.squirrelmail.org/docs/admin/admin-10.html)

solving stucked debian package

If we tweak alot with our system, apt-get install this apt-get remove that, we might bumped into this error :

No override present.
dpkg: error processing cyrus-common (--remove):
subprocess post-removal script returned error exit status 2
Errors were encountered while processing:
cyrus-common
E: Sub-process /usr/bin/dpkg returned an error code (1)
m

I was installing cyrus, and then removing, and then reinstalling again. And then want to remove again, then I bumped into this error.

I can't remove cyrus-common. I tried it with apt-get, dpkg, dselect, aptitude, synaptic, kpackage. It just stucked as installed, but when I tried to remove, it gave me that error.

Googled for a while. Find no paticular solution for my error, but found a tip that I should peek into /var/lib/dpkg/info/
Checked out cyrus-common.postrm file, commented out the first two of dpkg-stateoverride line. Save the postrm file. Run apt-get remove cyrus-common.
The command executed and exited gracefully, and deregister cyrus-common from dpkg list.

This is a quick and dirty solution. Basically I commented out the commands so that postrm will exit gracefully.

Panduan apt-get dpkg untuk pemula

Link untuk panduan apt-get dan dpkg untuk pemula.

http://linuxhelp.blogspot.com/2005/12/concise-apt-get-dpkg-primer-for-new.html

Postfix NIS lookup error

If you install postfix in debian (3.1) by using apt-get install postfix, then most likely there will be an NIS lookup error such as :

Jan 30 09:48:01 localhost postfix/smtpd[11719]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled

To eliminate the error, go to main.cf and erase or comment out any references to nis: such as aliases = nis:alias.name

Postfix postdrop error

I installed Postfix mail server on Debian 3.1. Pretty straight forward installation and run with no problem.

Then I add 10+ user using webmin and "user and group" application from the GUI itself (gnome). Suddenly, somehow, postfix failed.

The error msg was :

Jan 29 17:02:03 localhost postfix/smtpd[2238]: fatal: file /etc/postfix/main.cf: parameter setgid_group: unknown group name: postdrop

Searched the google, but couldn't find a solution for the problem.

I sent a question to the local postfix mailing list, but somehow, the email didn't went thru (the mail server kept rejecting my mail).

Anyway, I dpkg reconfigure the postfix

dpkg-reconfigure postfix

And it fixed the problem!! The error dissapeared and postfix started perfectly.

Adding an alias to an ethernet interface using ifconfig

To add an address to an ethernet interface :

ifconfig ethx:n [ipaddress]

where :
x = ethernet number
n = alias number

example

ifconfig eth0:1 10.0.0.10
will add 10.0.0.10 to eth0 in addition to the existing ip address [eth0]

Link : Setting up IP Aliasing on A Linux Machine Mini-HOWTO

Monitoring incoming and outgoing mail in SME Server

To monitor ALL the incoming and outgoing mail that goes thru the system :


config setprop qpsmtpd Bcc enabled BccUser signal-event email-update


All the email will be automatically BCCed to .

To turn off this Bcc feature :
onfig delprop qpsmtpd Bcc enabled BccUser signal-event email-update

It won't delete user, it'll just disable the Bcc function.

http://contribs.org/viewtopic.php?p=138113#138113

Changing password complexity in SME Server

To change password complexity, login as root and :


config setprop passwordstrength Users normal
config setprop passwordstrength Ibays normal


It is also possible, but strongly discouraged, to disable password strength checking:


config setprop passwordstrength Users none
config setprop passwordstrength Ibays none


http://contribs.org/viewtopic.php?t=34609&highlight=password