Cell Notes Programming Access


Version: 2022b

Type: Features

Category: Programming

Subcategory: Labtalk

Jira: ORG-24341


Labtalk

Introduce Labtalk substitution notation @WN to access cell note in text label or legend of graph window. See example below,

%([Book1]Sheet1,@WN,B[2]) //cell note in the 2nd cell of col(B) in Sheet1 of Book1
%(1, @WN, 2) //cell note in the 2nd cell of the 1st plot's Y column
%(1X, @WN, 2) //cell note in the 2nd cell of the 1st plot's X column
%(1, @WN, B, 3) //cell note in the 3rd cell of col(B) in the 1st plot's worksheet
%(1, @WN, 4, 5) //cell note in the 5th cell of wcol(4) in the 1st plot's worksheet
%(1, @WN, C) //cell note in the Comment label cell of the 1st plot'Y column
%(1, @WN, B, L) //cell note in the Long name cell of col(B) in the 1st plot's worksheet
%([Book1]1, @WN, col(B)[L]) ==> //cell note in the Long name cell of col(B) in the first sheet of Book1

Python

import originpro as op
row, col = 1,1
wks = op.find_sheet()
str = wks.method_str('GetNote', f'{row + 1},{col+1}')
print(str)
t = '\\b(Some Heading)\nAnother line\nYes more'
wks.set_cell_note(row,col,t)