Spreadsheet - doing simple calculations the results are always 2 hash tags

asked 2019-08-30 03:42:10 +0200

eisrawai gravatar image

updated 2019-08-31 01:54:29 +0200

Speed knots 1st 6 2nd 7 Avg =(H11+H12)/2

the result = hash tags

sample file

edit retag flag offensive close merge delete


The column may not be wide enough to display the contents.

robleyd gravatar imagerobleyd ( 2019-08-30 03:52:01 +0200 )edit

That was my first thought but widening the column doesn't show results

eisrawai gravatar imageeisrawai ( 2019-08-30 04:06:53 +0200 )edit

is there a reason to use this formula, and not the built in average function in calc? if you can post the actual spreadsheet this would help greatly.

AdmFubar gravatar imageAdmFubar ( 2019-08-30 04:17:39 +0200 )edit

I use also mixed algebraic calculations , but without result link text

eisrawai gravatar imageeisrawai ( 2019-08-30 05:29:16 +0200 )edit

A screen shot is useless - attach to your question a sample spreadsheet file that shows the problem.

robleyd gravatar imagerobleyd ( 2019-08-30 12:56:58 +0200 )edit
eisrawai gravatar imageeisrawai ( 2019-08-30 13:42:26 +0200 )edit

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.


BigRAl gravatar imageBigRAl ( 2019-08-30 15:27:52 +0200 )edit

When you open the link you see the results but it shows another picture when you click 'open with Libre Office'

eisrawai gravatar imageeisrawai ( 2019-08-30 15:37:52 +0200 )edit

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.

ve3oat gravatar imageve3oat ( 2019-08-30 19:07:27 +0200 )edit

I uploaded the file as attachment to my question

eisrawai gravatar imageeisrawai ( 2019-08-31 01:05:55 +0200 )edit