Today I found out that all the previous sheets I created had hashs in the cells containing formulars.
Now I’ve copied all libre sheets to google sheets but of course the formulars were gone ,
Thought there might be a bug in the app so I downloaded libre again and replaced the old one.
Tried sheets but same old story.
I’m using Macbook Version 10.10.5
Anyhow I’ll continue with google sheets.
Thank you very much for your efforts to help me with this matter.
Do all the formulas that produce hashes use the “mixed algebraic calculations” that you referred to earlier, or are they correctly formulated Calc formulas?
link text(https://drive.googlelink text(https://drive.google.com/open?
just downloaded libre 6.2.6 and tried see the results on the linked screen shots
Could you please show a screenshot of the menu View->Show Formula (checked ot unchecked, as suggested by @anon73440385 long ago)?
link text
link texthttps://drive.google.com/file/d/1Li85sdDxwGrQnMhHCoqLYPNCeU77UiIf/view?usp=sharing
Please uncheck Display▸[ ] Formulas in Options▸LibreOffice Calc▸View.
Eureka , but why is this formular box ticked when it cause a problem which I think the normal user can’t solve . I downloaded libre twice , yesterday V 6.3 and today V 6.2 because I thought my OS cant handle
the newest version anymore.
But anyhow many thanks for your efforts
Downloading an reinstalling doesn’t help, if a user setting is stored in users profile. Without resetting your user profile - or changing the setting - it will keep to be active. And btw: The default is, that it is not set. Thus you need to blame some other party …