[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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #10 from b. <newbie-02 at gmx.de> ---
this point was discussed plenty times? 

1. to take the alignment of cell content as a 'type indicator' is a weak
approach / bad path as it could be manually overwritten. 

2. it is almost a question of faith, one party defends that changes by the user
should not have any harmful effects on existing constructions, but accepts that
errors or 'irritations' will occur later, the other side thinks that an action
by the user - also a formatting - is a declaration of intent to which he
expects a reaction. And this immediately, not 'sometime later' when he has long
forgotten what he reformatted, when and why, or never knew about it in a table
from someone else. 

3. I'm of the second opinion, if a user does damage with a format change he
should see it immediately and still has 'ctrl-z' to help him out. if the damage
occurs outside of his view he should be warned with a note, this should also be
done with the current behaviour if later on - when evaluating the format change
by changing the value - consequences in remote areas occur. 

4. Capitalized 'NEVER' and 'consider other layers' are statements, but not
arguments. From a programmer's point of view there are certainly arguments for
the current procedure, from a user's point of view it is 'suboptimal'. The wish
to have a program / table / sheet reacting to user actions in an way
intuitively  understandable to a user, even a 'simple-minded-user' is an
argument. (i've lost weeks! with similar weak behaviour in excel, late
evaluation of formats and 'hidden' exotic formattings not 'checkable' by the
user, one can say i hate such things.)

5. Marking cells as what they are formatted to would be very helpful,
regardless of the basic idea one belongs to, a clear marking if format and
content do not match would be very good ... a detailed analysis of what a cell
is formatted as, what it was formatted as when the content was entered, what it
is currently evaluated as, and what would change with a 'touch' ... probably
goes beyond the scope of a clearly arranged UI ...???

just my two cents, 

reg. 

b.

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