Hi,
I am displaying data in ultrawin grid and using merge cells by same text.
My data return by proc looks like this:
COL 1
COL 2
COL 3
A
V1
1
2
V3
B
V4
Excpect output after merge should be:
So i merge col 1 on sametext and col2 as well on sametext. Issue happens because both A and B has same value in one case i.e. V3. so because of that its look like below table:
So if you notice here, V3 is appearing only once but in fact it should appear twice - Once for "A" and then for "B" as well.
Any pointer to fix this would be of great help.
The merging you want here seems inconsistent to me, and I don't see how the grid could know which rows to merge and which ones not to merge.
But if you want to control the merging on row-by-row basis like this with your own criteria, you could use a MergedCellEvaluator on the column(s). This will give you complete control over which cells are merged.
How can I restrict some cells to be merged? I am using MergeEvaluator for merging rows