2.2.3.19 insertNotes
Menu Information
Right-click context menu of worksheet cell: Insert Notes
Brief Information
Insert a Notes window into a worksheet cell
Additional Information
X-Function not designed for Auto GetN Dialog.
Command Line Usage
1. insertnotes;
2. insertnotes str:="original image" cell:=[Book1]Sheet1!Col(2)[3];
3. insertnotes cell:= [Book1]Sheet1!Col(1)[2]
X-Function Execution Options
Please refer to the page for additional option switches when accessing the x-function from script
Variables
Display
Name
|
Variable
Name
|
I/O
and
Type
|
Default
Value
|
Description
|
| Default Text
|
str
|
Input
string
|
"Double-click to replace this text"
|
The notes content
|
| Cell
|
cell
|
Output
Range
|
<active>
|
Specify the worksheet cell to save the embedded notes
See the syntax here.
|
Description
The insertNotes function embeds notes inside a worksheet cell. The right-click context menu for worksheet cell offers an "Insert Notes" item. When this context menu is selected, a new Notes window is embedded into that cell. User can double-click the cell to pop up the Notes window for editing. Once done with editing, clicking the Close button on the Notes window will put the changes back into the worksheet cell.
The worksheet cell can then be sized to show as much of the embedded notes as desired. Note that existing notes windows cannot be embedded in cells, and only new Notes windows can be added and then opened for editing.
A cell with an embedded notes window is marked with black triangles in the four corners to distinguish it from a worksheet cell that contains text.
Examples
Run the following scripts in the command window respectively:
insertNotes str:="original image" cell:=[book1]sheet1!col(3)[4];
Insert the notes "original image" into column 3 row 4 of book1_sheet1;
This will embed a Notes page into the specified worksheet cell.
Related X-Functions
insertArrow, insertGraph, insertImg
|