Well… looking at your spreadsheet, I see no hashes:
The formula in H13 is H11*H12/5, so the result of 1.6 is correct
The formula in H17 is H15+H16, so, again, the result of 10 is also correct.
???
When you open the link you see the results but it shows another picture when you click ‘open with Libre Office’
Instead of giving a link to a file on Google Drive, I think you need to upload it directly to AskLO as a .ods file.
I uploaded the file as attachment to my question
Sorry. Not sure what I do wrong, but my browser (Firefox) does not display it.
I uploaded the file with your system , any other way to send it ?
What is your version? Do you have automatic calculations enabled?
I see no hash symbols in the submitted file opened with AndrOpenOffice 4.1.7.
By the way, try to zoom in.
Version 6.0.7.3 , how do you enable automatic calculation ?
Data->Calculate->AutoCalculate
@eisrawai : What function do you intend to use by “Avg”? The formulas in H13 and H17 are both specified as “Avg” but do not share the same syntax or mathematical form. In reply to the question by @AdmFubar, you say you are using mixed algebraic calculations, but I wonder whether Avg=(H11+H12)/2 would work in any circumstance. Even if it did, the calculation (H11+H12)/2 does not appear anywhere in your spreadsheet. Instead we see H11*H12/5, as pointed out by @BigRAI. I am confused so perhaps I have missed something.
Have you just ticked View -> Show Formula
Thanks, @anon73440385. Still, the expression (H11+H12)/2 does not appear anywhere, even though the OP quotes it specifically in his brief explanation of his question. And the fundamental question raised by @BigRAl has not been answered.
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)?