| 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 |
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.