FlexGrid for WinForms - Recent Threads

How To Adjust Rectangle Size In C1Report

programmer5 — Thu, 09 Sep 2010 02:28:13 GMT

Hi Guys!

Just need some help on how can I adjust an specific rectangle in my report containing a database field with a .CanGrow Property set to True. In Other words, I just need that specific rectangle to be versatile with the height defending on the field's height when I print it in the details section.

Any help would be appreciated.

Regards.

When adding a new root node to a collapsed tree the node does not appear

Emmanuel — Wed, 08 Sep 2010 07:36:06 GMT

Hi,

I just upgraded to the latest version of the flexgrid control which is 2.6.20102.554 and I noticed the following bug:

When a root node is added to a tree that is collapsed the node never appears.

Even if the tree is expanded, after adding the node the row/node does not appear.

The project attached demonstrates the bug.

Thanks

Emmanuel

FlexGrid SubTotals issue

Dan — Tue, 07 Sep 2010 05:32:47 GMT

Hi,

Am using the FlexGrid.SubTotals() methos as per the Subtotals sample, but am gettgin some strange behaviour. Basically, the fourth level of grouping is not grouping correctly.

My code is:

_flex.Subtotal(AggregateEnum.Clear);

_flex.Tree.Column = 1;

    _flex.Subtotal(AggregateEnum.Sum, 0, -1, transAmtCol, "Grand Total");
    _flex.Subtotal(AggregateEnum.Sum, 1, classCol, transAmtCol, "Class Total for {0}");
    _flex.Subtotal(AggregateEnum.Sum, 2, acctTypeCol, transAmtCol, "Account Type Total for {0}");
    _flex.Subtotal(AggregateEnum.Sum, 3, transTypeCol, transAmtCol, "Transaction Type Total for {0}");

where classCol, acctTypeCol, transTypeCol & transAmtCol are 1, 2, 5 & 40 respectively.

The behaviour I get is the grouping at level 3 does not match the Transaction Type column (see screenshot attachment). As you can see, it has produced a series of sub totals for Transaction Type of Fee. Looking closer, the grouping appears to follow the Transaction ID column - but, when I set the values in this column to null, the grouping does not change. What am i doing wrong?

NOTE: have moved columns in the screenshot so relevant columns are all visible.

Value Filter question

giovanni — Mon, 06 Sep 2010 13:43:53 GMT

Hello everyone,

I've this problem: I've got a flexgrid bounded to a view on a sql2008 db, I activated value filters on some columns, and now my due is to be able to preload value filters with some values preselected. How can I'll be able to do this, I've take a look to documentation but this part onbly speaks about custom filters and not explains how to programmatically manage value filters.

Thank in advance, Gio

C1Flexgrid invisible rows selection issue

jnekula — Fri, 03 Sep 2010 12:26:58 GMT

Hi.

I stumbled upon an issue with the flexgrid. I have a grid with SelectionMode = Row filled with 20 rows. The issue occurs if the last row is invisible. When you select rows with the mouse by clicking on them everything works fine, but when you keep the LMB pressed and just pull the cursor over the last row the grid allows to select the invisible row. When this happens there is no visible highlighted row, the SelChange event fires and the flexgrid.Row points to the invisible one.

Is this an issue or for some reason an intended behaviour?

Thanks for your answer,

Nekula

Change display value for true dbgrid filter drop down

apalcer — Thu, 02 Sep 2010 16:37:09 GMT

I have a column in a true db grid that displays images. Base on the value behind it. However, when I use the filter dropdown it displays the image as "bitmap". How can i change the display value? I cant change the translate option for the column then it will not show the image, but it will display the filter correctly.

I do realize this forum is for flex grid, but I did not see one for true dbgrid.

Thanks

FlexGrid Collapsed TreeNodes show wrong TreeLines if a hidden subnode exists

47110815 — Wed, 01 Sep 2010 22:41:39 GMT

Hi,

it's usual to add a hidden DummyNode to a node
to have those plus/minus signs available to indicate
whether the next DragAndDrop action should move a source node
BEFORE or INTO the target node...

As You can see, if You expand a node owning a hidden dummy subnode,
the tree lines show a wrong downward line, what would be only correct
if the were visible subnodes.
However, there are no.

How can this be fixed?

Gruesse
TB

FlexGrid Node.Move() broken - see also C1 wf Control Explorer TreeView Example

47110815 — Wed, 01 Sep 2010 22:25:44 GMT

Hi,

You really worked hard on FlexGrid.
Some nice features have been built in.
Thank You so much.

However,

somehow parts of the node thing seem to be broken...

Node.Move does not always do the right thing.

See Your TreeView example in C1 Control Explorer:
if You drag an node (with subnodes) to another CLOSED node
the whole sourcenode disappears...

Moving sourceNode ChildOf another node works fine:

Private Sub MoveInto(ByVal sourceNode As Node, ByVal targetNode As Node)
sourceNode.Move(NodeMoveEnum.ChildOf, targetNode )
sourceNode.Move(NodeMoveEnum.Last)
End Sub

