Skip to main content

Posts

EXCEL Rows and Column LIMITATION

Max. Rows Max. Columns Max Columns by letter Excel 2010 1,048,576 16,384 XFD Excel 2007 1,048,576 16,384 XFD Excel 2003 65,536 256 IV Excel 2002 (XP) 65,536 256 IV Excel 2000 65,536 256 IV Excel 97 65,536 256 IV Excel 95 16,384 256 IV Excel 5 16,384 256 IV More info here

Canon iP2770 resetter (How to reset waste ink pad counter)

1. Enter "Service Mode" Turn off the printer Hold down "Resume button" then press "Power button" Keep holding down Power button and let Resume button go Press Resume Button 5 times while holding down the Power button Then let BOTH buttons go. You will see that the Alternate blinking error is gone, this means that the printer is in Service Mode State. 2. Using the Resetter - Download the resetter here - Extract the file - Run Servicetool.exe - Press "Main" button - Press "EEPROM Clear", if pop up appear jusst click "OK" - Power off the printer Credit from this link http://pcmediks.blogspot.com/2010/10/how-to-reset-canon-pixma-ip2770.html Done!.

CSS Selector

Often times, I've seen CSS example with '>' (greater than) sign and '+' (plus) sign, so I ask my bestfriend (google.com) of what is it stands for. Thereafter, he directed me into this link http://www.quirksmode.org/css/selectors/

[Skype Error] Fatal Error - Failed to get proc address for GetLogicalProcessorInformation (KERNEL32.DLL)

Error: Got this error on Windows XP machine Solution: Update your OS into Service Pack 3. http://windows.microsoft.com/en-us/windows/help/learn-how-to-install-windows-xp-service-pack-3-sp3 -- OR -- Downgrade your skype into older version like 6.0.0.120 . You can find old versions  here .

(phpmyadmin) Import sql file with [BLOB] fields Error

I am trying to import my MySQL database into another server through sql file but i get this error (see image below). This was only happen if the database has a [BLOB] field. Solution: Goto "../xampp/mysql/bin/" folder Open "my.ini" file Change the value of "max_allowed_packet" into higher something like 100M. max_allowed_packet = 100M Restart Apache and MySQL service