Connect an input list to a formula

Discuss the word processor

Connect an input list to a formula

Postby ibelin123 » Tue Feb 12, 2019 11:22 pm

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
ibelin123
 
Posts: 3
Joined: Tue Feb 12, 2019 11:10 pm

Re: Connect an input list to a formula

Postby RusselB » Wed Feb 13, 2019 12:07 am

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   Expand viewCollapse view
=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 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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.
User avatar
RusselB
Moderator
 
Posts: 5415
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Connect an input list to a formula

Postby ibelin123 » Wed Feb 13, 2019 12:29 am

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
ibelin123
 
Posts: 3
Joined: Tue Feb 12, 2019 11:10 pm


Return to Writer

Who is online

Users browsing this forum: No registered users and 34 guests