My msg to the lsit has bounced 3 times, not sure why, I'll try it to you. Also, I am interested in your filepro program. as I am still using Foxpro/Dos on our network (not windows). I am looking for a similiar database, but they all seem to be for 'enterprise' size operations in Linux. Does yours work on linux? where can I get it? Is the the same filepro as the one for Mac/Windows? John 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 have tried "=if(G4>"";G4;G2)" and it fails. ERROR:544 (as I remember)
By the way OpenOffice 2 works well in SuSE 9.3.
It seems that you want a value and a formula in the same cell. I had this problem in a Debit Credit Balance sheet where I did not want the balance displayed down the page when there were no entries. The Item, or description cell was c5. The balance collumn was f5. =iif(c5="";"";f4+d5-e5) The comparison was to another cell. If there was text in the Item field, the the balance was displayed. I use this to flag notes in off screen fields, and to display hours in a day on a payroll sheet, so I don't pay for more than 24 hours of dispatch time in a day. The other issue that may be a problem for you is that you are using a numeric comparison function to test a string variable. This may not be an issue, I never do it. Hope this helps, --- John Sowden American Sentry Systems. Inc. 1221 Andersen Drive San Rafael, CA 94901 U.L. Listed Central Station Alarm Service Serving the San Francisco Bay Area Since 1967 mail@americansentry.net http://www.americansentry.net