https://bugs.documentfoundation.org/show_bug.cgi?id=98590
Robinson Tryon (qubit) <qu...@runcibility.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
CC| |qu...@runcibility.com
Ever confirmed|0 |1
--- Comment #1 from Robinson Tryon (qubit) <qu...@runcibility.com> ---
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
