On Sun March 11 2007 12:43, Brian Barker wrote: > At 12:18 11/03/2007 -0800, John R. Sowden wrote: > >>The following formula stopped working when I started a new sheet > >>for 2007. The part that is not working is the test of the cell I7. > >>=IF(I7="E";L6+F7-G7;L6+F7) > > > >The clean(I7) function had no effect. The left(trim(I7)) function > >solved the problem. > > Good-oh! > > >To me this means that there must be something else in the test cell > >other than E > > Indeed. > > If you want to investigate further, try looking at the value of > "=LEN(I7)", entered into a spare cell. If the value is anything but > one, you can see there's something else in I7, in addition to your "E". > > Then copy the entire cell I7 and paste it into a new Writer > document. But instead of using the normal Paste, use Edit | Paste > Special... and then select "Unformatted text". This will paste the > text, but without the containing cell. Switch on View | Nonprinting > Characters, and you will then see an indication of anything > extraneous that you also have in I7 - such as a blank or blanks. > > Brian Barker this is very interesting. The len() function produced a value of 0 when the cell was empty. When I entered a letter, without using the 'Enter' key, just the down arrow, the value switched to 2.
I then used writer, as you suggested, and found the second, non-printing character is 2 vertical lines with a half sphere on the top left side of the left vertical line. Wait! It get better. I then performed the len() function on a cell in my 2006 sheet. I showed zero when empty, and 1 with a letter, whether I exited with 'Enter' or an arrow. I am beginning to think that the previous sheet was created with a previous version of OOo, and therefore works differently. This is something that the OOo gurus should look into. -- John R. Sowden AMERICAN SENTRY SYSTEMS, INC. Residential & Commercial Alarm Service UL Listed Central Station Serving the San Francisco Bay Area Since 1967 [EMAIL PROTECTED] www.americansentry.net --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
