[Libreoffice-ux-advise] [Bug 98590] Confusing behavior when cell with number is changed to format Text: no indication if cell value type is number or text

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #7 from Eike Rathke <erack at redhat.com> ---
(In reply to Cor Nouws from comment #6)
> and also the idea to revert bug 96822

Actually not. AFAIR that's also what Excel does, doesn't it? Displaying numeric
content left aligned if the cell is formatted to text.

As for "adding an immediate conversion to text when format is changed" of the
original request: applying a display format NEVER changes the cell content, and
if Google Sheets does it that's their problem. Such behavior is completely
unexpected and makes absolutely no sense if you think further and consider the
layers of cell style, conditional format and hard format, in which each a
number format can be applied.

Reverting the "numeric cell content is left aligned if formatted to text"
argument again leads to "there's no indicator that the cell format is text if
the content is numeric and input of new assumed-to-be-numeric content would be
converted to text". It's going in circles and likely cell hints would be the
best solution (which could be used for other scenarios like mismatching data in
columns as well).

-- 
You are receiving this mail because:
You are on the CC list for the bug.