I am running LO6 with OS X. Something got reset. If I create a new sheet, put a value in A1 and enter in B1, "=A1 and hit enter, nothing happens. It just displays "=A1". Data>Calculate>AutoCalculate is on and if I select Data>Calculate>Formula to Value, it displays the value. This has always worked so it must be a setting but I cannot find it. Anybody have any idea what happened?
Check the formatting for the cell B1 and make sure it isn't set to Text (under the Numbers tab). If it is, set it to All and re-enter your formula
Well, not that. When I change B1 to an integer, B2 displays "=B2" but becomes right justified. It seem to think it's numeric, the format is numeric general, but it's broken. I might add I believe this started from when I opened a file received from a data vendor. Opened fine, but this edit issue began. Exported to csv, opened that but still can't calculate a new field.
besides other influendes be aware that reformatting a cell - applying e.g. 'text' vs. 'number' - does not! work instantly, the content of the cell - the value or formula - needs to be changed or at least 'touched' for the format change to come into effect (an unchangig edit as appendig an "" at the end and deleting it while still in edit mode, thus saving the same content as before is sufficient). That's why @jodybingo wrote "... and re-enter your formula".
Asked: 2019-09-07 17:28:11 +0100
Seen: 82 times
Last updated: Sep 07 '19
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