However,
moving sourceNode BEFORE another node is a bit tricky,
and does'nt work as expected if the targetNode is COLLAPSED,
i.e. the moved node and it's subnodes become INVISIBLE somehow,
however being at the correct position in the grid...

Private Sub MoveBefore(ByVal sourceNode As Node, ByVal targetNode As Node)
    sourceNode.Move(NodeMoveEnum.ChildOf, targetNode)
    sourceNode.Move(NodeMoveEnum.Last)
    sourceNode.Move(NodeMoveEnum.Out)

    While sourceNode.Index + 1 <> targetNode.Index
        If sourceNode.Index + 1 < targetNode.IndexThen
            sourceNode.Move(NodeMoveEnum.Down)
        Else
            sourceNode.Move(NodeMoveEnum.Up)
        End If
    End While
End Sub

As You see, You have to
1) move the sourceNode ChildOf, because there is no way
      to move a node to another node with the C1Enum
  2) move sourceNode to the real end of childrens list
  3) then Move Out the Node to get to the desired level
  4) and finally then move it to the correct 'before' position by lifting it up node by node

If You leave out step 2), tree is scrambled...
Fascinating.

I'd suggest a quantum of work on Node.Move() to give users the chance to move
a node with it's subnode tree to some other node with a position described by a upgraded NodeMoveEnum...
(FirstSibling, LastSibling, PreviousSibling, NextSibling, FirstChild, LastChild, etc.)

Carry on...
TB

selected cells

wpfhelp — Wed, 01 Sep 2010 07:38:33 GMT

how can i get the selected cells from flexgrid

Thanks

Upgrading FlexGrid to 2010 Q2

PLavelle — Tue, 31 Aug 2010 20:31:41 GMT

We are trying to upgrade our controls to the 2010 Q2 version. I have already submitted an incident report with this issue, but maybe someone on here has input.

This code no longer works. It hides every level 0 node besides the first one:

With C1FlexGrid1

Dim sLevel0Items() As String = {"Root1", "Root2", "Root3", "Root4"}

Dim sLevel1Items() As String = {"Sub1", "Sub2", "Sub3", "Sub4"}

For i As Int32 = 0 To UBound(sLevel0Items)

Dim oRow As C1.Win.C1FlexGrid.Row = .AddItem(sLevel0Items(i))

oRow.IsNode = True

oRow.Node.Level = 0

For j As Int32 = 0 To UBound(sLevel1Items)

Dim oSubRow As C1.Win.C1FlexGrid.Row = .AddItem(sLevel1Items(j))

oSubRow.IsNode = True

oSubRow.Node.Level = 1

oRow.Node.Collapsed = True

End With

This code seems to work, but what is the difference? Is this a bug?

With C1FlexGrid1

Dim sLevel0Items() As String = {"Root1", "Root2", "Root3", "Root4"}

Dim sLevel1Items() As String = {"Sub1", "Sub2", "Sub3", "Sub4"}

For i As Int32 = 0 To UBound(sLevel0Items)

Dim oRow As C1.Win.C1FlexGrid.Row = .AddItem(sLevel0Items(i))

oRow.IsNode = True

oRow.Node.Level = 0

For j As Int32 = 0 To UBound(sLevel1Items)

Dim oSubRow As C1.Win.C1FlexGrid.Row = .AddItem(sLevel1Items(j))

oSubRow.IsNode = True

oSubRow.Node.Level = 1

For Each onode In .Nodes

onode.Collapsed = True

End With

The only difference is collapsing the nodes after the grid has been populated vs. collapsing the nodes after it has been populated (which works).

Thank you.

Changing Cell Programatically not firing Grid Edit events like AfterEdit and ValidateEdit

BumpaRoy — Tue, 24 Aug 2010 17:30:35 GMT

I have a grid with a cell that I want to be edited through a custom dialolg form (a mini-text editor). I capture the BeforeEdit and display the dialog. The user hits OK and it populates the cell within the BeforeEdit event:

fg(e.Row, e.Col) = dlg.txtText.Text.TrimEnd

I need to be able fire off the Validation Events as well as the AfterEdit event to check the text and flow into the other standard logic already coded in these events.

Any ideas?

How to add edit mask to a cell?

lougv22 — Tue, 24 Aug 2010 16:01:56 GMT

I have an editable cell in a FlexGrid that displays date and time. The behavior I want is when the user clicks on it to only allow them to enter valid dates/times in the format MM/DD/YYYY HH:MM. I've tried the following without any success:

C1FlexGrid _fg = null;

new public void ChangeSelection(C1.Win.C1FlexGrid.C1FlexGrid fg, DateTime dt, string sel0, string sel1, string sel2)

{

............................................

_fg = fg;

_fg.Cols[2].EditMask = "99/99/9999 99:99:99";

}

What else can/should I do?

change the height of the rows

jorgebastos — Sat, 21 Aug 2010 19:35:15 GMT

Howdy,

Since the last C1 Studio 2010 V2, the default rows height of bigger than the previous "normal", here's a screenshot:

How can I change the rows height?

Thanks,
Jorge,

How to select multiple cells?

lougv22 — Thu, 19 Aug 2010 21:03:48 GMT

