MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

esProc Getting Started: Types of Cells

Published on 20 October 14
254
0
0

In esProc, cells are automatically classified into different types according to their values or the expressions they contain. In a cellset, each type of cell has its own appearance, which highlights the code in the cells.

1.Types of cells

1.1 Constant cell

A cell in which the cell string can be interpreted as the constant is called a Constant Cell. Its cell value is the constant.

The constant cell has the following types of values:
esProc Getting Started: Types of Cells - Image 1

The text of a constant cell is in pink by default. Depending on the data in the cell, its value will be interpreted as various data types. For the unrecognized data, the value will be taken as the string.

Note:The representation style of 3% is unacceptable in any expression, but it is acceptable in the constant cell.

Please note the common reserved words below and keep in mind that they arecase-sensitive!

  • null:Null value; the cell value of any empty cell is always the null
  • true
  • false

1.2 String constant cell

A string constant cell is the cell whose cell string starts with single quote ', indicating it is a constant cell with a string value. The cell value is a string composed of those characters after the single quote. In this case, all characters following the single quote will be parsed as string, not requiring any additional quotes, escape characters, etc.

'abc\d String abc\dã

â '1234.5 String 1234.5ã
esProc Getting Started: Types of Cells - Image 2

1.3 Computational cell

A computational cell is the cell whose cell string starts with =, and that is used for computing an expression. Its cell value is the computed result of the expression, which can reference cell values of other cells.

â =5*(3+2)

â =A1*3

â =A1/B2+B1

The text of the computational cell is in black by default.

Click "Paly" to execute the code and you will find that the background of the computational cell turns to light yellow, indicating its cell value has been computed.Click the cell with cell value. In the value view section, the current cell value will be displayed for you to view the computed result.

esProc Getting Started: Types of Cells - Image 3

In the expression, you can use various basic operators to compute cell value:

  • a+ba-ba*ba/b

Add, subtract, multiply, and division operations.

â =3*4 12

â =1+2*3 7

  • a%b

Seek the remainder of a divided by b.

â =121%11 0, which indicates 121 is a multiple of 11, and is divisible by 11

â =100%7 2

  • a\b

Integer division, in which the integer parts of both a and bare kept. The integer part of the result will be returned after division.

â =11\4 2, cut off the decimal part of the result

â =6.1\2.9 3, which is equal to 6\2, the result is 3

  • s1+s2

Concatenate string s1 and s2. Note that the string will be ignored if added to a real number.

â ="Stephen"+" "+"Rolfe" String Stephen Rolfe

â ="A"+3 Integer 3, string "A" is ignored

â ="A"+string(3) String A3. If you do need to concatenate the string and the real number, please convert the real number to string first.

1.4 Executable cells

An Executable cell is the cell whose cell string starts with >, in which certain actions will be executed. The executable cell has no cell value. If an executable cell starts with one of the reserved words, like if, for, etc. then >can be omitted.

The code in an executable cell can be used to modify the value of another cell.

â >A1=5

â >B1=A1+3

In the executable cells, the cells can be used as variables.
esProc Getting Started: Types of Cells - Image 4

1.5 Comment cells

A comment cell is the cell whose cell string starts with /.Its cell value is null.

Comment cells will be ignored during execution.

The text of comment cells is in green by default.
esProc Getting Started: Types of Cells - Image 5

2. Set the appearance of different types of cells

esProc provides the users with options to set the font styles and the foreground/background color of different types of cells.Click the Tool ->Options. On the Appearance tab, you can view and modify settings.
esProc Getting Started: Types of Cells - Image 6




In esProc, cells are automatically classified into different types according to their values or the expressions they contain. In a cellset, each type of cell has its own appearance, which highlights the code in the cells.

1.Types of cells

1.1 Constant cell

A cell in which the cell string can be interpreted as the constant is called a Constant Cell. Its cell value is the constant.

The constant cell has the following types of values:

esProc Getting Started: Types of Cells - Image 1

The text of a constant cell is in pink by default. Depending on the data in the cell, its value will be interpreted as various data types. For the unrecognized data, the value will be taken as the string.

Note:The representation style of 3% is unacceptable in any expression, but it is acceptable in the constant cell.

Please note the common reserved words below and keep in mind that they arecase-sensitive!

  • null:Null value; the cell value of any empty cell is always the null
  • true
  • false
1.2 String constant cell

A string constant cell is the cell whose cell string starts with single quote ', indicating it is a constant cell with a string value. The cell value is a string composed of those characters after the single quote. In this case, all characters following the single quote will be parsed as string, not requiring any additional quotes, escape characters, etc.

'abc\d String abc\dã

â '1234.5 String 1234.5ã

esProc Getting Started: Types of Cells - Image 2

1.3 Computational cell

A computational cell is the cell whose cell string starts with =, and that is used for computing an expression. Its cell value is the computed result of the expression, which can reference cell values of other cells.



â =5*(3+2)

â =A1*3



â =A1/B2+B1

The text of the computational cell is in black by default. Click "Paly" to execute the code and you will find that the background of the computational cell turns to light yellow, indicating its cell value has been computed.Click the cell with cell value. In the value view section, the current cell value will be displayed for you to view the computed result.

esProc Getting Started: Types of Cells - Image 3

In the expression, you can use various basic operators to compute cell value:

  • a+ba-ba*ba/b
Add, subtract, multiply, and division operations.

â =3*4 12

â =1+2*3 7

  • a%b
Seek the remainder of a divided by b.

â =121%11 0, which indicates 121 is a multiple of 11, and is divisible by 11

â =100%7 2

  • a\b
Integer division, in which the integer parts of both a and bare kept. The integer part of the result will be returned after division.

â =11\4 2, cut off the decimal part of the result

â =6.1\2.9 3, which is equal to 6\2, the result is 3

  • s1+s2
Concatenate string s1 and s2. Note that the string will be ignored if added to a real number.

â ="Stephen"+" "+"Rolfe" String Stephen Rolfe

â ="A"+3 Integer 3, string "A" is ignored

â ="A"+string(3) String A3. If you do need to concatenate the string and the real number, please convert the real number to string first.

1.4 Executable cells

An Executable cell is the cell whose cell string starts with >, in which certain actions will be executed. The executable cell has no cell value. If an executable cell starts with one of the reserved words, like if, for, etc. then >can be omitted.

The code in an executable cell can be used to modify the value of another cell.

â >A1=5



â >B1=A1+3

In the executable cells, the cells can be used as variables.

esProc Getting Started: Types of Cells - Image 4

1.5 Comment cells

A comment cell is the cell whose cell string starts with /.Its cell value is null.

Comment cells will be ignored during execution.

The text of comment cells is in green by default.

esProc Getting Started: Types of Cells - Image 5

2. Set the appearance of different types of cells



esProc provides the users with options to set the font styles and the foreground/background color of different types of cells.Click the Tool ->Options. On the Appearance tab, you can view and modify settings.

esProc Getting Started: Types of Cells - Image 6

This blog is listed under Development & Implementations Community

Related Posts:

Java

 
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top