LogiScript

A script for testing the calculation of LogiSheets.

Usage

SWITCH

Switch to the specific sheet. If this sheet does not exist, create it.

SWITCH sheet

INPUT

Take the content as the input to a cell.

INPUT A1 =SUM(1+2)
INPUT B2 3

INSERTROW

Insert rows at the given position.

# Insert 3 rows at the row 1.
INSERTROW 1 3

INSERTCOL

Insert cols at the given position.

# Insert 3 cols at the col B.
INSERTROW B 3

DELETEROW

Delete rows at the given position.

# Delete 3 rows at the row 1.
DELETEROW 1 3

DELETECOL

Delete cols at the given position.

# Delete 3 cols at the col B.
DELETECOL B 3

BLOCKCREATE

Create a block with the given id and range.

BLOCKCREATE  1   A1:C3

BLOCKREMOVE

Remove a block with given id.

BLOCKREMOVE 1

BLOCKMOVE

Move a block by specifying new position of its master cell.

BLOCKMOVE 1  D4

BLOCKINSERTROW

Insert some rows in a block.

BLOCKINSERTROW {block_id}  {idx}  {cnt}

BLOCKINSERTCOL

Insert some cols in a block.

BLOCKINSERTCOL {block_id}  {idx}  {cnt}

BLOCKDELETEROW

Delete som rows in a block.

BLOCKDELETEROW  {block_id}  {idx}  {cnt}

BLOCKDELETECOL

Delete some cols in a block.

BLOCKDELTECOL {block_id}  {idx}  {cnt}

CHECKNUM

Check whether the cell is equal to a given number.

CHECKNUM A1 3

CHECKSTR

Check whether the value of a specific cell is equal to a string.

CHECKSTR A1 aaa

CHECKERROR

Check whether the value of a specific cell is equal to an error.

CHECKERROR A1 #NUM!

CHECKFORMULA

Check the formula of a cell.

CHECKFORMULA A1 SUM(1, 2)

CHECKEMPTY

Check if the cell is blank

CHECKEMPTY A1