Search results for query: *

I have formatted certain cells of my spreadsheet to indicate time in the format hh:mm using the custom cell formattihg option. With this method, everytime I enter a time say 19:30, I have to insert a colon using the shift key and all. Is there a way by which I can simply type in the four...

I have formatted certain cells of my spreadsheet to indicate time in the format hh:mm using the custom cell formattihg option. With this method, everytime I enter a time say 19:30, I have to insert a colon using the shift key and all. Is there a way by which I can simply type in the four...

I have 10 sheets in my Excel workbook. In cell D5 on sheet1, I have the number 1. If I want that number to increase by 1 in cell D5 on sheet2, what formular should I use in cell D5 in sheet2? The obvious answer would be: =Sheet1!D5+1 But if I copy that formula on to sheet3, cell D5 on...

I have a directory full of Excel files. All the files are of the same format. I want to look for a file (spreadsheet) that has the number (not text) 9.543 in cell D10. Is there a search utility that allows me to do something like that? I can't seem to do it with conventional search utilities.

I would like my web page to have a gradient background. Now I did a search and came up with the famous Background Fader Script. However, this script has an animation between many colours. What I want is a simple steady gradient between two colours. No animation, no fancy stuff. I can't seem to...

In MS Office 97, I could protect one section of the Word Document, while leaving the other section free to be edited. I am ofcourse talking about protection for forms. In MS Word 2003, they have changed the complete dialogue box for protection and I cannot find any way that I can protect one...

I have formatted a few cells in my spreadsheet to wrap the text within them. My question is: Is it possible to break lines (like make paragraphs) in that cell? Or do I have to make do with one paragraph.

I have some numbers and some uncalculated formulas as follows: A1: 123 A2: 567 A3: #VALUE! A4: 856 A5: #DIV/0! Now, I want to add them all up by using the sum formula =SUM(A1:A5) but I want to add only the valid numbers (123, 567 and 856) and ignore the uncalculated formulas (#VALUE! and...

I get input from the textarea of an HTML form. I store it in a database file. It is normal for people to hit the carriage return (enter) key a couple of times at the end of a paragraph, and start a new one with a blank line inbetween paragraphs. So far, so good. I replace the carriage returns...

I have made a splash screen for my spreadsheet, which shows-up for a couple of seconds when one opens the spreadsheet. Then it disappears. I created it using the instructions on http://www.ozgrid.com/Excel/excel-splash-screen.htm I made a userform and then a macro to kill that form etc. etc. So...

I have made a splash screen for my spreadsheet, which shows-up for a couple of seconds when one opens the spreadsheet. Then it disappears. I created it using the instructions on http://www.ozgrid.com/Excel/excel-splash-screen.htm I made a userform and then a macro to kill that form etc. etc. So...

I have created a form in Word XP with some text fields and some check boxes etc. Now, I can only operate the document as a form after protecting it for forms. Say for some reason, after filling in part of the data, I need to unprotect the form. When I re-protect it, I lose all the data that is...

Has anyone tried any of the Perl Obfusators or any of the on-line Perl Obfuscating Services? I have downloaded a freeware and tried out an on-line service. I first tried it on a simple "Hello World" script. However, in each case, I found that it was not very friendly when I tried to print...

I have a script for uploading files to the web server. The code is as follows (I use cgi-lib.pl): #!/usr/bin/perl # Copyright (c) 1996 Steven E. Brenner # $Id: fup.cgi,v 1.2 1996/03/30 01:35:32 brenner Exp $ use CGI::Carp qw(fatalsToBrowser); require "./cgi-lib.pl"; $ref_number = 12345...

Being an Office Bearer of a modest sized association and its webmaster at the same time, every once in a while I need to send out emails with attachments to all the members. I have created an HTML form in which I type the subject and body of the email. This in turn activates a Perl script...

I have a webpage. On that webpage, there is a javascript link, which when clicked, prints out the page. The problem is that the info on that page requires the page to be printed out in the landscape mode and not in the portrait mode. So, is there a javascript which will alter the page format...

I have a database in the form of a text file, where the fields are segregated by a pipe "|" character. The HTML form that sends the data to my cgi script has many fields. I would like to remove the pipe character from all of the incoming data, if accidentally or intentionally input by the...

I have a script which gives me the day of the millenium. It goes something like this: #!/usr/bin/perl require "cgi-lib.pl"; print &PrintHeader; # Get the date and time information ($Seconds, $Minutes, $Hours, $DayInMonth, $Month, $ShortYear, $DayOfWeek, $DayOfYear, $IsDST) = localtime(time)...

I would like to discourage the usage of ALLCAPS on my HTML forms. How do I detect using perl, if someone has used ALL CAPITALS for a form field input? Thanks for your help.

I have copied some text from a webpage and used it in a form texarea. This text gets saved as data. The text as copied looks like this: --------------- The Mercure Inn Continental Broome is located 1km from the heart of Broome and a short 10 minute drive from Cable Beach, set in tropical...