[Libreoffice-bugs] [Bug 98590] No indication if cell value type is number or text

[bugzilla-daemon]

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

--- Comment #4 from Regina Henschel  ---
(In reply to Stanislav Horacek from comment #3)

> However, I am wondering: What are use cases for numbers in text format (but
> not converted to text)?

You have already calculations in the spreadsheet and want to add explanations
which might start with =, so you click on column or row header and set format
text.

 And if they are useful, why don't we have two
> choices here - one for format and one for type? The current state when the
> format change to text preserves numbers, but causes that a new value entered
> in the cell will be text, is not too intuitive for me.

Yes, a UI feature to convert number content into text, which performs a real
conversion, would be useful. If such exists, a wrong use of formatting would be
less likely.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98590] No indication if cell value type is number or text

[bugzilla-daemon]

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

--- Comment #3 from Stanislav Horacek  ---
Yes, the highlighting is a good way to see the types (even if different colors
are not as distinct as different alignments). And I would agree with the
revert.

However, I am wondering: What are use cases for numbers in text format (but not
converted to text)? And if they are useful, why don't we have two choices here
- one for format and one for type? The current state when the format change to
text preserves numbers, but causes that a new value entered in the cell will be
text, is not too intuitive for me.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98590] No indication if cell value type is number or text

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

 CC||rb.hensc...@t-online.de

--- Comment #2 from Regina Henschel  ---
You can always see the kind of entries via toggle "value highlighting"
(Ctrl+F8).

Never change content _automatically_ by changing a format. You might do it
after a warning hint. Another solution would be a "hint" at the cell (like the
green marks in Excel) which tells the user, that there is a number in a text
formatted cell.

I would prefer to revert bug 96822, because staying right aligned indicates the
user, that the action "format cell as text" does not do "convert content to
text".

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98590] No indication if cell value type is number or text

[bugzilla-daemon]

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

Robinson Tryon (qubit)  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||qu...@runcibility.com
 Ever confirmed|0   |1

--- Comment #1 from Robinson Tryon (qubit)  ---
TESTING with Ubuntu 14.04 +
LO 5.2.0.0.alpha0+ (2016-02-24_23:58:47)

(In reply to Stanislav Horacek from comment #0)
> After resolving bug 96822 in 5.2 master, under certain conditions, one
> cannot quickly decide if a cell contains number or string data type.
> Consider this:
> 
> 1. In a new spreadsheet, enter a number (e.g. 1) to A1.
> 2. For A1, choose Format - Cells and select the "Text" category.
> 3. For A2 choose the same cell format.
> 4. Enter a number (e.g. 1) to A2.
> 
> The number in A1 has not been converted to text (as documented in [1]) and
> it appears as office:value-type="float" in the ODS file.
> 
> The number in A2 is of text data type and appears as
> office:value-type="string" in the ODS file.
> 
> However, both numbers are left-aligned and have the same formatting code, so
> it is hard to identify their types.

Confirmed

> This issue could be solved by:
> - reverting the patch for bug 96822,
> - adding an immediate conversion to text when format is changed (e.g. Google
> Sheets performs such immediate conversion).

Seems like a reasonable change (at least to discuss), so
Status -> NEW

Should this be categorized as an enhancement or a regular bug?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98590] No indication if cell value type is number or text

[bugzilla-daemon]

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

Stanislav Horacek  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=96
   ||822

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs