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?
