Randall R Schulz wrote:
Donn,
On Sunday 29 May 2005 04:34, Donn Washburn wrote:
Hey Group;
In my passed good life I used a datebase called filepro. Filepro was a very good simple to program UNIX based DB with creation and runtime modules. It had a function that allowed a person to test "while entering field". I would like to use this function on a MS/OO spread sheet. Example - If cell "G2" (formatted-DATE 05/29/05) set to =TODAY() then every time I call up the sheet it changes to todays date. Not desireable!
I would like to make a test on cell G4 for "while entering field" G4 ; if G4 equal "" - make G2 equal to G4 ; if G4 is greater than "" do nothing (or stay with G4s value). Example - "=if(G4>"";G4;G2)" NOTE:I may have the result backwards Anyone know of a way to do "while entering field" with a spread sheet.
I don't know what you mean by "while entering field" or why you quote it every time.
I have tried "=if(G4>"";G4;G2)" and it fails. ERROR:544 (as I remember)
There are three spreadsheet programs installed on my SuSE 9.3 installlation: Gnumeric, KSpread and OpenOffice.org. I guess you're using OpenOffice.org? I'm fond of Gnumeric, myself.
In Gnumeric, your example works as-is if you replace the semicolons with commas. Thanks Randall; I will give that a try! OpenOffice docs are not clear about ";" and "," I may learn something new!
Randall Schulz
That is a function which checks the cell before entry and the test function does anything to the data in the cell. So, it tests the data before modifing the data. By doing that, the data can be tested and left alone. If you use =TODAY() it will alter the data before it can be tested. I have used over the years "sc" and "multiplan" plus brand X excel and OpenOffice 1 and 2 (which works in SuSE). I prefer a database program but the place I am working (hard heads) only used spread sheets and try to make them multiuser (no kidding) under that faulty Redmond OS software. Neat thing is OpenOffice works very well with file.xls. It will even unlock the MS locked cells without the MS password. Very handy! -- 73 de Donn Washburn Hpage: " http://www.hal-pc.org/~n5xwb " Ham Callsign N5XWB Email: " n5xwb@hal-pc.org " 307 Savoy St. HAMs: " n5xwb@arrl.net " Sugar Land, TX 77478 BMW MOA #: 4146 - Ambassador LL# 1.281.242.3256 " http://counter.li.org " #279316