[Libreoffice-ux-advise] [Bug 116261] CALC FORMATTING changing the format of some characters of a text cell (interpreted as formula?)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116261

--- Comment #15 from Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> ---
(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 on the CC list for the bug.