Ask Your Question

eeSecur's profile - activity

2020-07-20 12:48:14 +0100 marked best answer All cells n all sheets are auto-formatted to Text. How to stop and change to numbers format?

Running OpenSuse x64 42.2 Leap. After a number system/application update all my sheets have a auto-text format for all previously formatted number cells. I have un-installed libreOffice and all related dependencies. Then re-install through OpenSuse Yast. This installed the latest version. Sadly when I open any sheet, all cells that previously had a number are still formatted as text. Have deleted or turned off all macros that I can find. Nothing seems to change the automatic text formatting. It takes about 1.5 -2 seconds for the entered number to change to blue and control returned to the keyboard.

Any advice or ideas will be tried.

2020-07-20 12:47:38 +0100 received badge  Famous Question (source)
2017-11-20 18:16:34 +0100 received badge  Notable Question (source)
2017-04-17 14:25:20 +0100 received badge  Popular Question (source)
2017-04-17 02:47:30 +0100 answered a question All cells n all sheets are auto-formatted to Text. How to stop and change to numbers format?

Problem solved. Within linux local user space, turned on hidden-files. Under the hidden .config directory found and rena

2017-04-17 01:59:27 +0100 asked a question All cells n all sheets are auto-formatted to Text. How to stop and change to numbers format?

All cells n all sheets are auto-formatted to Text. How to stop and change to numbers format? Running OpenSuse x64 42.2 L