[Table].GetCellValue(row_number,column_number)

[Table].GetCellValue(row_number,column_number)

FIRST CREATED ON 17 Feb 2025  I  AUTHOR Emma Camacho

When using Cell Settings in the Designer to format a Table in a Report you can use the Function GetCellValue to get the value of the cell to set a customized format.

For example, to highlight the columns that have the header 2017:


if ( [Table].GetCellValue(1,[ColumnNumber])=2017, Rgb(192, 192, 192),Rgb(255, 255, 255) )

Output:



or to highlight the Row that containes "EDP" in the first column:


if ( InStr( [Table].GetCellValue([RowNumber],1), "EDP") = "1", Rgb(255, 128, 64),Rgb(0, 0, 0))

Output:



Info
Looking for Additional Guidance?

If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.

    • Related Articles

    • CreateList(...)

      FIRST CREATED ON 17 Feb 2025 I AUTHOR Emma Camacho When writing an Expression in Mail & Deploy where you need a list, use the CreateList function. For example, when including columns 1,3 and 4 in a Table Element CreateList(1,3,4) or including several ...

    • What are Constant Values in Mail & Deploy and how to use them?

      FIRST CREATED ON 17 May 2023 I AUTHOR Emma Camacho If you want to use a constant, non-calculated value in an expression, you can do this by using the following syntax, which depends on the data type of the constant you want to use. Text If you want ...

    • How to use constant values and dynamic values in data types?

      FIRST CREATED ON 17 May 2023 I AUTHOR Emma Camacho Depending on the data-type of the constant value (see Constant Values) or dynamic value (see Dynamic Values), you can access certain properties of the value and/or manipulate it. Date-Time More ...