Description: The Help System item "Entering a Number with Leading Zeros" suggests entering a number as text by beginning entry with an apostrophe. It states that the number will be left justified, and that the apostrophe will not be seen. This is no longer true! The number, while being left justified, is DISPLAYING the apostrophe. Steps to Reproduce: 1. Create a new spreadsheet. 2. Select a cell. Enter: '1234 3. The display is left justified, but displays '1234 instead of just 1234 Actual Results: The display is left justified, but displays '1234 instead of just 1234 Expected Results: It should behave as it always used to, and as the help item "Entering a Number with Leading Zeros" describes. Reproducible: Always User Profile Reset: Yes - I actually created a brand new Linux user and tested with that account. Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Builds ID: LibreOffice 5.1.5.2 User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0
Please confirm that your cell was NOT formatted as Text before you entered '1234. I cannot reproduce this problem on LO 5.2.x.
I tested with both the "default" format (which seems to be Number), as well as setting the format type to Text. I also right clicked and chose "Clear Direct Formatting" and tried again. As mentioned, I also tried on a new spreadsheet, as well as on a newly created user. I am running on Fedora 24 64-bit. These are the packages that are installed: # rpm -qa | grep libreoffice | sort libreoffice-calc-5.1.5.2-9.fc24.x86_64 libreoffice-core-5.1.5.2-9.fc24.x86_64 libreoffice-data-5.1.5.2-9.fc24.noarch libreoffice-draw-5.1.5.2-9.fc24.x86_64 libreoffice-filters-5.1.5.2-9.fc24.x86_64 libreoffice-graphicfilter-5.1.5.2-9.fc24.x86_64 libreoffice-gtk2-5.1.5.2-9.fc24.x86_64 libreoffice-gtk3-5.1.5.2-9.fc24.x86_64 libreoffice-impress-5.1.5.2-9.fc24.x86_64 libreofficekit-5.1.5.2-9.fc24.x86_64 libreoffice-langpack-en-5.1.5.2-9.fc24.x86_64 libreoffice-math-5.1.5.2-9.fc24.x86_64 libreoffice-ogltrans-5.1.5.2-9.fc24.x86_64 libreoffice-opensymbol-fonts-5.1.5.2-9.fc24.noarch libreoffice-pdfimport-5.1.5.2-9.fc24.x86_64 libreoffice-pyuno-5.1.5.2-9.fc24.x86_64 libreoffice-ure-5.1.5.2-9.fc24.x86_64 libreoffice-ure-common-5.1.5.2-9.fc24.noarch libreoffice-writer2latex-1.0.2-19.fc24.x86_64 libreoffice-writer-5.1.5.2-9.fc24.x86_64 libreoffice-x11-5.1.5.2-9.fc24.x86_64 libreoffice-xsltfilter-5.1.5.2-9.fc24.x86_64
FYI: I have just booted off a Fedora 24 Workstation Live DVD. It is running version: libreoffice-calc-5.1.3.2-6.fc24.x86_64 It does the same thing.
Unless someone confirms this bug it will not likely get any attention. LO versions 5.2.x do not appear to have this bug so I suggest you update to 5.2.
It seems bug 99930 is also affecting version 5.1, and the fix hasn't been backported. I'm asking the dev to do it. *** This bug has been marked as a duplicate of bug 99930 ***