GrapeCity Forums

Hi All,

 I have set three different colors to gray area, odd rows and even rows. The rows are light gray and dark gray and the gray area is set to light blue.

 The form opens Ok, and the colors are just fine, but when the form loses focus and gets focus again, some cells or even rows become blue.

 Could anyone help?

Manu thanks in advance,

Leo

Hello,

I tested this issue with version 8 of Spread COM and set the following color settings:

fpSpread1.MaxCols = 5
fpSpread1.MaxRows = 10
Dim x As Boolean
x = fpSpread1.SetOddEvenRowColor(vbGreen, vbBlack, vbYellow, vbCyan)
fpSpread1.GrayAreaBackColor = vbRed

I am not seeing cell changing it's color from the other cells.In case this is not how you are seeing this issue, please send across a zipped project which replicates the said issue at our side.Thanks

Hi,

I'm not 100% sure, but I think that the problem occurs only if there is Timer in the form that modifies periodically the data in the spread.

 As far as I can see only these forms have such strange behaviour.

 Regards,

Leonid Ninov 

Leonid,

It probably would be best if you could post a small zipped project reproducing this behavior for us to debug. My guess is that you are running out of resources, but I can not be sure without seeing a reproduction.

Hi,

I'm sending you the sample project, In this project if you start multiple instances of the child form ( by 'Test' button on thye toolbar) you'll see that sometimes the last column of the grid has the color of the grayarea.

I've found workaround for this problem by adding one more column in the grid , which I set to hidden.

 But sometimes, during automatic data refresh, a cell or a row changes it's color and I have no workaround for this problem, except redrawing the entire grid.

Many thanks in advance,

Leonid Ninov

Leonoid,

The project you sent me is always setting the BackColor of the last column to the same color as the GrayArea. This is due to your code in the ChangeColor function. The following block is where you are setting the color on the Spread in this column.

                If Not ((TypeOf ctlThing Is Label) And (ctlThing.name = "lblSell" Or ctlThing.name = "lblBuy")) Then
                      ctlThing.BackColor = Color
                  End If

Since the .Row property is last set to -1 and the .Col property is last set to the last column, then the last column is getting this color.

Hi Scotts,

Thank you very much for your help.

It was really my mistake.

Best regards,

Leonid Ninov