We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Confused at gridweb.activecell and GridWeb1.WorkSheets(GridWeb1.ActiveSheetIndex).ActiveCell

Hi,

First time try gridweb control. I am confused at activecell.

1. why gridweb.activecell <> GridWeb1.WorkSheets(GridWeb1.ActiveSheetIndex).ActiveCell ?

read the forums posts, not get result.

open an excel file in gridweb, only when in celldoubleclick event can get activecell info.

otherwise gridweb.activecell always nothing (VB).

So mouse click or choose cells, no way can get cells choosed info.

2. GridWeb1.WorkSheets(GridWeb1.ActiveSheetIndex).ActiveCell ="A3", but the gridweb control can not display as "A3" cell selected. Dose Gridweb control only set the activecell background, no interface show?

3. How can I use code to make gridweb show as I use mouse select a column or row?

Hi,

Thanks for your posting and using Aspose.Cells for GridWeb.

Please see the GridWeb examples, there are some examples inside it which are related to events like double clicking or activating cells. Please have a look and let us know your feedback.

( http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry539977.aspx )

HI,
I run the demo. click each one sample, not find sample related activecell.

  • Import DataView

    Description

    This Demo Imports data from a DataView Object, data stored in a database table is fetched to DataView Object and displayed in the GridWeb Control.

  • Import/Export Excel

    Description

    This Demo Imports an Excel File from a source and Saves it to your required destination.

  • Creating Contents

    Description

    This Demo creates a Worksheet from the scratch.

  • Edit/ReadOnly Mode

    Description

    This Demo demonstrates the functioning of "Edit" and "Read Only" Modes of GridWeb Control.

  • Protection/Validation

    Description

    This Demo introduces the Data Validation capabilities of GridWeb Control.

  • Skins

    Description

    This Demo covers the Demonstration of GridWeb Control’s preset styles and custom styles.

  • Handling Events

    Description

    This Demo Demonstrates Event Handling related to GridWeb Control.

  • Worksheets

    Description

    The Demo exhibits the manipulation (Add, Remove, Copy) of Sheets.

  • Cells

    Description

    The Demo exhibits the manipulation (Insertion, Deletion) of rows/columns, merging cells and adding/removing comments.

  • Conditional Formatting

    Description

    This Demo Imports an Excel File with conditional formatting.

  • HeaderBar & CommandButton

    Description

    This Demo covers some useful properties of GridWeb Control.

  • FreezePane Report

    Description

    This Demo Imports an Excel File from a source and demonstrates Freezing Panes.

  • Freeze/Unfreeze Panes

    Description

    This Demo expresses customized Freezing Panes.

  • Paginating Sheet

    Description

    This Demo Imports an Excel File from a source and divides the contents of the sheet into different pages.

  • Hyperlink & CellImage

    Description

    The Demo presents the functionality of Hyperlink and CellImage Object.

  • Sort

    Description

    The Demo represents the sorting capabilities of GriWeb Control.

  • Custom Headers

    Description

    This Demo customizes the Labels of Column Headers.

  • Custom Context Menu

    Description

    This Demo introduces how to add custom context menu items to the GridWeb Control.

  • Math

    Description

    This Demo presents the exercise of Mathematical Functions.

  • Borders

    Description

    This Demo presents the setborders function.

  • Text & Data

    Description

    The Demo covers the practice session of String Functions.

  • Statistical

    Description

    The Demo presents the exercise of Statistical Functions.

  • Date & Time

    Description

    The Demo presents the exercise of Date and Time Functions.

  • Logical

    Description

    This Demo presents the Demonstration of Logical Functions.

  • Display Chart

    Description

    This Demo Imports an Excel File with charts.

  • Number Format

    Description

    This Demo covers the exercise of Number Formats.

  • Date & Time Format

    Description

    This Demo covers the exercise of Date and Time Formats.

  • Custom Format

    Description

    This Demo presents an exercise of Custom Formats.

  • Create a Report

    Description

    This Demo creates a PivotTable Report from Microsoft Excel list source.

  • Data Sources

    Description

    The Demo generates PivotTable reports based on different data source objects.

  • Custom Report

    Description

    This Demo customizes a PivotTable report.

  • Number Format Report

    Description

    This Demo covers the exercise of Number Formats in a PivotTable report.

  • Summary Functions

    Description

    The Demo demonstrates PivotFieldFunction enumeration used to summarize PivotTable data field(s).

  • Binding DataSet using Designer

    Description

    This Demo Demonstrates Data Binding Process utilizing Worksheets Designer, data stored in a database table is fetched to DataSet Object and linked to the GridWeb Control.

  • Binding DataSet at Runtime

    Description

    This Demo shows Data Binding Process at runtime without using Worksheets Designer, data stored in a database table is fetched to DataSet Object and linked to the GridWeb Control.

  • Binding to a Custom Collection

    Description

    This Demo demonstrates Binding Expressions with a custom collection at runtime.

  • Hierarchical View

    Description

    This demo shows how to create a Hierarchical View database application with the Aspose.Cells.GridWeb databinding features.

  • Client Side Scripting

    Description

    This Demo explains the usage of client-side scripting with GridWeb Control.

  • Client Side Events

    Description

    This Demo explains the usage of client-side events with GridWeb Control.

  • Client Side Functions

    Description

    This Demo explains the usage of client-side functions with GridWeb Control.

  • GridWeb Form View

    Description

    This demo shows how to use the GridWeb FormView feature.

  • Grouping

    Description

    This demo shows how to use the GridWeb GroupRows feature.

  • Subtotal

    Description

    This demo shows how to use the GridWeb CreateSubtotal feature.

  • Custom Language

    Description

    This Demo explains how to custom the language of the GridWeb Control.

  • AutoFilter

    Description

    This Demo Imports an Excel File from a source and Set the AutoFilter feature.

  • Custom Filter

    Description

    This Demo Imports an Excel File from a source and use a formula to filter rows.

  • XHTML Support

    Description

    The GridWeb control fully supports XHTML 1.0 standard.

  • AJAX Updating

    Description

    This Demo introduces the AJAX capabilities of GridWeb Control.

  • DataSourceControl (.NET 2.0)

    Description

    Aspose.Cells.GridWeb for .NET 2.0 supports binding with DataSourceControl.

  • Browsers Capabilities

    Description

    Browsers Capabilities Chart


