Hi Meiying, limeiying wrote: > Hi Oliver and all, > > In Calc, View - Value Highlighting, there are two problems. > 1 Choose View - Value Highlighting - F1, open Value Highlighting help > document, it says: > Text cells are formatted in black, number cells in blue, and all other > types of cells, such as formulas, > logical values, and dates, are formatted in green. > But, I find the real result is different with the description in Help > document. > Text cells are formatted in black, (right) > number cells in blue, (right) > and all other types of cells, such as formulas are formatted in green, > (right) > logical values and dates are formatted in blue, not green (* right or > wrong? *), I have no idea. Logical values and dates are only formatted numbers and therefor shown in blue -> error in help >
> 2 Choose View - Value Highlighting and select Value Highlighting, > find text cells, number cells and all other types of cells are formatted > in different color. > But if I reload the file, or page preview and then close preview, pay > attention to the file content, > find there is no value Highlighting in the file. > I don't know it is a right action or not. If it is right, would you like > giving me the right explaination? This is correct. Value highlighting overrules a normal color formatting (e.g if you format a numbercell with a red font the number will be shown in blue if value highlighting is enabled). Due to useability reasons the value highlighting will be disabled if the document is closed or the view is changed (e.g print preview). This was made because often users complained because they thought that they have lost their formatting because they didn't know that value highlighting was enabled. Kind regards, Oliver --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
