Eclipse Community Forums: BIRT » Get the index of the cell in Birt

Home » Archived » BIRT » Get the index of the cell in Birt - Any function?(A way to get the index of a cell in a table)

Show: Today's Messages :: Show Polls :: Message Navigator

Get the index of the cell in Birt - Any function? [message #1833444]

Tue, 13 October 2020 12:56

gale weinstein

Messages: 10
Registered: October 2020

Junior Member

Hi,
I am for hours trying how to do it but to no avail.
Is there any way I can get in javascript code the index of a cell in a table?

Report message to a moderator

Re: Get the index of the cell in Birt - Any function? [message #1833503 is a reply to message #1833444]

Thu, 15 October 2020 07:49

gale weinstein

Messages: 10
Registered: October 2020

Junior Member

More explanation on the issue:
I have a table in which I have to set background color when the cell in header and cell in row appear as pair in a certain list in data source. For example: column : "AUD, USD" row : "BRL, CZK"

in the cell of column AUD and row is BRL I check if exists in the list in datasource and if so I need to color in a certain color.

Now, I thought to do it in this way: columns and rows will be in lists. I go over both lists and then color in those indexes the cell.

The problem is that I don't know how to set color to a certain cell in table.

Is there any way to do it or any documentation?

I would appreciate any comment!

Report message to a moderator

Re: Get the index of the cell in Birt - Any function? [message #1833585 is a reply to message #1833503]

Mon, 19 October 2020 08:18

dmitry khotsko

Messages: 38
Registered: March 2020

Member

this.getRowData().getColumnValue(/*number of column - int, or name -string*/)

Report message to a moderator

Re: Get the index of the cell in Birt - Any function? [message #1833599 is a reply to message #1833585]

Mon, 19 October 2020 13:59

dmitry khotsko

Messages: 38
Registered: March 2020

Member

sorry. I thought you need a rowdata. maybe you can create a counter for y-position and use getRowData().getColumn(num of column that you need) for x-position

Report message to a moderator

Re: Get the index of the cell in Birt - Any function? [message #1833622 is a reply to message #1833503]

Mon, 19 October 2020 22:00

rbaak Mising name

Messages: 31
Registered: July 2009

Member

If you want to change the color of the cell. Click in your cell. Go to the property editor of the Cell and select the highlights tab.

Robert Baakel
https://www.youtube.com/playlist?list=PLht0txJzVxKFp1WRUOouv7rQfkCmLjVas

Report message to a moderator

Re: Get the index of the cell in Birt - Any function? [message #1834097 is a reply to message #1833622]

Mon, 02 November 2020 14:42

gale weinstein

Messages: 10
Registered: October 2020

Junior Member

H,
thanks for answering.
Dmitry, can you show me a sample code that I can do? Isn't getColumn() a function for dataset column number and not a table's?
rbaak, I would like to do it a way which will be with no duplicated code? Do you have another solution?

Report message to a moderator

Re: Get the index of the cell in Birt - Any function? [message #1834132 is a reply to message #1834097]

Tue, 03 November 2020 13:59

rbaak Mising name

Messages: 31
Registered: July 2009

Member

Hi Gale,

Do you have some sort of sample of what your are trying to achieve?

Maybe try using getElementById() and get the Element ID from the general tab of each cell? Could be a long script but if you want it all in one place can be worth a try.

Robert Baakel
https://www.youtube.com/playlist?list=PLht0txJzVxKFp1WRUOouv7rQfkCmLjVas

Report message to a moderator

Re: Get the index of the cell in Birt - Any function? [message #1834342 is a reply to message #1834132]

Sun, 08 November 2020 08:28

gale weinstein

Messages: 10
Registered: October 2020

Junior Member

I am setting a table with constant headers and left column with currencies:
The cell whose combination of currencies (header and left cell in row ) are true according to some logic should be colored in a certain color.

Report message to a moderator

Re: Get the index of the cell in Birt - Any function? [message #1834857 is a reply to message #1834342]

Thu, 19 November 2020 09:31

dmitry khotsko

Messages: 38
Registered: March 2020

Member

Hi, you can add scripts for any object in birt. on tab scripts. or you can create dataset computed column with function RUNNING COUNT and then you can find this column value.
on render method you add script with your condition and change color

Report message to a moderator