merge cells

[Natter]

XBrowser is an array.

{ {"AA", "BB"}, ;
{"AA", "BB"}, ;
{date(), date()-1}, ;
{date(), date()-2}, ;
{"CC", "DD"}, ;
{"CC", "DD"} }

The first column should be merged vertically. Is it possible to specify that you need to merge only cells of the array with the text type ?

[nageswaragunupudi]

You can if you have the latest version of FWH, using oCol:bMergeValue.

[Natter]

I'm using version 17.01 How to use bMergeValue in this case ?

[nageswaragunupudi]

Code: Select all  Expand view

     :aCols[ 1 ]:lMergeVert     := .t.
      :aCols[ 1 ]:bMergeValue    := { || If( ValType( oBrw:aRow[ 1 ] ) == 'C', oBrw:aRow[ 1 ], Str( oBrw:KeyNo ) ) }
 

[Natter]

Tried, but got error comparison string value and date

[nageswaragunupudi]

Tried, but got error comparison string value and date

If you tried my exact code you will not get the error.
You might have changed my code.

Please note: I never post here any code without first testing, so you can safely trust the code I post in the forums.

[Natter]

Excuse me mr.Rao. I wasn't paying attention. Everything works !