Dan Lewis wrote (Donderdag, Oktober 18, 2007 10:55 pm)
> How did you set the borders that you can not remove? > Did you do it with a style, or did you use the Borders icon in the toolbar? > If you used the Borders icon, you are right. > Styles will not remove a border created using the Borders icon. I set the borders with the cell properties - borders tab. Than I apply the style (the style that says: 'no borders') It removes the borders, (but not the diagonal one from left top to bottom right) (but my 'problem' is that I want to remove the 'no borders' from the style so when applying the style it does not change any existing borders) > If you create a new style by only changing the background, > whatever borders are there will remain. This is correct. I also want this to happen when I only set borders (whatever the background is, it remain), but unfortunately, the background is always changed when applying a style. But reading all this and testing some more I begin to think that styles are not the way for me to achieve my goal, although is somehow works. What I really need is a cell that shows some values per weekday to have a gray background when it is saterday or sunday and white the other days *without* changing borders. I've managed this by using conditional formatting which applies a style with a different background depending of the kind of day. Unfortunately I accidentally changed the borders on one style (just to see how it works) and I was not able to remove this 'no border' setting from the style in CALC. So I edit style.xml to remove the border setting. Anyway thanks for your help. Wim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
