https://bugs.documentfoundation.org/show_bug.cgi?id=98590
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #7 from Eike Rathke <[email protected]> ---
(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 the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
