1. Tools | Goal Seek.
2. In Target value type in: 1
3. In Variable cell type in A1
4. Click on OK button.
Error dialog opens: "Cell must contain a formula."
I suggest to change label from "Cell must contain a formula." to "Formula cell must contain a formula." to make it clear which input box has incorrect value.
P.S. This is probably easy hack. Can you please label it as such.
You have not mentioned your input in the field FORMULA CELL? Which formula have you been using as the "target" formula for the GOAL SEEK function (in the FORMULA CELL field)? GOAL SEEK needs here a formula for the calculation.
Or was your issue only regarding the designation "Formula cell must contain a formula" or an in principle issue regarding the use of GOAL SEEK? If it was only regarding the designation then I would agree that in this case it would be better and clear to name it "Formula cell must contain a formula" (probably an easy hack).
@A, I am only referring to the label "Cell must contain a formula." label. It is unclear witch cell is referred to. So changing "Cell" to "Formula cell" would make this clear. So final label should be: "Formula cell must contain a formula".
P.S. It is easy hack. I am adding the tags to whiteboard.
reproducible with LO 18.104.22.168 (Win8), it would be better and clear to name the message "Formula cell must contain a formula"
Can I assign this EasyHack to myself?
This is my first contribution to the LibreOffice project, so I'd like to get a feel of how the process normally goes by working on this EasyHack.
I just worked on it and committed the change.
Thank you for your support!
yjw9012 committed a patch related to this issue.
It has been pushed to "master":
fdo#72995: Changed label to 'Formula cell must contain a formula.'
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
I'll mark this fixed.
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyBeginner )
Thanks for the post and nice to see this here. Get more about best apps here.