Apache OpenOffice Community Forum

How can I connect an input list with another formula?

I want to choose a value from "input list" then use this value in a formula.

Example: I'll choose a value from input list "Choice". Next I want put it in formula "=choice * 10".

Thank you.

Welcome to the Forums.

Are you sure you want or need to do this in Writer? This is simple in Calc, but Writer has limited capabilities for this type of processing.

In Calc you would create a dropdown list for Choice in (for example) A2, then the formula in the cell where you want your result. Note: This can't be cell A2, since A2 contains your dropdown list.

wow! Thank you for the fast reply! But yes. I want to do it in writer as this is more of a technical document. I have managed to do this with an "input field" but not with an "input list."