Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DOM objects not available when script is first run?
Thanks for your reply. I'm using external script file, so can't use your suggestions, but further search confirms my observation that the DOM objects are not available until the page loads. Don't know where this simple fact is explained in DOM tutorials. Global event handler - window.onload -...- gs99
- Post #3
- Forum: Javascript
-
DOM objects not available when script is first run?
Need to change objects depending on cookie values when script is first run. Apparently the objects are not available, as seen in this test: In html file: <h3 id="hh1">Test color change in header</h3> <input type="button" onclick="setColor()" value="Change color of header" /> In Javascript...- gs99
- Thread
- Replies: 5
- Forum: Javascript
-
Change style sheet via document.getElementById
Thanks Jeff I assume "return false" needs to be used always when JavaScript processes a form? This is a new topic for me. I understand "return true" executes the default action after JS code completes; "return false" skips the default action. In this case, the default action is to...- gs99
- Post #3
- Forum: Javascript
-
Change style sheet via document.getElementById
Trying to have html file that enables user to change font styles, starting with headers. Using Internet Explorer 7. Html file has external CSS and Javascript files and a form: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> <html...- gs99
- Thread
- Replies: 3
- Forum: Javascript
-
Include footer and header when printing pdf web page
I need to clarify something: I stated that I have Acrobat 7; should have said Reader 7. I downloaded the free product to print pdf web page files. So when I do that, the main application is Internet Explorer. So your suggestion "Use File menu/create pdf/from web page" does not make sense...- gs99
- Post #5
- Forum: Adobe: Acrobat
-
Include footer and header when printing pdf web page
What application are you referring to? I don't know what OSX and G4 mean. In IE or NN there is no File | Create PDF. In the meantime I installed Acrobat 8; it behaves in same way.- gs99
- Post #3
- Forum: Adobe: Acrobat
-
Include footer and header when printing pdf web page
Internet Explorer 7, Adobe Acrobat 7.0 Printing a web page in pdf format. Is there a way to include the browser's header and footer in the printout? example: http://www.hhs.gov/ocr/hippahowtofile.pdf I've tried all options shown in the "print" dialog. If page is pdf, IE File | >Page Setup...- gs99
- Thread
- Replies: 5
- Forum: Adobe: Acrobat
-
Sum of digits in spreadsheet cell
combo, The Fibonacci series starts: 1,1,2,3,5,8,13,21 ... The expected reduced digits: 1,1,2,3,5,8, 4, 3 ... Your formula: Enter in A Excel gives ------------- ----------- 1 1 1 2 1 1 3...- gs99
- Post #27
- Forum: Microsoft: Office
-
Sum of digits in spreadsheet cell
yogia, The two-step "cell formula" solution by combo (and xlhelp) on Jun 15 works fine. But a "program" solution (See Add2Strings function) seems to be required because of the problem Excel has incorrectly adding large numbers via cell formula =SUM(A1,B1). Therefore a second function is...- gs99
- Post #25
- Forum: Microsoft: Office
-
Sum of digits in spreadsheet cell
combo, To avoid the "addition" problem, I'm using your VBA Add2Strings. The VBA code in your For-Next does not reduce to a single digit. I made this VBA function code with Str1 input: Do Until Len(Str2) = 1 nDigitSum = 0 'reset in each loop For i = 1 To Len(Str1) 'Str1 is input...- gs99
- Post #24
- Forum: Microsoft: Office
-
Sum of digits in spreadsheet cell
I made a VBA sub that calls the function Add2Strings. (needed to add "Dim i as integer") It seems to work OK; I stopped at number 96 that has 20 digits. Number 73 sum is correct 1,304,969,544,928,657. Now I need help to convert the formulas to VBA code. Col B...- gs99
- Post #19
- Forum: Microsoft: Office
-
Sum of digits in spreadsheet cell
I started the Office 2007 Online Trial. Excel 2007 adds my numbers in the same incorrect way: 1,304,969,544,928,660. That is a problem. Excel knows how to show error messages; why doesn't it tell me there is a problem? >Gavin said "I still need half an hour to get my head around it - or why on...- gs99
- Post #18
- Forum: Microsoft: Office
-
Sum of digits in spreadsheet cell
combo, Thanks, your "two-step" code works. I could not copy the code from your post. Had to type the formula into cell B1, then CTRL+SHIFT+ENT as you indicated. The formula then appears within curly braces. I can copy that formula into other cells. A problem started to appear at number 74...- gs99
- Post #12
- Forum: Microsoft: Office
-
Sum of digits in spreadsheet cell
xlhelp, Thanks, your code works. I'm doing a spreadsheet on Fibonacci series, to display the discovery that there is a recurring 24 pattern. It works OK until the 46th number at which point it gives a #NUM! error. The 45th number is 1,134,903,170 (= 2). The 46th number is 1,836,311,903...- gs99
- Post #4
- Forum: Microsoft: Office
-
Sum of digits in spreadsheet cell
Is there a way to get a sum of the digits in a cell? If the number is 123, the sum is 6. I beleive it is called "number reduction". Thanks- gs99
- Thread
- Replies: 28
- Forum: Microsoft: Office
-
Formula Range.Dependents - No Cells Found
Thanks, I had the terms reversed. Precedents show the Cells referenced in a formula. Dependents show the Formulas that reference a cell. I'll try to picture President Bush showing me prison Cells.- gs99
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Formula Range.Dependents - No Cells Found
What VBA code obtains information about formula dependents? Help provides this format: Range("A1").Dependents.Select When I use this for a cell that has a formula, I get a VB message "No cells were found". I really don't want to select it, I'm looking for code to obtain the "dependents"...- gs99
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
-
Formula Range.Dependents / Range.HasFormula
Update on Range.HasFormula, if cell has "=D1", it's working now. Thanks, George -
Formula Range.Dependents / Range.HasFormula
How does VBA obtain information about formula dependents? Help provides this format: Range("A1").Dependents.Select When I use this for a cell that has a formula, I get a VB message "No cells were found". I really don't want to select it, I'm looking for code to obtain the "dependents" info...
