TAdvGridWorkbook: Sheet "1" with more then 65535 rowes get corrupted after switch and changes are performed on Sheet "2"

[Chmakov_Vladimir]

1. Create Sheet 1
2. Fill in more then 65535 rows in the grid on Sheet 1
3. Create Sheet 2
4. Fill in a few cells
5. switch back to Sheet 1 - top of the Sheet is corrupted, Cells below 65535 are gone
   
   

There is a simple test project attached to demonstrate the issue:

Project1.dpr (234 Bytes)
Unit1.dfm (5.8 KB)
Unit1.pas (1.6 KB)

Windows 10/11
Delphi 11.3.3

[Keld_Hansen]

IIRC, Excel doesn't support more than 65535 rows per sheet.

Try doing the same within Excel itself...

[Chmakov_Vladimir]

When the grid contains one sheet, more than 65535 records could be added and then exported to xlsx without a problem.
The data corruption happens when the second sheet is used.

[Chmakov_Vladimir]

Apparently, to reproduce the issue adding second sheet is enough. No need to add any data to it.

In the attachment the new simpler version of the test project.
Test.zip (2.7 KB)

1. Click Start button, when the "Add Second Sheet" is off. Notice how fast the grid populates and all data is correct.

2. Enable the checkbox. Click Start again and observe that generation takes much longer. Data in the first rows is wrong. Switching between sheets takes a long time.

Have not seen any reply from support yet.
Let me know if I post in a wrong area or you need any additional information.

[brunofierens]

We fixed this issue. The next update will address this.