Date: prev next · Thread: first prev next last
October 2016 Archives by date, by thread · List index


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

Eike Rathke <erack@redhat.com> changed:

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

--- Comment #7 from Eike Rathke <erack@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.

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.