Scrollbars and default sheet

Aspose.Cells Product Family
1

Hi there,


We are quite interested in using aspose cells component for our application. We have extensive use of gridweb component and are looking forward to customize it like the excel spreadsheet.

I was wondering if I can give scrollbars (horizontal and vertical) to the gridweb… I do see the properties nohscroll,novscroll,noscroll but nothing works… I am not sure if it’s right approach…

Also for my evaluation purpose, I am binding the grid to the data produced out of my local excel spreadsheet… But every time I bind it, it creates new sheet instead of ingesting data in default sheet 1.

I am unable to remove sheet1…
I am in process of finalizing this component for my application,
Please help me to clear these doubts,

Thanks,
Nirav
2

Hi,


Which version of the product you are using? Please try our latest version v2.6.3.2000 downloading and installing Aspose.Cells for .NET v7.0.1:
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry328122.aspx

If you still find the issue, kindly do create a sample project, zip it and attach it here to show the issues you mentioned. We will check your issue(s) soon.

Thank you.

3

Amjad,


Thanks for prompt reply,
I have installed latest version .Net 7.0.1 only… Is it same as latest version v2.6.3.2000…do I need to install any other thing for webgrid ?

Thanks,
Nirav.
4

Hi,

You only need Aspose.Cells for GridWeb Dll and don’t need any others.

If you want to download it separately, then you can used this link:
Aspose.Cells.GridWeb v2.6.3.2000

5

Yes…that’s what I have… version 2.6.3.2000 and .net 7.0.1, still I don’t see it working… just fyi, i am trying to play with this sample using vs.net inbuilt server and not IIS… Can that be causing it ??

Really appreciate your time,

Thanks,
Nirav.

6

Hi,

Please provide us your sample C# project utilizing the gridweb and some screenshots illustrating the problem with scrollbars. We will look into it and update you asap.

7

Hi,


Here it is…

Please have a look at two issues…

a) Scrollbars doesn’t show up.
b) By default all the values gets added to a new sheet and not the default one…

Many thanks,
Nirav.
8

Hi,

You can remove the default webworksheet using the following code.

C#


GridWeb1.WebWorksheets.RemoveAt(0);

For your Vertical Scroll bar issue, we have logged it in our database. We will help you asap.

This issue has been logged as CELLSNET-30779.

Screenshot:

9

Hi,


After further investigation, we come to know that it is not an issue. Actually you are using older version of the file i.e. “acwmain.js” that is there in the “Grid\acw_client” folder in your project which is causing this issue. Please get/obtain the file in the “acw_client” folder at your installation directory downloading and installing Aspose.Cells for .NET v7.0.1 (as I suggested you earlier):

Replace this file or copy/paste the file “acwmain.js” from your installation folder to your project’s “Grid\acw_client”. If you have already installed the latest version of Aspose.Cells for .NET (7.0.1), then simply get the file from your installation folder and replace with it in your project folder.

I have tested your project doing so and it works fine.

2) Also kindly do add a line before importing the data view, it will import data to the first worksheet by default:
GridWeb1.WebWorksheets.Clear();
GridWeb1.WebWorksheets.ImportDataView(ds.Tables[0].DefaultView,null, null);

Thank you.

10

Great Amjad,


Let me test that way… Also one quick question our one of the projects is still in .net 2.0 and 3.5… Is this version .Net v7.0.1 compatible with older frameworks (viz 2.0,3.5) or not ??

I will verify things you suggested and get back.

Thanks,
Nirav.
11

Hi,

We provide two compiled versions for Aspose.Cells.GridWeb in two folders at your installation directory. i.e.
net1.0 —> e.g Aspose.Cells.GridWeb v2.6.3.1000 --> it works fine on .NET framework 1.x. (VS.NET 2002, 2003 )

net2.0 —> e.g Aspose.Cells.GridWeb v2.6.3.2000 ----> this works fine on any .NET framework which is greater than or equal to .NET framework v.2.x (e.g 2.x, 3.0, 3.5, 4.0 etc.) VS.NET 2005, 2008, 2010 etc.

Thank you.