2008/3/29, Harold Fuchs <[EMAIL PROTECTED]>: > > On 29/03/2008 17:36, Johnny Rosenberg wrote: > > I have a table in calc with 28 columns and 51 rows. For each column I > > manually set borders. For some columns the borders are thin and for some > > other columns the borders are thick. > > Now, I want to add a thin line for every fifth row, to make it easier to > > read. I want to do that with conditional formatting. The first column > > contains row numbers (not the as the number part of A5, for example), so > I > > thought something like IF(5×INT($A1/ 5)) should do it. If it's true I > just > > apply a style called "5". This is actually the third contidion. The > first > > one determines if A1 (in this example) is empty (then apply "Default"), > the > > second one if it is equal to 10×INT($A1/10)) (then Apply "10"). > > > > The problem is, that if I create a new style, in this case "5", and > click > > Borders, then make sure that the lower border is a thin one, the > vertical > > borders disappears! Ok, that's not strange, so I investigated the whole > > thing a bit more and I found that when I click a border twice, it > becomes > > gray, so I thought that would mean "leave it as it was". Problem solved, > I > > thought, but it wasn't! The vertical borders still disappeared wherever > the > > "5" style was applied! Is this a bug? or is this task just impossible? > > > > Of course I could draw the borders manually by just highlighting a five > row > > range and apply the right borders, then another one and apply a thicker > > border, then highlight all ten of those and copy the format over and > over > > again, but I want this to happen automatically as I add new rows, once I > > added the conditional format to every cell that I think is going to be > used > > in this case, in this case a few couple of hundreds. > > > > So, is this a bug or did I just misunderstand everything? > > > > Instead of different borders would different backgrounds do? If so, > http://www.openofficetips.com/category/using-openoffice-calc/page/3/ > explains, among other things, how to get alternating coloured > backgrounds that automatically adjust as you add or delete rows. > > -- > Harold Fuchs > London, England > Please reply *only* to [email protected] > > > Different colours could be a good idea, but still I want to know if the border thing is a bug or not. If it is, I will report it, I guess.
So when I change the borders of a style, does that gray border that shows up when I click the same border line twice mean that the border that was there before the style was applied still remains?If so, it doesn't seem like it works properly OR I am doing something wrong... Example: - Start a new spreadsheet - Right click C5 - Click Format cells... - Click Borders - Click Line arrangement - Default - "Set All Four Borders" (second box from the left) - Click 2.50 pt (Line: Style) - Click OK - Let's say that we want a bog cross over the cell if the cell contains the value 0 (zero), therefore hit F11 - Right click Default - Click New... - Name the style Zero - Click Borders - Click Line arrangement - Default - "Set Diagonal Lines Only", which is the box to the right - Click twice on each of every border line that surround the cell so they become gray - Click OK - Click Format → Conditional Formatting... - Type 0 in the white field so "Cell value is equal to 0" is obtained - Click OK - In C5, enter =A1 Now, when I tried this myself, it actually worked, so now I am even more puzzled... The diagonal lines are added to the original fat border lines, which does not disappear. Oops... OK, I have no clue what I'm doing wrong in the other file in which it doesn't work, I guess it's time for some more debugging... However there is a strange thing in this example too. Remember the "Click twice on each of every border line that surround the cell so they become gray" step? This step doesn't seem to matter at all. It works wether this is performed or not. Now I wonder how I would do if I DIDN'T want the original surrounding borders to appear when A1=0... maybe that's another story though... J.R.
