ReoGrid Forum

Subhi Aswad

Member

Registered: 2015-01-27

Posts: 4

print many pages in reogrid 8.5.0

thanks MR Jing for help me

but when I Changed dll to 8.8.3 for C#.net (VS 2013 ) some events not available like
After Cell Edit and Selection Range change
and code for ReoGridEditor not available in solution

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: print many pages in reogrid 8.5.0

Hi, that will be helpful if you post detailed error information and your code. Welcome to join forum.

Subhi Aswad

Member

Registered: 2015-01-27

Posts: 4

Re: print many pages in reogrid 8.5.0

i need this events in 8.8.3

is it Available ????

Private Sub grid_SelectionRangeChanged(sender As Object, e As RGRangeEventArgs) Handles grid.SelectionRangeChanged
        Try

            ButtonItem17.Checked = grid.GetRangeStyle(e.Range).Bold
            ButtonItem18.Checked = grid.GetRangeStyle(e.Range).Italic
            ButtonItem19.Checked = grid.GetRangeStyle(e.Range).Underline
            ButtonItem20.Checked = grid.GetRangeStyle(e.Range).Strikethrough
            ButtonItem21.Checked = grid.GetRangeStyle(e.Range).TextWrapMode

            ButtonItem22.Checked = grid.GetRangeStyle(e.Range).HAlign = ReoGridHorAlign.Right
            ButtonItem23.Checked = grid.GetRangeStyle(e.Range).HAlign = ReoGridHorAlign.Center
            ButtonItem24.Checked = grid.GetRangeStyle(e.Range).HAlign = ReoGridHorAlign.Left

            ButtonItem25.Checked = grid.GetRangeStyle(e.Range).HAlign = ReoGridHorAlign.DistributedIndent

            ButtonItem26.Checked = grid.GetRangeStyle(e.Range).VAlign = ReoGridVerAlign.Top
            ButtonItem27.Checked = grid.GetRangeStyle(e.Range).VAlign = ReoGridVerAlign.Middle
            ButtonItem28.Checked = grid.GetRangeStyle(e.Range).VAlign = ReoGridVerAlign.Bottom

        Catch ex As Exception

        End Try

and this events

Private Sub grid_AfterCellEdit(sender As Object, e As RGCellAfterEditEventArgs) Handles grid.AfterCellEdit
        Try

            If e.Cell.Data <> Nothing Then

                If (e.Cell.Data.ToString().Chars(0) = "@" And chenag_val_by_user) Then

                    Dim qr = From x In Enumerable.Range(0, cls.str_view.GetLength(0)) Where cls.str_view(x, 2) = grid.SelectionRange.Row.ToString() And cls.str_view(x, 3) = grid.SelectionRange.Col.ToString() Select x

                    If IsDBNull(qr(0)) Then
                        Return
                    End If

                    Dim val_qr As Short = qr(0)

                    Dim menu_item As New ToolStripMenuItem()
                    menu_item.Tag = cls.str_view(val_qr, 0)
                    menu_item.Text = cls.str_view(val_qr, 1)

                    Menugrid.Items.Add(menu_item)

                    cls.str_view(val_qr, 0) = Nothing
                    cls.str_view(val_qr, 1) = Nothing
                    cls.str_view(val_qr, 2) = Nothing
                    cls.str_view(val_qr, 3) = Nothing

                    Dim st As New ReoGridRangeStyle()
                    st.Flag = PlainStyleFlag.TextColor
                    st.TextColor = Color.Black

                    grid.DoAction(New RGSetRangeStyleAction(grid.SelectionRange, st))

                    e.NewData = ""

                End If

            End If

            ComboBoxItem2_SelectedIndexChanged(sender, e) ' for font name
            ComboBoxItem3_SelectedIndexChanged(sender, e) ' for font size

        Catch ex As Exception

        End Try

    End Sub

Last edited by Subhi Aswad (2015-01-27 17:03:40)

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: print many pages in reogrid 8.5.0

The SelectionRangeChanged and AfterCellEdit events are available to worksheet. Latest versions after 0.8.7 are multiple worksheet supported that means you need get a worksheet instance before attaching events, try change the code like below:

VB.NET:

' inside Form_OnLoad 
Dim sheet = grid.CurrentWorksheet

AddHandler sheet.SelectionRangeChanged, AddressOf grid_SelectionRangeChanged
AddHandler sheet.AfterCellEdit, AddressOf grid_AfterCellEdit

Subhi Aswad

Member

Registered: 2015-01-27

Posts: 4

Re: print many pages in reogrid 8.5.0

thanks MR Jing very very very much  for help

Last Questions :

1: how to show the Blue Rectangle for print Border and Changed in form like ReoGridEditor Form (Demo) ?
2: i have some rgf files (xml reogrid files) worked at dll 0.8.5.0 , is it working at dll 0.8.8.3 without Errors (grid.load() and grid.save())
3: when add image to control and save file the image dos not saved (xml file) , is it available in new versions ?

really this Beautiful Control and thank you .

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: print many pages in reogrid 8.5.0

Thanks!

1. To show page breaks, try this code:

sheet.EnableSettings WorksheetSettings.View_ShowPageBreaks

ReoGrid uses some set of settings called WorksheetSettings for worksheet, WorkbookSettings for workbook, to decide most behaviors, appearance and enabling/disabling built-in features to the worksheet and workbook. They could be changed by the following methods:

SetSettings <settings_flags>, True/False
EnableSettings <settings_flags>
DisableSettings <settings_flags>

More details: http://reogrid.net/document/settings

2. Not a question

3. Image saving and loading to ReoGrid XML file format might available in future, but has low priority. Instead loading image from Excel file is planning to be supported in future versions. How about to use Excel as the template instead of ReoGrid XML file?

Last edited by Jingwood (2015-01-29 12:26:41)

Subhi Aswad

Member

Registered: 2015-01-27

Posts: 4

Re: print many pages in reogrid 8.5.0

thanks MR Jing
it is very Beautiful control