Question: How can a Calc cell Style property be changed to be "as-is", i.e., to
not have any effect on the cell(s) to which the Style is applied?
Initially, styles such as "Heading" have no effect on number formats or
background color (for example). Applying Heading to a colored cell does not
change the color.
However, if the "Heading" style definition is changed to specify a background
color, how can
the original behavior be restored, i.e., so it has no effect? If background
is set back to "No Fill" in the
Heading style, then it thereafter FORCES cells to be white, that is, it no
longer preserves the
previous color of the cells like it used to do.
In summary, how can a Style definition which specifies a property different
than the Default style be restored to not specify that property at all (like
the built-in styles do for many properties, initially)?
DEMO:
1. Format->Styles and Formatting (displays the S&F window).
2. Type text into some cells, and change their background color to GREEN.
3. Select a cell (so the black box appears). Click "Heading" in Styles and
Formatting.
-> The font gets bigger, but the cell remains GREEN. The Background is not
changed.
4. Modify the definition of the Heading Style (rightclick-Modify in Styles and
Formatting),
and specify a RED background.
5. Modify the definition of Heading back to the way it was, i.e., specifying
"No Fill" for Background.
6. Repeat steps 2 & 3. This time applying the "Heading" style does not
preserve the color, but forces it to be white.
