GrapeCity Forums

Hi,

  we are using the far point spread control version 2.5. We have a requirement to merge cells which we dont find this version. Is this property available in 2.5 . if not what is the latest version. Also is any licensing required to use the latest version.

 thanks.

Raju

Hello Raju,

You should be able to merge cells with Spread 2.5 (latest build).To set cells to be merged if they have the same value, use the following members:

GetColumMerge and SetColumMerge
GetRowMerge and SetRowMerge
GetMergePolicy and SetMergePolicy  

for example:

Dim Sheet0 As FarPoint.Win.Spread.SheetView

Sheet0 = SetRowMerge(-1, FarPoint.Win.Spread.Model.MergePolicy.Always)

Sheet0.ColumnCount = 10

Sheet0.SetColumnMerge(-1, FarPoint.Win.Spread.Model.MergePolicy.Always)

I hope it will help you.

Thanks,

Thanks deepak.

     I am using VB 6 and don't see any property to set the control to merge. My Requirement.

     Using VB 6.0 with far point spread sheet control as a COM component version 2.5.

     i need to merge cells depending on column criteria.

     Thanks again for your response. 

Raju

Hello,

I thought you are using Spread 2.5 for Windows Forms. There is not such property/method to merge cells with Spread for COM v2.5, you may set CellOverflow to true to see all the content of the cell.You may upgrade to our latest version of Spread for COM v8 to achieve this behavior.

Thanks,

Hi Deepak,

    do we have to take license for v8 of Spread.  Can you provide the link where we can download the latest version.

 thanks

raju.

Hello,

Yes, you would need a License for Spread 8.You may download the trial version from:

 http://www.clubfarpoint.com/FarPointSupportSite/Modules/Download/trials.aspx

Please contact our sales team for information about this product: fpsales@fpoint.com

Thanks,