I want to be able to when I click on a row in a FlexGrid all the cells in that row to be selected. How can I do that?

Multiple styles within a cell

wagenb — Thu, 19 Aug 2010 20:28:18 GMT

I don't think this is possible after reading through the C1 documentation but thought I would ask.

Is it possible to have multiple cell styles within cell text? The effect I am trying to get is highlighting certain words within a sentence contained in a flexgrid cell. For example, the cell data is below and I want the 3 words in the sentence highlighted.

All questions are not answered at this time.

Thanks

Complicated drag-drop scenario

AgustAusturnet — Tue, 17 Aug 2010 18:17:31 GMT

Hi,

I have a grid where I need to accomplish two things:

1) When a cell is clicked, highlight all related cells

2) Possible to drag a cell into another empty cell.

My code is attached. Both #1 and #2 are working BUT, #2 only works if the cell is clicked first, and then dragged. It does not work to drag it without clicking it once first.

The issue seems to be that when a cell is dragged without clicking it first, my DragOver function is stuck on thinking that the cell I'm dragging over is the one I'm dragging from. The only requirement for a cell to be able to receive a drag is that it is empty (bookingId less then 1).

If anybody wants to dive in - hints would be warmly welcomed!

Agust

C1Flexgrid scrolling in Citrix not fluid

kalixe985 — Tue, 17 Aug 2010 11:56:39 GMT

Hi,
I'm developping a windows forms application which uses C1Flexgrids in some forms, and this application is executed by users via Citrix. The problem is that, if a grid has trees, some colors (especially a lot) and a lot of rows, when you scroll it, it doesn't scroll fluently and you can see how each row is painted, row by row. This problem is less evident if the grid has no colors or trees. The problem seems to be that citrix paints Flexgrids as an image (bitmap), instead of painting it cell by cell, as Terminal server seems to do. Obviously, the problem can be solved with more network bandwidth for users to connect, but this is difficult -and expensive- to carry out by the company.
So I'd like to know if there is a way citrix to paint Flexgrids more fluently, 'understanding' cells and not painting them as an image. Maybe this is solved in a later version? I'm currently using version 2.6.20063.304 of C1Flexgrid.

Thanks in advance for your help!!!

BeginUpdate before AutoSizeCol results in invisible but active rows

sdfsd34 — Mon, 16 Aug 2010 12:32:15 GMT

If BeginUpdate() is called before AutoSizeCol(int), then the result is that all the grid's contents disappear. However the grid is still bound, the contents are still there, I can click all the rows as usual, but everything is invisible.

Is this a bug, or by design?

I am using the latest stable, and also tried the latest prerelease.

add unbound columns

jlomada — Fri, 13 Aug 2010 17:04:07 GMT

Is it possible to add multiple unbound columns to a bound flexgrid?

dynamicaly creating C1TrueDBGrid

priyagsgp — Thu, 12 Aug 2010 12:29:12 GMT

hi, i want to create C1TrueTBGrid Dynamicaly i.e at run time and Please also tell what are the properties have to set for adding new columns.

Freezing First "visible" Column in the Grid

jjoseph — Wed, 11 Aug 2010 22:00:52 GMT

Hi,

I need to freeze the first visible column in the flex grid. Here are the details.

I have a data source (say data table), which is directly bound to the grid. Now after binding, I need to make the first two columns visible = false. So the third column (C1Grid.Cols(2)) is essentially the first visible column.

The datasource has around 15-20 columns and when its displayed, the scroll bars also come with it and when i scroll to the right side, I want the first visible column (the third column actually), to stay there, and the rest of the them scrollable. Something like the freeze feature of excel.

let me know how to implement this.

Thanks
John

Getting the Column Width of the last column with ExtendLastCol on.

BumpaRoy — Wed, 11 Aug 2010 19:30:02 GMT

How do you capture the width of a column when it is the last column in a grid and extendLastCol is turned on. WidthDisplay returns the same value as Width and that is the set width of the column, not the displayed width which is stretched out to fill the grid size. Any ideas?

C1FlexGrid ColumnInfo refreshes

jlomada — Mon, 09 Aug 2010 15:52:40 GMT

I am currently working on a project that make use of the DataTree sample, however, i am trying to put in my own columninfo to the grid. Everytime the application loads it resets the columninfo even though i have set the autogeneratecolumns to false. is there an event that i can use to avoid the resetting of columns?

Thank you in advance for any solution that can help me.

How to move child row also?

jack_tan — Sun, 08 Aug 2010 14:08:22 GMT

Hi All,

I set the flexgrid to tree style and group two rows as a tree.However ,the child rows haven't move(stay at the original position) when I move the parent node to anohter position .Is there a way to move them as a unit?

Thanks in advance~

Jack

Sort DataMap Column

emasmind — Thu, 05 Aug 2010 11:28:51 GMT

Hi,

Im using the code from the example Flexgrid DataMap to map the column productid with the productname.
I tried sorting the datatable before adding the rows in the hashtable, but nothing.

Is it possible to sort the items of the combobox?

Thank you

Elias Sparagis