PageBreakPreview

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
timokhov
Posts: 8
Joined: Sun Oct 28, 2018 4:16 pm

PageBreakPreview

Post by timokhov »

How can I set PageBreakPreview mode?

I only found this enumeration type in Package\D2007\Xc12DataWorksheet5.hpp:
"enum TXc12SheetViewType { x12svtNormal, x12svtPageBreakPreview, x12svtPageLayout };"

But I cannot understand - what property of Worksheet I must set.
timokhov
Posts: 8
Joined: Sun Oct 28, 2018 4:16 pm

Re: PageBreakPreview

Post by timokhov »

Hello!

Finally I get access to sources.
And I know now how to do subj.
May be it would be helpful for other developers.

Code: Select all

type
   TXLSWorksheetHack = class(TXLSWorksheet) end;
var
   xls: TXLSReadWriteII5;
   i: integer;
begin
   xls := TXLSReadWriteII5.Create(nil);
   ... fill xls

   for i := 0 to xls.Count-1 do
      TXLSWorksheetHack(xls.Sheets[i]).FXc12SheetView.View := x12svtPageBreakPreview{from unit Xc12DataWorksheet5.pas};

   xls.FileName := ...
   xls.Write();
end;
Please include direct access (without hacking TXLSWorksheet) to FXc12SheetView.View, like TXLSWorksheet.Options.
Post Reply