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. -- 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
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.
...
73 de Donn Washburn
Randall Schulz
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
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
participants (3)
-
Donn Washburn -
John Sowden -
Randall R Schulz