Ubuntu – How to prevent LibreOffice Calc from removing the plus (+) sign
libreoffice
The following GIF animation demonstrates the problem.
Best Answer
Simply add a apostrophe when entering your data - turns the cell into a text cell :)
'+888888
If you need to use the number and cannot have it as text, you need to create a number format for it.
Right click and select Format Cells... -> Numbers. Enter your format into the Format Code field. The easiest format would be +0, which will display your number with a + and keep it a number, so it can be used in formulas.
Can I suggest, in Writer, choose Edit - Paste Special. Then select "Formatted Text". This will paste the text in a table which you can then format/add borders etc.
I had the same problem, but it was solved after an Ubuntu reinstall. However, most people would use this as a last option.
Some things that you could to to replicate the results would be to:
Delete the .libreoffice folder as scouser73 said
Remove and reinstall Java or OpenJDK
Reinstall LibreOffice (try using the latest version from the website)
Hopefully one of those will help. If you do decide to reinstall, remember to backup all files you may need.
Best Answer
Simply add a apostrophe when entering your data - turns the cell into a text cell :)
If you need to use the number and cannot have it as text, you need to create a number format for it.
Right click and select Format Cells... -> Numbers. Enter your format into the Format Code field. The easiest format would be
+0
, which will display your number with a + and keep it a number, so it can be used in formulas.