The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Quick Fit Gadget: output to worksheet only

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
AKazak 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
5   L A T E S T    R E P L I E S    (Newest First)
AKazak 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
snowli 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
一击爆裂陈子豪 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.
AKazak 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
snowli 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


The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000