TAdvGridExcelExport 3.4 issue

VCL TMS VCL UI Pack
1

Hello,

It looks like TAdvGridExcelExport does not export the last sheet of the assigned AdvGridWorkbook whne exporting an xls (for xlsx it works ok)

2

How many sheets are there?
Details to reproduce?

3

Hello,

I will try to explain in detail, first I create a AdvGridWorkBook with this code

grid := TAdvGridWorkbook.Create(self);
grid.Width := 0;
grid.Height := 0;
self.InsertControl(grid);
grid.Visible := false;

The I call the grid.AddSheet(aName); for as many times needed and finally I call this code

grid.ActiveSheet := 0;
xls_export1.AdvGridWorkbook := grid;
xls_export1.Export(aFileName);

Some more information, I use the latest versions of all components, TAdvGridExcelIO works ok (but I cannot use it as I need xlsx format also), I tried with 2 sheets and works ok, with 4 Excel first gives an error “We found a problem with some content in ‘abc.xls’. Do you want to ttry to recover …” and the last sheet is missing. The sheets are all created and filled with the same code.

Regards

4

I will also try to save the sheets content to a file and see if there is an issuw with my data

5

When setting the CellsAsStrings the xport function works ok, so the issue should be on the actual data on the StringGrid?

6

Issue resolved, there was a NaN value that caused the problem

7

Thanks for informing!