For Ubuntu user:

$ sudo vi /etc/openoffice/sofficerc
< password >

Other Linux distribution

Login as root

$ su
< password >
# vi /usr/lib/openoffice/program/sofficerc

Change "Logo" value from 1 to 0 then save

Excel can display a maximum of 15 digits. If you have a number greater than 15 digits, the subsequent ones will display as zeros.
If you are processing numbers greater than 15 digits, such as credit card numbers then cells formatted as text will display

How to change it?

Change to fit your needs.

1. Just format the cell as Text,

2. Click the cell

3. Create and then Run this Macro.

Sub AddOne()
Dim vTemp1 As Variant
Dim vTemp2 As Variant

vTemp1 = CDec(ActiveCell.Value)
vTemp2 = vTemp1 + 1
ActiveCell.NumberFormat = "@"
ActiveCell.Value = CStr(vTemp2)
End Sub

Good luck