https://bugs.documentfoundation.org/show_bug.cgi?id=98590
Bug ID: 98590
Summary: No indication if cell value type is number or text
Product: LibreOffice
Version: 5.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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.
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).
[1] https://help.libreoffice.org/Calc/Formatting_Numbers_as_Text
--
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
