Box.net a nice place to share and store files December 31, 2008

Box.net to store, share, edit, access and collaborate on files worldwide. this helps anyone share and access their data anywhere.

it gives 1GB space free. So you can enjoy uploading and sharing.

i am not advertising .. i enjoyed the interface there and trying to let ppl know about good things ..

thanks

box.net

XLS: DATE() function to convert integer to date and get date difference December 11, 2008

Problem: I have two cell with integer value like this in A1: 20080101 and n C1: 20080116. These are dates but in integer field. I need to put the difference of date between C1 and A1 in B1

Solution: click on B1 in the function bar type this:

=(DATE(LEFT(C1,4),MID(C1,5,2),RIGHT(C1,2)) -DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)))

and press enter.

its solved.

Internet explorer loads same image more than once with ajax December 5, 2008

In Internet Explorer  when an html is loaded with image inside if the image is same in all img tag internet explorer loads the image each time it foinds in img tag.. this makes the ajax loading slower. AJAX is used to make a web page faster but IE seems having problem with that.

To solve this i have applied an idea .. searching google i came to know that IE loads single time of same image located in style background of an element. so I made img tag to div with style background property to the src of the image … now if i load 100 of that div via ajax it loads only one time. Thus my web page loads faster in IE.. Thanks to FireFox it behaves nice with this problem.

Hope this helps

connect ubuntu/linux with xp pc with cable December 5, 2008

install samba in ubuntu.

connect both pc with the cable via lan.

set IP address:

for example the ubuntu has IP: 192.168.200.125

and gateway: 192.168.200.1

then in XP pc set IP to 192.168.200.126

and gateway to 192.168.200.1

both are connected now.

cheers