Inserting a formula

Spreadsheet
#1

I’m very new to this so please excuse me if this is a simple one.

I am trying to insert a formula into the spreadsheet I have created, but there is no fx option I can find. On the screen shots of the product it shows this function on the Edit tab, but it does not appear on mine.

All I wnt to achieve is to add an automatic total to the end of a column of figures.

Many thanks in advance for any help.

#2

Hi,
you should enable mathematics for spreadsheet like here:

<script src="../codebase/spreadsheet.php?math=true" ></script>
#3

Many thanks for responding.

I’m not sure what to do with this script. I have pasted it into the html code of the Wordpress page but it made no difference. I tried posting it above, beneath and in amongst the spreadsheet code, but nothing. Please can you help?

All I am trying to do is locate the fx button, or make manually entered calculations work (eg: =(D3:D6) at the moment all that shows if I try to enter these is the actual text of the formula rather than the result.

Thanks again and apologies for not being at all technical.

#4

Hi,
for Wordpress plugin you must modify your placeholder like here:

[[spreadsheet?&math=true]]
#5

hi, i was able to get the =SUM() to work, however i’m trying to have =PRODUCT() also but i’m getting #SYNTAX_ERROR, so my question is =PRODUCT support by your wordpress plugin?

Thanks in advance