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: libreoffice-bugs@lists.freedesktop.org Reporter: stanislav.hora...@gmail.com 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 Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs