Uwe Fischer wrote at 10:04 on 18 Jul 2006: > Hi, > > > ... Thank you, Claudia. I'm getting to the point where I believe that this > > functionality does not exist in OOo Calc. I don't know whether Excel has it > > or > > not so I don't know whether this is a compatibility issue. I realize that > > if it > > is not then the likelihood of getting it changed is remote. > > > > I'll give up on this particular styling issue before I change to narrow > > rows or > > columns to simulate borders. There is just way too much baggage associated > > with > > that approach. > > > > I find the Help for conditional formatting to be overly simplistic. *Maybe* > > I'll find time to contribute to the OOo project in this area. > > > > What aspect of the extensive example in the Online Help is overly > simplistic? Where do you need more information? How can we improve the > Help? Did you follow the example to see how to apply conditional > formatting? Then you must have seen that 'Applying Cell Borders' is one > of the hundreds of possible formatting options when you define the new > Cell Styles.
Hi Uwe. Thank you for your response. I am sorry that my remark offended you. In answer to your last question first, Yes I did follow the example to see how to apply conditional formatting. As I stated before, it works beautifully for defining the font to be used, the font effects to be used, the alignment of the displayed data, and the background. I believe it also works for the formatting of numbers. But, I cannot get it to work with generation of borders. FWIW, I also have not been able to figure out how to make use of the Cell Protection tab whether for conditional formatting or not but that's a separate issue and off topic for this thread. I know Cell Protection works because I've seen it used but I don't understand it enough to activate it myself. As for your other questions, the Help always seems to imply that one would be using the "Cell Value Is" option but ignores the "Formula Is" option which does not need to make any reference to the value that is in that cell. I have made extensive use of this capability. And, yes, I had already thoroughly read the Help for Conditional Formatting that you very kindly quoted in case I had missed it. As a demonstration of my problem, I would like you to try applying conditional formatting that is designed to set border styles conditionally. Let's say for the sake of the test that all even numbers in a set of random numbers are to have a 2.50 pt Light Red border on the bottom edge of the cell while the odd numbers are to have a 1.00 pt Light Green border on the right edge of the cell. Please try this and let me know how you get it to work. I can't. Thanks once again for taking note of my frustration and contributing to the discussion. -- Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
