CompletIT Community Server

List of all known\unknown issues of DGV Extension.

• The property 'IsManagedByExtension' is not visible design time in case you are using control that inherits the standard DataGridView control. - Fixed and available for download (21 Sept 2007)
• First export of DataGridView with default colors to MSExcel results in black color of all cells. - Fixed and available for download (15 Sept 2007)
• Slow first time initialization of the persisted Xml settings. - Fixed and available for download (13 Nov 2007)
• Custom columns are not supported.- Fixed and available for download (13 Nov 2007)
• Problems with addition of new rows to unbound DataGridView control - newly added rows are not shown.- Fixed and available for download (29 Feb 2008)
• Custom developed columns displaying images based on non image data are not exported/printed correctly.

When I export a datagridview directly from the excelexporter, the excel opens but all the cells have a black background. The user then has to go and change all the cells back to white...any idea what could be causing this?

 I an using c#, VS 2008 Beta 2 and Office 2007.

I know those aren't officially supported, but everything works as far as exporting the data, but in Excel it shows up as black.

Hi there,

Thank you for you feedback! The DataGridView Extension is a free product, but this does not mean it is not supported, we try to be as helpful to you as possible.

The problem you mentioned is known to us, but regretfully we could reproduce it only once several weeks ago again on Office 2007.
In the next 48 hours we will investigate it and try to find a solution for it. At the moment this solution is available we will publish it on our site and reply to your post.

To optimize the communication we can contact you on your e-mail(No spam will be sent!) if you write us at office@completit.com.

Yours Sincerely,
Support Team

Problem has been solved! The reason for it was the function we were using for the color conversion during the export.

Tomorrow (15 September) the new export to Excel will be available in the download section on our site.

Please note that you do not need to download the whole extension again but just the assembly 'DGVEExcelExporter.dll'.

Your Sincerely,
Support Team

Print and PrintPreiview is not correct, when using CellFormatting event.
Used code (VB.NET):

    Private Sub DataGrid_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles DataGrid.CellFormatting
        If Equals(Me.DataGrid.Columns(e.ColumnIndex), Me.PERSKDataGridViewTextBoxColumn) Then
            AB3Controls.CellFormat.PersonCode(e)
        ElseIf Equals(Me.DataGrid.Columns(e.ColumnIndex), Me.SEXDataGridViewTextBoxColumn) Then
            AB3Controls.CellFormat.Sex(e)
        End If
    End Sub

Public Class CellFormat
    Shared Sub Sex(ByRef e As System.Windows.Forms.DataGridViewCellFormattingEventArgs)
        If Equals(e.Value, Nothing) Then
            e.Value = "Nezināms"
        ElseIf Equals(e.Value, True) Then
            e.Value = "Vīrietis"
        Else
            e.Value = "Sieviete"
        End If
    End Sub
    Shared Sub PersonCode(ByRef e As System.Windows.Forms.DataGridViewCellFormattingEventArgs)
        If e.Value IsNot Nothing AndAlso CStr(e.Value).Length > 6 Then
            e.Value = CStr(e.Value).Insert(6, "-")
        End If
    End Sub
End Class

Hi,

Thank you very much for using DataGridView Extension and for your feedback.

Could you tell us more precisely what is the expected result and what is the actual result in the print? What is the data type of the column that is not printed correctly and what is the displayed value type (image, string or something else)?

Also it will help us a lot if you give us more information about the way you are populating your grid view control with data, bound or unbound, who generates the columns you manually or automatically by the grid view etc.

Yours Sincerely,
Support Team

I had prepared 2 pictures, where you could see it, but I am not allowed to add them (Options=>File attachment=>Add=> You do not have permission to upload or link to files. Please contact your system administrator.)  I can send them to you somehow.

Bugs:

    Private Sub DataGrid_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles DataGrid.CellFormatting
        If Equals(Me.DataGrid.Columns(e.ColumnIndex), Me.PERSKDataGridViewTextBoxColumn) Then
            AB3Controls.CellFormat.PersonCode(e)
        ElseIf Equals(Me.DataGrid.Columns(e.ColumnIndex), Me.SEXDataGridViewTextBoxColumn) Then
            AB3Controls.CellFormat.Sex(e)
        End If
    End Sub

1)  usnig this code on textboxcolumn: 

   Shared Sub PersonCode(ByRef e As System.Windows.Forms.DataGridViewCellFormattingEventArgs)
        If e.Value IsNot Nothing AndAlso CStr(e.Value).Length > 6 Then
            e.Value = CStr(e.Value).Insert(6, "-")
        End If
    End Sub

Results:

a) In DataGrdiView (Expected): There is "-" symbol inserted in cells, There is no "-" symbol inserted in column Header

b) In Print, PrintPreview, exports too: There is "-" symbol inserted in cells, There is "-" symbol inserted in column Header (CellFormatting event is used on colum header - DataGridView do not do this)

2) usnig this code on textbox column:

    Shared Sub Sex(ByRef e As System.Windows.Forms.DataGridViewCellFormattingEventArgs)
        If Equals(e.Value, Nothing) Then
            e.Value = "Nezināms"
        ElseIf Equals(e.Value, True) Then
            e.Value = "Vīrietis"
        Else
            e.Value = "Sieviete"
        End If
    End Sub

 results:

a) In DataGrdiView (Expected): There is correct Column Header text, there is values "Vīrietis" or  "Sieviete" or  "Nezināms" only in this column

b) In Print, PrintPreview, exports too (Actual): Header text is formatted by CellFormatting event. there is checkboxes checked and unchecked only in this column

Hi Janis,

Please send the pictures to support@completit.com.

Yours Sincerely,
Support Team