The Origin Forum - Creating notes sheet in OriginC?

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum for Programming

Forum for Origin C

Creating notes sheet in OriginC?

New Topic

Reply to Topic

Printer Friendly

Author

Topic

jdf726

78 Posts

Posted - 02/14/2018 : 09:01:24 AM

Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:

I have discovered that 'free-standing' notes windows don't show up in any of the doc -ef W {} type loops I often use to pick up data from within a folder by name.

When I googled this I found this
https://www.originlab.com/forum/topic.asp?TOPIC_ID=9443

which taught me that you can add a notes sheet to a workbook (manually with a right click menu) and this DOES show up in the doc -ef loop (because the note is then a sheet).

How do you programmatically (in origin C or in labtalk) make a note sheet?

(This is with the aim of dumping some text in it, to be retrieved later programmatically)

jdf726

78 Posts

Posted - 02/14/2018 : 09:08:58 AM

(for anyone who has never done this before... the feature is described here, but with no further documentation that I could find
https://www.originlab.com/doc/ReleaseNotes/Add-Graph-and-Notes-as-Sheet)

Castiel

343 Posts

Posted - 02/14/2018 : 09:39:12 AM

quote:
Originally posted by jdf726

Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:

I have discovered that 'free-standing' notes windows don't show up in any of the doc -ef W {} type loops I often use to pick up data from within a folder by name.

When I googled this I found this
https://www.originlab.com/forum/topic.asp?TOPIC_ID=9443

which taught me that you can add a notes sheet to a workbook (manually with a right click menu) and this DOES show up in the doc -ef loop (because the note is then a sheet).

How do you programmatically (in origin C or in labtalk) make a note sheet?

(This is with the aim of dumping some text in it, to be retrieved later programmatically)

https://www.originlab.com/doc/OriginC/ref/Worksheet-EmbedNote


     #####
    #### _\_  ________
    ##=-[.].]| \      
    #(    _\ |  |------|
     #   __| |  ||||||||
      \  _/  |  ||||||||
   .--'--'-. |  | ____ |
  / __      `|__|[o__o]|
_(____nm_______ /____\____

jdf726

78 Posts

Posted - 02/14/2018 : 10:59:33 AM

Thanks!

I've successfully added this to my originC, so now there is a copy of the data in a "note sheet".

The reason I am doing it this way is that while I can get a note my name, sometimes I merge projects and there could be two notes windows with the same name. The doc -ef loop makes sure that you only pull the local (in this folder) copy of the 'note' window.

The trouble I have now is retrieving the text from the note sheet now that I know its "range notation" (I know it is called "title", say, and I know that it is part of a workbook called "D0AD24_info", so its path is something like [D0AD24_info]title! or something.

I used an originc function to retrieve the note by name before, but this assumed the name of the note, with no knowledge of which workbook or folder it was part of.

Given the information I know, what is the correct way of setting a label with that text data?

jdf726

78 Posts

Posted - 02/14/2018 : 11:18:47 AM

After some messing about with range notation I think I can get the text this way (it was not initially apparent to me that the 'note sheet' was actually had a cell structure, and you can add cells below the first notes).

range aa = [XXX0AD19info]XXX0AD19title!A;
aa[1]$=

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000