CellCalc

Calculate the cell position of Excel.

Input/Output

Number of Connections: Min: 1/Max:3

Input	Data Type	Description
Input1	String	String which represents cell position
Input2	Integer	Sets the Row property. (optional)
Input3	Integer	Sets the Col property. (optional)

Output	Data Type	Description
Output1	String	A result

Property

Name	Property Type	Description
Target	choice	Specifies the target to calculate when the string is formatted as "<Start>:<End>". both - Calculate both start cell and end cell Input string may not include end cell. from - Calculate only start cell If input string includes end cell, end cell is not changed. to - Calculate only end cell If input string includes start cell, start cell is not changed.
Row	int	Specifies a numeric value to add to row A negative value can be used.
Col	int	Specifies a numeric value to add to column A negative value can be used.

Topic

• Input string can include sheet name. Example: Sheet1!A1:E10
• Input string is not formatted which doesn't represent cell position results error.
• After calculation, if a value of row or column become a negative value, it results error.

Example

		Property		Output
Input1	A1:E10	Target	both	C1:G10
		Row	0
		Col	2

		Property		Output
Input1	Sheet1!C5:E10	Target	to	Sheet1!C5:C8
		Row	-2
		Col	-2