| Author |
 Topic  |
|
|
AKazak
Russia
1228 Posts |
 Posted - 09/15/2020 : 4:51:40 PM
|
OriginPro 2021 (64-bit) Beta 4 9.8.0.138
Windows 7 Pro x64 SP1
Greetings!
How do I ask Quick Fit Gadget to output to a specified worksheet only?
Currently, it adds fit curve to both graph and source data worksheet.
Thank you.
---
Andrey |
|
|
snowli
USA
1448 Posts |
Posted - 09/15/2020 : 5:36:40 PM
|
Hello,
Could you specify what output? Fit result such as parameter, … or fitted curve?
If you double click the yellow rectangle, Preferences dialog will open.
On Report tab, u can specify where the output will be and also what info. in report -- e.g. u can choose Output To Worksheet, and specify worksheet Name as [<input>]Result to output results to "Result" worksheet in same book as input data.
On Fit Curve tab, u can specify where Fit Curve is output to.
When u click > in gadget and choose New Output, etc., it will generate report to the specified worksheet.
As to fitted curve, there is no option to not draw it in graph.
Thanks, Snow
|
 |
|
|
AKazak
Russia
1228 Posts |
Posted - 09/16/2020 : 03:32:51 AM
|
quote:
Originally posted by snowli
Hello,
Could you specify what output? Fit result such as parameter, … or fitted curve?
If you double click the yellow rectangle, Preferences dialog will open.
On Report tab, u can specify where the output will be and also what info. in report -- e.g. u can choose Output To Worksheet, and specify worksheet Name as [<input>]Result to output results to "Result" worksheet in same book as input data.
On Fit Curve tab, u can specify where Fit Curve is output to.
When u click > in gadget and choose New Output, etc., it will generate report to the specified worksheet.
As to fitted curve, there is no option to not draw it in graph.
Thanks, Snow
Firstly I want to disable the appearance of this text label:
Secondly, I want to disable the creation of fit line plot and output fit columns to the right to the source data.
---
Andrey |
|
|
|
一击爆裂陈子豪
Taiwan
41 Posts |
Posted - 09/16/2020 : 11:12:46 AM
|
1). You can disable it by the Preference dialog Label Box tab.
2). You can disable the Report tab as well and specify the Fit Output Curve To be Source Sheet in Fit Curve tab.
While the fitted line will still be plotted. If you're really looking for that customized solution, you'll probably need to create your own processing tool/routine. |
|
|
|
snowli
USA
1448 Posts |
Posted - 09/16/2020 : 11:13:42 AM
|
Hi Andrey,
Double click the yellow gadget to open Preferences dialog.
Go to Label Box tab.
Uncheck "Add Label Box to Graph" to avoid outputting text label box in graph.
Go to Fit Curve tab, set Output Fit Curve to "Source Book, New Sheet" or "New Book" to avoid outputting fit curve data to source sheet.
You can click the > button next to Dialog Theme on top of the Preferences dialog and choose "Save as <Default>" so future quick fit gadget will use such settings.
Thanks, Snow |
|
|
|
AKazak
Russia
1228 Posts |
Posted - 09/16/2020 : 12:33:15 PM
|
quote:
Originally posted by snowli
Hi Andrey,
Double click the yellow gadget to open Preferences dialog.
Go to Label Box tab.
Uncheck "Add Label Box to Graph" to avoid outputting text label box in graph.
Go to Fit Curve tab, set Output Fit Curve to "Source Book, New Sheet" or "New Book" to avoid outputting fit curve data to source sheet.
You can click the > button next to Dialog Theme on top of the Preferences dialog and choose "Save as <Default>" so future quick fit gadget will use such settings.
Thanks, Snow
Add Label Box to Graph works as expected.
As for Fit Curve settings: I just discovered that New Output command stamps yellow rectangle and labels on the original place, but I can still move the gadget to a new location (see below).
This perfectly fits my needs.
---
Andrey |
|
|
| |
Topic |
|
|
|
Quick Fit Gadget: output to worksheet only