SID-00386: How do I do division within a form?

Status:	Answered	TWiki version:	4.3.1	Perl version:
Category:	SpreadSheetPlugin	Server OS:		Last update:	16 years ago

(I'm not sure if this is really a Form question or a Spead Sheet Plugin question)

I have created a TWiki form which works great. (I used the steps from Wikis for Dummies as the base). I want to be able to take the following data and divide one into the other:

Total Number of Participants (this is located in R8:C4) Carbon Emissions produced (this is located in R5:C4)

The rows I provided above are based on the assumption that the "header" row counts as R1.

I want to do the following: R8:C4/R5:C4 I would like to have it display in R14:C4. I am not even sure if that is possible.

What is the syntax for simple division and can you even do it in a form and what are the options for where you can display the result?

-- CijaHuntley - 2009-06-25

Discussion and Answer

To divide, use the $EVAL function of TWiki:Plugins.SpreadSheetPlugin

If that doesn't work for you, can you upload your example to the sandbox area, or maybe even here in the question?

-- SeanCMorgan - 2009-06-25

Closing, seems to be answered.

-- PeterThoeny - 2009-08-12

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.