PDf export generates empty pages

FLX TMS FlexCel for VCL & FMX
1

Hi,
I have excel with about 9500 rows. Start of data looks like this

kuva
kuva732×238 18.7 KB

and after that it's just continous data with subtotal lines every now and then. No empty lines between.
Sub total are static (calculated by generating software) so no formulas there.

With following code, I get every other page as empty. What i'm missing?

var
  pdf: TFlexCelPdfExport;
  x: TXlsFile;
  Outfile: TFileStream;
  lOutFIle: string;
begin
  x:= tXlsFile.Create;
  loutfile := '\temp\productsales.pdf';
  x.Open('\temp\productsales.xlsx');
  outfile := TfileStream.Create(lOutFile,fmcreate);
  Pdf := TFlexCelPdfExport.Create( );
  try
    Pdf.AllowOverwritingFiles := true;
    Pdf.BeginExport( outfile);
    Pdf.Workbook := x;
    Pdf.PageLayoutDisplay := TPageLayoutDisplay.TwoColumnContinuousLeft;
    Pdf.ExportAllVisibleSheets( false, 'Raportti' );
    Pdf.EndExport;
  finally
    Pdf.Free;
    outfile.Free;
  end;
  pdfview.FileName :=lOutFIle;
end;

My flexcel version is 7.14. D10.3.1

2

Forget it. Noticed that reportt tile "montly report" is too right , causing only it to be exported on 2nd page