https://bugs.documentfoundation.org/show_bug.cgi?id=116261
--- Comment #15 from Stéphane Guillou (stragu) <[email protected]> --- (In reply to Heiko Tietze from comment #13) > Cannot confirm. Is View > Value Highlighting / Ctrl+F8 on or off? (If on all > colors are gone.) Value highlighting is off for me. I have noticed that using the formula bar vs editing directly in the cell does matter for reproducing the bug, and that this is not just about formulas in 7.6 anymore. Steps: 1. Open Calc 2. enter the following string in a cell, but don't press Enter: + one A1 two 3. make "one" red, press Enter -> quote prefix is not added even though the formula is not valid; formatting persists 4. select cell, and _in the formula bar_ add a space at the end of the string -> partial direct formatting is lost; prefix is again hidden when out of edit mode So it seems that editing the value in the formula bar automatically interprets it as a formula, and therefore removes the formatting, even if the end result is still an invalid formula. This is the same in OOo 3.3, but note the differences between OOo 3.3 and LO 7.6: - format lost in LO 7.6 even if there is no cell reference (using only "+ one two") - format lost in LO 7.6 even if there is no +/- (using only "one two") - format lost in OOo 3.3 even when editing directly in the cell Somewhat related: Steps: 1. Open Calc 2. enter the following string in a cell and press Enter: + one A1 two -> note the ' prefix is automatically added, because not a valid formula 3. make "one" red, press Enter -> quote prefix does not automatically hide anymore when out of edit mode 4. add a space at the end of the string -> partial direct formatting is lost; prefix is again hidden when out of edit mode (In reply to Eike Rathke from comment #14) > I don't understand the question. How do +/- and = differ? I was thinking of the difference in output between these two formulas: =2+test +2+test ...but I realise now that a single quote should always be prepended when the formula is not valid, whereas an equal sign is prepended when it is. So scrap that comment :) -- You are receiving this mail because: You are the assignee for the bug.
