Re: [users] meaning and the effect of 0

2009-11-09 Thread Harold Fuchs
2009/11/9 Walter Hildebrandt wh2...@gmail.com What does 0 mean and what is its effect in various condition? In a numeric context, 0 means zero. If you try to treat *text* in a numeric context then the text will usually be treated as zero. For example : When I got the formula

Re: [users] meaning and the effect of 0

2009-11-09 Thread Harold Fuchs
2009/11/9 Harold Fuchs hwfa.openoff...@googlemail.com 2009/11/9 Walter Hildebrandt wh2...@gmail.com What does 0 mean and what is its effect in various condition? In a numeric context, 0 means zero. If you try to treat *text* in a numeric context then the text will usually be treated as

Re: [users] meaning and the effect of 0

2009-11-09 Thread Walter Hildebrandt
You ask Why don't you use the Conditional Formatting menu to do what you want? I was told that Styles was a good way to do what I wanted to do so I decided to use Styles I had no experience and very little understanding of either Styles or Conditional Formatting. I assumed Styles was easier to

Re: [users] meaning and the effect of 0

2009-11-09 Thread Johnny Rosenberg
2009/11/9 Harold Fuchs hwfa.openoff...@googlemail.com: 2009/11/9 Walter Hildebrandt wh2...@gmail.com What does 0 mean and what is its effect in various condition? In a numeric context, 0 means zero. If you try to treat *text* in a numeric context then the text will usually be treated as

Re: [users] meaning and the effect of 0

2009-11-09 Thread Johnny Rosenberg
2009/11/9 Walter Hildebrandt wh2...@gmail.com: You ask Why don't you use the Conditional Formatting menu to do what you want?  I was told that Styles was a good way to do what I wanted to do so I decided to use Styles I had no experience and very little understanding of either Styles or

Re: [users] meaning and the effect of 0

2009-11-09 Thread Harold Fuchs
Walter Hildebrandt wrote: You ask Why don't you use the Conditional Formatting menu to do what you want? I was told that Styles was a good way to do what I wanted to do so I decided to use Styles I had no experience and very little understanding of either Styles or Conditional Formatting. I

Re: [users] meaning and the effect of 0

2009-11-09 Thread Walter Hildebrandt
Harold, you wrote the following: Now that you have the correct syntax, using styles is the way to go as they are more generally useful throughout OOo, not just in Calc. My first decision was to use Styles instead of Conditional Formatting because Styles seem easier for me to use than Conditional

[users] meaning and the effect of 0

2009-11-08 Thread Walter Hildebrandt
What does 0 mean and what is its effect in various condition? For example : When I got the formula =A1-40+IF(A140;STYLE(RedText);0), I was told “The STYLE function always returns 0, so the formula is mathematically equal to A1-40+0” What is effect of the 0 at the end of the formula? For