The grid does not display all rows and encounters an error

Aspose.Cells Product Family
1

Hello,

We have a grid containing many lines.
Not all rows are displayed.
We have a system to extend and fill the tables dynamically.

Also when we descend with the vertical scrollbar and we go back with this last AcwMain.js encounters an error to
Document.getElementById (this.id + “_ leftTab”). Children [1] = .innerHTML data.headstr

thank you in advance for your help

2

@lswe,

Thanks for providing us some details.

Could you try our latest version/fix: Aspose.Cells.GridWeb v17.6.2 with it resource files (“acw_client”):

If you still find the issue with v17.6.2, kindly do create a sample project (runnable), zip the project and post us here to reproduce the issue with all the files, we will check it soon. Also, attach some screen shots to highlight the issue.

Thank you.

3

Step1.png (159.6 KB)
Step2.png (104.3 KB)

Step3-Error.png (29.4 KB)

WeNeedStep1.png (112.6 KB)
WeNeedStep2.png (120.8 KB)

4

Step1 and step2 are what we do in the Aspose grid.
We go to the file DYN-W010 - Consolidation pack MAZARS WEB
In the A300 tab
Not all lines are displayed.
The step3 - error is the error encountered when we want to go back up after getting down into the grid.
WeNeedStep1 and 2 is what we expect.

5

You can find on this URL a sample of the project.
We are in the acwmain.js version 17.6.2.

https://1drv.ms/f/s!AvyGA5WCRAkDgkvRfQCMEKUpFV4t

6

@lswe,

Thanks for the sample project, template file and screenshots.

After an initial test, I am able to reproduce the issue as you mentioned (via your screenshots) by using your sample project with your template file. I found that the Aspose.Cells.GridWeb does not display all the rows and encounters an error. I have logged a ticket with an id “CELLSNET-45488” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

Thank you.

7

@lswe,

Please try using our latest acwmain.js file (you may replace your existing file with this) in your project:
acwmain.zip (57.6 KB)

In order to render worksheet that has hidden rows in async loading way, we need to set RenderHiddenRow=“True”, like in the below code:
e.g
Sample code:

<acw:GridWeb ID="GridWeb1" runat="server" ShowLoading="true" XhtmlMode="true" EnableAJAX="true" EnableAsync="true" RenderHiddenRow="True"

Moreover, in your project, please write/update your code segments like this:

your code:
         protected void Page_Load(object sender, EventArgs e)
                {
                    if (!Page.IsPostBack )
    suggestion:
          protected void Page_Load(object sender, EventArgs e)
                {
                    if (!Page.IsPostBack && !GridWeb1.IsPostBack)

    your code:
         private void SetAllGridWebCellsReadOnly()
                {
                    var activeSheet = GridWeb1.WebWorksheets.ActiveSheet;
                    for (int i = 0; i < activeSheet.Cells.Count; i++)
                    {
                        activeSheet.Cells[i].IsReadonly = true;
                    }
                }
    shall be:
          private void SetAllGridWebCellsReadOnly()
                {
                    var activeSheet = GridWeb1.ActiveSheet;
                   activeSheet.SetAllCellsReadonly();
                }
    your code:
          private void SetAllGridWebCellsEditable()
                {
                    var activeSheet = GridWeb1.WebWorksheets.ActiveSheet;
                    for (int i = 0; i < activeSheet.Cells.Count; i++)
                    {
                        activeSheet.Cells[i].IsReadonly = false;
                    }
                }
    shall be:
          private void SetAllGridWebCellsEditable()
                {
                    var activeSheet = GridWeb1.ActiveSheet;
                    activeSheet.SetAllCellsEditable();
                }

One more thing, please don’t use WebWorksheets/WebWorksheet any more, use GridWorksheetCollection/GridWorksheet instead.

Let us know your feedback.

Thank you.

8

Web Aspose Screen.png (57.7 KB)
Excel Screen.png (69.7 KB)

The result is not good.
You can see on the screen “Excel Screen” that there is more line than on the “Web Aspose Screen”

9

@lswe,

Thanks for the screenshots.

Did you follow the suggestions and update your code in your project as mentioned (in the sample code) in our previous reply here:

Also, kindly use our latest version/fix: Aspose.Cells.GridWeb v17.9 with latest resource files (in acw_client folder @ your installation directory). If you still find the issue, kindly do provide sample project (updated) with v17.9 (with resource files), we will check it soon.

10

I am up to date at source level.

You can find a sample of our code in the link below :

https://1drv.ms/u/s!AvyGA5WCRAkDglXy3E3L5zfI9bI5

Thank you

11

@lswe,

Thanks for the sample project with template files.

I am able to find the issue as per yoru attached screenshots. I executed your updated sample project. I can see the issue in the “A. 300” sheet when loading Excel files starting with “DYN-W010 - Conso pack Mazars…”. I have reopened your issue “CELLSNET-45488” now. We will look into it soon.

12

@lswe,

We did evaluate your issue further. We found the acwmain.js file in your project is older, i.e., “v2017.08.06”. Please try using our latest acwmain.js file, it fixes your issue as I tested. Please find attached the latest version “v2017.09.21” of the file.
acwmain.zip (59.9 KB)