Given that nobody has responded to this in the more than 72 hours that have passed since I posted it I am going to assume that what I'm trying to do is so exotic that nobody else on this list has ever tried it. Thus I now ask a new question. Is there a better place to post my original message?
I'm sure that those who programmed this part of OOo could give me an answer even if that answer is, "why would anyone in his right mind want to do that?!?!?" My answer to that is that Calc is used for more than standard business spreadsheet purposes. I'm using Calc as the framework for program that serves as a tool to assist in solving Sudoku puzzles. I want to be able to hide a copy of the puzzle diagram (thus the question about conditional formatting of borders) until the puzzle has been fully initialized. I'm currently working on my second version of this tool adding more bells and whistles. When I go to my third version I will have to pick a more suitable "programming language" to accomplish the task since I'm bumping up against limits in Calc such as no more than three conditions can be programmed for conditional formatting and conditional formatting formula length is limited to 969(?) characters. Calc was just a good tool for keeping track of over 1300 program variables in the first version and over 1500 in the second. Believe me, I experienced enough bugs in my application as it was. James E. Lang wrote at 12:47 on 12 Jul 2006: > I am using Calc from the Novel Edition of OpenOffice.org 2.0 (build 2.0.0.1). > > I want to eliminate all borders in certain cells when another cell contains > the > text "Special Case" and in order to accomplish this, I defined a style > "borderless" using a blank cell in which I had eliminated all borders. > > In cell AN2 I normally have 4.00 pt automatic color borders top and left. In > that cell I selected "Conditional formatting ..." from the "Format" menu. I > then selected Condition 1 Formula is AK38="Special Case" and Cell Style > borderless yet when cell AK38 contains the text "Special Case" the 4.00 pt > automatic color borders top and left remain. These borders are *not* the > result > of adjacent cells. > > What am I doing wrong? Are borders something that cannot be defined via the > conditional formatting mechanism? Other conditional formatting triggered by > the very same formula but used only to set font, font effects, alignment, > and/or background colors work just fine. > > -- > Jim > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
