keyboard macro? or other tool to quickly find target values?
newbie nullzwei via gnumeric-list <[email protected]> Tue, 8 Feb 2022 08:56:53 +0100
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <trinity-bbd84830-6076-4681-a17c-a01aec012fd9-1644307013032@3c-app-gmx-bs50> |
--===============7342701107270295699== Content-Type: text/html; charset=UTF-8 <html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div style="font-family: Verdana;font-size: 12.0px;"> <div> <br/> hello @all,<br/> <div>I somewhat miss the macro capabilities of Libreoffice ...<br/> <br/> the following task: in a cell a tolerance value must be adjusted until a cell dependent on it reaches a certain step value. In calc I had built a macro which increases the cell value by one, held the thumb on it and by keyboard repeat quickly counted through until I saw the change, then back in single steps, done.<br/> <br/> Where I have not found something similar in gnumeric I tried 'goal seek' and solver, but i'm not familiar with them, no success. Actually something like this could work? Find the minimum value that must be entered in cell X so that cell Y becomes '1'? I got some results where '1' in Y worked, but not with the minimum value in X but any value large enough.<br/> <br/> Can someone help with this vague description?<br/> <br/> Best Regards,<br/> <br/> <br/> <br/> b.</div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div></div></body></html> --===============7342701107270295699== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list --===============7342701107270295699==--