what about use the OnShowTable event?
Yes, I forgot all about that event, try this instead of the clock timer:
On show table worked, am facing an issue, if i click a row. Scrolling to that row will bring the row i just clicked to the top. Is there a way to just stop the table from changing row, for seamingless look.
Good morning, community.
This time, I'm trying to simulate a schedule of activities.
The fixed cells I should have are 168, 24x7, horizontally, and above them, the time and reference.
And 3 fixed cells on the left side vertically that tell me from what time to what time the cells should change color and their difference.
I tried to do it with TableViewer1,
but I can't find a way to colorize certain cells.
Similarly, I'd like to keep the first 3 columns fixed.
It should only shift from 1 to 168.
Any suggestions?
sample excel
sample
This is all possible with Tableviewer, read the topic, the methods are covered there.
I've already searched different forums where it only colors the entire selected row, not just cells.
I also didn't find a way to fix the first 3 columns.
Could you give me an example of this?
example1.aia (26.7 KB)
Did you read all of this topic? Fixed columns is covered and setting the colour of cells - or as simple as :
I am not able to replicate that behaviour in my test project, a clicked row just stays where it is. Do you have code or blocks for what happens when a row/cell is clicked/pressed ?
I think this can be improved.
#r3c11,#r3c12,#r3c13,#r3c14,#r3c15,#r3c16,#r3c17,#r3c18,#r3c19,#r3c20,#r3c21,#r3c22,#r3c23,#r3c24,#r3c25,#r3c26,#r3c27,#r3c28,#r3c29,#r3c30,#r3c31,#r3c32,#r3c33,#r3c34
It would be good just with the beginning and end.
It's worth noting that each row will have different cells.
Loop through each row
Use the for each number from to loop.
Here what did you assume it was row 10? I need the row am currently on
That was just a random row number in my example project (of 50 rows)
Confused...
How can you select the row to scroll to if it is off screen ?
Do you have a scrollTo event in your .Click event ?
Explain exactly what it is you are doing.
Lets say your table had dynamics data. it is always changing. Every time you set new data
; you need to show the table for the new data to load.
. Lets say you are on row 25 after scrolling to it. New data just arrived and your table need to "refresh", the .showtable block will push you back to row 1. I used the scroll block, but the problem is what do i set the scroll to row as.
If i set it to the last row i was clicking it will scroll to that row, and will move the table around. It doesn't scroll to where you were but where the row is.
How did you get to row 25 in the first place?
Did you click on row 25 for any reason?
Do you want to return to row 25?
Will the data currently in row 25 be in the new data ?
Will row 25 be in the same place after new data added/set?
Where do you want to scroll to after new data is added/set ?
How did you get to row 25 in the first place?
By scrolling to it
Did you click on row 25 for any reason?
Yes to change the quantity , i click +1 or -1
Do you want to return to row 25?
YES
Will the data currently in row 25 be in the new data ?
ROW 25 is the row thats being affected is the same row i want to scroll to
Will row 25 be in the same place after new data added/set?
YES
Where do you want to scroll to after new data is added/set ?
To row 25
Do you change the underlying data and reload the table with the new data after this ?
Yes so the quantity column change for that specific row
OK, probably got enough to go on to attempt a replication.
I found this way to color cells, but for this I need to obtain
with these 2 pieces of data:
#r7c33
#r7c38
all of this
#r7c33,#r7c34,#r7c35,#r7c36,#r7c37,#r7c38
which is content from start to finish
posd.
in rows #rX
the number X can have up to 3 digits
If there are any other ideas, I welcome comments
example1 (1).aia (30.5 KB)