Hi,

Thanks for your posting and using Aspose.Cells for GridWeb.

We have tested this issue with the following sample code but it does not activate the cell A4 of the gridweb.


this.GridWeb1.WorkSheets[0].ActiveCell = “A4”;


Also, the difference between GridWeb.ActiveCell and GridWeb.WorkSheets[0].ActiveCell is not clear.

We have logged this issue in our database for investigation. We will look into it and update you. Once, there is some news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43730 - Difference between GridWeb.ActiveCell and GridWeb.WorkSheets[0].ActiveCell

Hi,
After read more posts.
I get these info:
Only client side code

“setActiveCell(row, col);”


can make gridweb display the cell is selected.

Am I right.

B.R.

Hi B.R.

Thanks for your posting and using Aspose.Cells.

Do you want to activate the cell from client side or from server side? If you want to activate cell from client side, then you will activate it using Javascript and with setActiveCell() method as you mentioned.

And if you want to activate the cell from server side, then you will have to activate it using GridWeb.WorkSheets[0].ActiveCell property.

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue and will provide you a fix in few days.

In the fix, you will be able to write both ways:


GridWeb1.ActiveSheetIndex=0;


GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex].ActiveCell = “A4”;



or



GridWeb1.ActiveCell = GridWeb1.WorkSheets[0].Cells[“A4”];

Hi,


Please try our latest version/ fix: Aspose.Cells.GridWeb v8.5.0.2 (attached).

We have fixed your issue now.

Please see the previous post by Shakeel Faiz for your reference.

Let us know your feedback.

Thank you.

The issues you have found earlier (filed as CELLSNET-43730) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.