No Scroll appears

Aspose.Cells Product Family
1

Hi,

Query regarding Aspose.Cells.GridView control

If the control size is small and sheet is loaded is large then also scroll is not comming
do i need to do any setting for that?
Note: Evaluation Copyright warning sheet has scrolls and if select mysheet after evaluation sheet then scroll started comming on my sheet too.
But after reload again scroll gets disappear.
please suggest

Regards,

Nikhil

2

Hi,


Please try our latest version v2.6.4.xxxx downloading from the Aspose.Cells for .NET v7.0.2 package (download module).

You may also try our latest fixed version v2.6.4.2004:
https://forum.aspose.com/t/135239

If you still find the issue, kindly create a sample application, zip it and post it here to show the issue. We will check it soon.

Thank you.

3

Hi ,

The issue has not yet resolved.

Please find the attached sample application.

You also can see, after loading the file shows only 8 rows but if i want to add more rows and columns at runtime then what should i do?

Regards,

Nikhil

4

Well, GridWeb’s MaxRow and MaxColumn are set to 7 at design time. You may specify your desired number of rows and columns to these properties accordingly.


And, you have disallowed some operations on the client side in your code e.g

GridWeb1.EnableClientColumnOperations = false;
GridWeb1.EnableClientFreeze = false;
GridWeb1.EnableClientMergeOperations = false;
GridWeb1.EnableClientRowOperations = false;

So, you cannot perform inserting rows/cols at runtime by using GridWeb’s context manu.

Thank you.
5

Hi Amjad,

Ok..Got it..Thanks for your great co-ordination

Please tell me about scroll also. As per discussion i have attached the sample code. You can obeserve that scroll is not comming evenif the sheet is not fit in the given area.

Regards,

Nikhil

6

Hi,


Well, your javascript reference does not configure fine, please add the following contents to your web.config file (accordingly):<o:p></o:p>

<o:p></o:p>

<o:p></o:p>

Thank you.

7

Hi Amjad,

After adding above statements now stared getting the scrollbars.

But formula calculations are not happening automatically. Please check it in the code i have submitted to you. After we update the cell loader starts but after that the formula cell value not getting updated. Please suggest

Regards,

Nikhil

8

Hi,


Please followup your other thread for your second issue.
<a href="https://forum.aspose.com/t/121298

Thank you.
9
Could you add code to "LoadGrid()" method, e.g
//Set GridWeb properties
GridWeb1.EnableAJAX = true;
GridWeb1.EnableClientColumnOperations = false;
GridWeb1.EnableClientFreeze = false;
GridWeb1.EnableClientMergeOperations = false;
GridWeb1.EnableClientRowOperations = false;
GridWeb1.EnableStyleDialogbox = false;


GridWeb1.WebWorksheets.RunAllFormulas();

it will work fine