Connect an input list to a formula

Discuss the word processor
Post Reply
ibelin123
Posts: 3
Joined: Tue Feb 12, 2019 11:10 pm

Connect an input list to a formula

Post by ibelin123 »

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.
OpenOffice 4.1.2 on Windows 7
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Connect an input list to a formula

Post by RusselB »

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

Code: Select all

=A2*10
in the cell where you want your result. Note: This can't be cell A2, since A2 contains your dropdown list.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
ibelin123
Posts: 3
Joined: Tue Feb 12, 2019 11:10 pm

Re: Connect an input list to a formula

Post by ibelin123 »

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."
OpenOffice 4.1.2 on Windows 7
Post Reply