Xceed : Latest top 20 Updates in the Xceed Knowledge Base.

Page Setup margins not handling millimeters correctly

9/25/2006 4:48:35 PM

Description :

When using the report form from the GenerateReportForm class, in the Page Setup dialog, if margins are calculated in millimeters, clicking ok and returning to the Page Setup dialog again, the margin will be converted to inches, though the display still shows millimeters. Doing this repetitively will make the margins getting smaller every time, since they get converted from millimeters to inches each time.

Solution :

This is a bug and unfortunately, it is not under our control. There is little we can do.

It is a bug in the Windows common dialog that is used by the GenerateReportForm class through the .NET framework.

When the 'Measurement System' property of the 'Regional and Language Options' of your computer is set to 'Metric', Windows fails to correctly handle the margin values. If the measurement system is set to U.S. the dialog works correctly.

You can find more information on this bug at the Microsoft web site here:

http://support.microsoft.com/?id=814355

* * *

You can always replace the PageSetupDialog with your own.

We provide the full source code to the GenerateReportForm and CustomizeReportStyleForm classes. Have a look at the code and modify it to suit your needs. You'll find the instructions on compiling and integrating the forms in the documentation. Look at the bottom of the following page:

http://doc.xceedsoft.com/products/gridNET/doc/index.htm?page=sources/using_the_generatereportform_class.htm

Can Xceed Encryption work with the .NET encryption classes?

8/16/2006 11:44:39 AM

Description :

I want to encrypt data using the Rijndael encryption method of the Xceed Encryption Library and decrypt it using the .NET Framework's Rijndael class. Is it possible?

Solution :

The Xceed Encryption Library can be compatible with the Framework's Rijndael class however you have to be careful when initializing the objects, since we only support the ECB (emoFreeBlocks) and CBC (emoChainedBlocks) encryption modes.

Also, you must be careful with the padding method :

Padding method support table

A C# sample that demonstrates the required implementation when using the ChainedBlocks(CBC) encryption mode is available for download.

A C# sample that demonstrates the required implementation when using the FreeBlocks (ECB) encryption mode is also available for download. This sample includes a Visual Basic 6 project that uses the Xceed Encryption Library to encrypt data and the Xceed Binary Encoding Library to encode. It also includes a C# project that demonstrates how to use the Framework's classes to decode and decrypt the data. A C# version of the code required to encrypt using the Xceed Encryption Library is also included in the C# sample.

We highly recommend that you use the ChainedBlocks (CBC) encryption mode rather than the FreeBlocks (ECB) encryption mode in order to thwart potential attacks.

Unable to change or assign borders.

7/5/2006 11:54:25 AM

Description :

There seem to be no way to change or assign borders because Xceed.Grid.Borders is a struct and passed by value... So it would appear that when you call for row.Borders a local copy is created and assigning row.Borders.Bottom wouldn't really do anything and actually doesn't even compile... How can I change the borders?

Solution :

The row.Borders can not be changed since it is a read-only property. However, you can derive from the row you want and then override the Border property.

Don't forget to override the OnPaintBorders to paint what you want in your borders.

It is true that row.Borders.Bottom = ... will affect a copy of the returned Borders.

Here is a link to the Custom Painting topic in our online help documentation

Split zip file

6/21/2006 4:35:56 PM

Description :

I created a zip file using the SplitSize property however I am not able to extract it's contents using Winzip. Why?

Solution :

This is normal behavior. The SplitSize property is native to the Xceed Zip control. You will only be able to extract the contents of the split zip file using the Xceed Zip Compression Library (v4.x).

However, there is a workaround and you need to do the following:

Assuming that you have a zip file split into three parts: SplitFile.zip, SplitFile.z02, SplitFile.z03.

1. Rename the first file (in this case "SplitFile.zip") to "SplitFile.z01"
2. Rename the last file (in this case "SplitFile.z03") to "SplitFile.zip"

The result will be three files: SplitFile.z01, SplitFile.z02, SplitFile.zip.

In order for Winzip to decompress these files automatically, you need to have them in the same directory.

How do I use the GetFolderContents in PowerBuilder?

6/6/2006 2:12:46 PM

Description :

Solution :

You can use the following code to list the contents of a remote folder using the following code:

Integer li_Ret, li_index, li_index, li_type, li_Count
OleObject ole_ftp, ole_folderItems, ole_folderItem
String ls_name, ls_folder

// FTP Ole Object
ole_ftp = Create OleObject
li_ret = ole_ftp.ConnectToNewObject("XceedSoftware.XceedFtp.1")

IF li_Ret < 0 THEN
    MessageBox('ole_ftp', 'failed!')
    Return
END IF

// Folder Items OleObject
ole_folderItems = Create OleObject

// Connecting to FTP server
ole_ftp.ServerAddress = address
ole_ftp.UserName = userid
ole_ftp.Password = password
ole_ftp.PassiveMode = FALSE
ole_ftp.License(KEY)
ole_ftp.Connect()

// Get all txt files in the current folder
ole_folderItems = ole_ftp.GetFolderContents(''*.txt', 0)

// Number of folder items
li_Count = ole_folderItems.Count

// get name and type for each folder item
For li_index = 1 to li_Count
    ls_name = ole_folderItems.Item[li_index].itemname
    li_type = ole_folderItems.Item[li_index].itemtype
Next

// Disconnect
ole_ftp.Disconnect()

***Information provided by Enrique Perez!***

*Keep in mind that Xceed does not officially support PowerBuilder*

How do I use my Xceed component in PowerBuilder?

6/6/2006 2:03:16 PM

Description :

Solution :

Most Xceed Components can be used in PowerBuilder.

The following example demonstrates how to encrypt a file using the Xceed Encryption Library.

Make sure that you have read the installation instructions beforehand!

long bytesRead
oleobject rijndael
oleObject encryption

encryption = CREATE OleObject
encryption.ConnectToNewObject("Xceed.Encryption.1")

encryption.License( "your license key" )

rijndael = CREATE OleObject
rijndael.ConnectToNewObject("Xceed.RijndaelEncryptionMethod.1")

rijndael.SetRandomSecretKey( 128 )

encryption.EncryptionMethod =rijndael
encryption.ProcessFile("d:\file.txt", 0, 0, 0, TRUE, "d:\encrypted.txt", FALSE, bytesRead)

*Keep in mind that PowerBuilder is not officially support by Xceed*

NotSupportException when setting MaxLength of GridNumericTextBox

6/6/2006 2:00:52 PM

Description :

I am trying to set the maximum length of the value entered into the GridNumericTextBox by setting the MaxLength property however it throughs a NotSupportException. How can I limit the legth of the value entered?

Solution :

The MaxLength property is inherited from TextBox (from which the GridNumericTextBox derives). However it is not intended to be used directly from your code. The fact that is throws is normal. In order to do what you are describing, you will need to set the Length property. For example.

Dim editor As Xceed.Grid.Editors.GridNumericTextBox()

gridControl1.DataRowTemplate.Cells( "Money" ).CellEditor = editor

editor.Length = 5

*Please not to user of Grid 3.0 and above that this no longueur applies*

Empty console window in Visual Studio 2005.

6/1/2006 2:50:38 PM

Description :

When running a console application sample within VS.NET 2005 in debug mode, the sample opens the expected console window, but nothing appears, and keyboard input does nothing.

Solution :

VS.NET 2005 exposes a new "QuickConsole" docking window within the IDE. By default, when debugging a console application, any output and input is redirected to that window. You will see the expected output in that window, and be able to type input within that window.

If you would like to disable this new functionality, go to the "Tools" -> "Options" menu, select the "Debugging" -> "General" node, and uncheck the "Redirect all Console output to the Quick Console window" option. We suggest you disable the QuickConsole, as it may not always behave exactly like a console window, and does not display the output correctly.

How can I fix one or more columns when I scroll?

5/16/2006 4:23:27 PM

Description :

How can I fix one or more columns when I scroll?

Solution :

As of version 3.1 of the Xceed Grid for .NET, a property has been added to the Column object .Fixed which can simply set to true.

Xceed Grid for .NET does not currently support fixed columns.

As of version 1.1, you can simulate fixed columns by changing the VisibleIndex property of the column you want fixed in the grid's FirstVisibleColumnChanged event.

For example, in the following code we will fix the CustomerID column:

[C#]

if( gridControl1.FirstVisibleColumn != null )
    if( gridControl1.FirstVisibleColumn != gridControl1.Columns[ "CustomerID" ] )
        gridControl1.Columns[ "CustomerID" ].VisibleIndex = gridControl1.FirstVisibleColumn.VisibleIndex;

[VB.NET]
If Not GridControl1.FirstVisibleColumn Is Nothing Then
    If (Not GridControl1.FirstVisibleColumn Is GridControl1.Columns("CustomerID")) Then
        GridControl1.Columns("CustomerID").VisibleIndex = GridControl1.FirstVisibleColumn.VisibleIndex
    End If
End If

Does the Xceed FTP Library support SSH?

5/16/2006 3:02:18 PM

Description :

Solution :

Unfortunately, the Xceed FTP Library does not support SSH. Xceed Ftp for .NET does however support SSL and TLS.

How do I tell Xceed Zip to use the Zip64 zip file format?

5/16/2006 2:57:52 PM

Description :

Solution :

With the ActiveX version of Xceed Zip, as of version 5.0,
when Zipping, all zip files will automatically be converted to the Zip64 compression format if the limitations of the regular Zip format are reached.

When Unzipping or listing the contents of a Zip file, Xceed Zip will automatically detect if a zip file is a Zip64 file.

Xceed Zip for .NET and Xceed Zip for .NET Compact Framework also support the Zip64 format.

How do I display a description rather than an ID?

5/16/2006 2:54:53 PM

Description :

I have a column that contains ID's however I want to display there description rather than then ID. How do I do this? ForeignKey

Solution :

In order to display a description rather than an ID, you will need to use the GridComboBox as a viewer (and editor if desired).

This is done by binding the GridComboBox to the table that contains the ID's descriptions and to set its DisplayMember and ValueMember properties.

For example:

Xceed.Grid.Editors.GridComboBox editor = new Xceed.Grid.Editors.GridComboBox();

editor.DataSource = dataSetProducts1.Tables[ 0 ];
editor.DisplayMember = "ProductName";
editor.ValueMember = "ProductID";

gridControl1.Columns[ "ProductID" ].CellEditor = editor;
gridControl1.Columns[ "ProductID" ].CellViewer = editor;

The above code assumes that you have a ProductID column in the grid and will result in the ProductID column displaying the description of the product that corresponds to the ID.

Is it possible to edit a cell without having to double-click?

5/11/2006 5:08:25 PM

Description :

I want to edit a cell as soon as I click on it (single click edit), I don't want to have to double-click. Is it possible?

Solution :

Version 2.1 and up
There is the SingleClickEdit property on the GridControl that can be set to true.

Version 2.0 and down
Yes. In order to do so, you need to subscribe to each DataCell's Click event and call the cell's EnterEdit method.

A C# example can be downloaded from here.

How do I create a viewer/editor that contains multiple controls?

5/8/2006 4:37:20 PM

Description :

I want to create a viewer and editor that contains multiple controls. Is it possible?

Solution :

Yes. In order to create a viewer and editor that contains multiple controls, you must create a UserControl and implement the ICellEditor and ICellViewer interfaces.

It is very important that in the ICellViewer.PaintCellValue method that you paint all the child controls yourself.

A C# sample that demonstrates the required implementation is available for download.

Keep in mind that this is for advanced developers.

As of version 3.0, there are new CellEditorManager and CellViewerManager classes that must be used to accomplish this. You can find more information here

How do I print page numbers when printing the grid?

5/8/2006 4:16:45 PM

Description :

Is it possible to have page numbers when printing the grid?

Solution :

Yes. In order to do so, you will need to create a class that derives from the GridPrintDocument class and override the OnPrintPage method (to print the header or footer) and the OnBeginPrint method to initialize the page counter.

A VB.NET class that demonstrates the required implementation can be found here.

To use the custom GridPrintDocument, the following code must be used:

Dim printDocument As New UberGridPrintDocument(GridControl1)
printDocument.Print()

Keep in mind that if you call the Grid's Print or PrintPreview methods, the grid will always be printed with the default print document.

As of Xceed Grid for .NET 3.0, there is a new reporting engine that allows much more flexibility, which will also permit to print page numbers. You will find more information here.

How can I print a range of pages?

5/8/2006 4:03:08 PM

Description :

Is it possible to print a range of pages using the grid?

Solution :

Version 3.0 and up

Yes. Simply use the PrinterSettings property.

Dim printDocument As New GridPrintDocument(GridControl1)

printDocument.PrinterSettings.PrintRange = System.Drawing.Printing.PrintRange.SomePages
printDocument.PrinterSettings.FromPage = 3
printDocument.PrinterSettings.ToPage = 4

printDocument.Print()

Version 2.5 and older

Yes and no. With the current version of the grid, you can only decide at what page to stop printing; it is not possible to decide at which page to start the printing process. This said, to stop the printing process after page number x, you can use the following code:

Dim printDocument As New GridPrintDocument(GridControl1)

AddHandler printDocument.PrintPage, AddressOf Me.PrintPages

printDocument.PrinterSettings.PrintRange = Drawing.Printing.PrintRange.SomePages
printDocument.PrinterSettings.FromPage = 1
printDocument.PrinterSettings.ToPage = 3

printDocument.Print()

' You decide when the printing process stops in the
' PrintPage event.

Private m_pageCounter As Integer = 0

Private Sub PrintPages(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs)

    m_pageCounter = m_pageCounter + 1

    If e.PageSettings.PrinterSettings.PrintRange = Drawing.Printing.PrintRange.SomePages Then
        If m_pageCounter >= e.PageSettings.PrinterSettings.ToPage Then
            e.HasMorePages = False
        End If
    End If
End Sub

Does Xceed Zip for .NET support ASP.NET?

5/8/2006 3:57:46 PM

Description :

Does Xceed Zip for .NET support ASP.NET?

Solution :

Xceed Zip for .NET supports both version 1.1 and 2.0 of the .NET Framework (thus ASP.NET).

Which Xceed products are compatible with FoxPro?

5/8/2006 1:59:42 PM

Description :

Solution :

The Xceed Zip Compression Library, Xceed Backup Library and Xceed FTP Library are compatible with FoxPro.

The Xceed Winsock Library, Xceed Encryption Library, Xceed Streaming Compression Library and Xceed Binary Encoding Library are NOT compatible with FoxPro.

*Please note that Xceed does not officially support Visual Fox Pro*

Adding the Backup Library controls in Visual Fox Pro.

5/8/2006 1:55:20 PM

Description :

When I add the control for the Xceed Backup Library to my form, in Visual Fox Pro, it only displays ONE control. If I look at it in Visual Basic there are 5 controls.

Solution :

All of our controls are installed but they do not all
start with the Xceed name.

You can find all of the controls under their original names:

- BackupJob class
- FileSelection class
- RestoreJob class
- ScheduledJob class
- Xceed Backup Control 1.0

*Please note that Xceed does not officially support Visual Fox Pro*

Installing Xceed components in Visual DataFlex

5/5/2006 3:21:41 PM

Description :

How do I install my Xceed component into Visual DataFlex?

Solution :

1- Make sure that the Xceed component is correctly installed and registered with the operating system.

2- From The Ide Menu Choose Tools>Import ActiveX Control. This will bring up a list of Registered ActiveX Components

3- Scroll down the list and choose the component

4- The "Generate" checkboxes for all applicable classes should be checked.

- Leave the "Data-Aware" checkboxes unchecked.
- Repository should be global.
- PKG File should be C:\Program Files\VDF7\Pkg\XceedBkp.pkg
- Palette Page should be ActiveX

The IDE should allocate the relevant Xceed Bitmaps to each control. This is used to identify the control on the IDE's >Controls Palette> (explained later). If they do not show up it may be because the bit map isn't there. It shouldn't happen but occasionally it does. Try moving the mouse about an watch for the tool tips to appear. You can also change the bit maps using Tools > Maintain Class-Lists > Edit, from the main IDE menu.

5- Click Ok. The < Select Methods and Properties > Dialog box will appear. Click Ok (No need to change anything)
This will Register all the Classes in the IDE, and generate the wrapper Classes in the file XceedBkp.pkg

The Code Explorer Edit Box will be displayed showing the XceedBkp.pkg file. You do not need to edit the package.
Click the Close Button (X) of the CODE EXPLORER. This will return you to the Visual Editing mode of the IDE. It will however, be blank at this stage.

You then need to set up a View to work with.

From the IDE Menu Choose >File > New Componant.

Select >Blank View> from the Data Entry Tab > Click Ok
This will Create a new Blank View.

From the IDE Menu Choose >Tools > Controls Pallet
This will provide you with a floating tools menu

Choose >ActiveX Pallet. The Xceed Objects will be visible as per the bit maps selected

Drag the relavant controls onto the view. Right Click any control to view it's object properties and also it's Active X properties.

***Information provided by Martin Kelly!***

*Please note that Xceed does not officially Visual DataFlex*