I have a question about PDF Bookmarks in Aspose.Cells. I have a simple Aspose.Cells workbook with one worksheet. I am exporting this workbook to a PDF file. The workbook has 100 rows of data in it and I inserted a page break every 25 rows. Immediately following each page break, I put in a PDFBookmarkEntry. My problem involves the behavior of the bookmarks when I open the file in a PDF reader.
When I open the PDF file and zoom in so that only a portion of the page is visible, and then click on a bookmark entry, I’m taken directly to the destination cell. The thing though is that I want the bookmark entry to take me to the top of the page, not the cell at the top of the page. This difference is evident when the worksheet has a header. Clicking the bookmark will take you to the cell, but not the very top of the page, cutting off the “File Header”. This is hard to describe, so I attached some screenshots.
The attached Current.PNG shows what happens when you click on “Row number 51”. See how the page is navigated to the cell “Row number 51” but it’s not navigated to the very top of that page? The user has to scroll up to see the “File Header”. Note that the file is zoomed in to page width (150% in this case).
The attached Ideal.PNG shows what I would like to happen when you click on “Row number 51”. The page is navigated to the top of the page. Again, the file is zoomed in to page width.
Note that the navigation works as I’d like it to when I select “fit one page to window”. I’ve attached the actual PDf file so you can see for yourself how the bookmarks work.
In summary: how do I insert a PDF Bookmark Entry that will navigate to the very top of the page when clicked? Not the cell at the top of the page.
Here is my C# code that generates the attached PDF file. I tried to keep it short.
static void Main(string[] args)
{
Program.Licenses();
var wb = new Workbook();
var ws = wb.Worksheets[0];
var bmRoot = new PdfBookmarkEntry()
{
IsOpen = true,
Destination = ws.Cells[0, 0],
Text = “Root”,
SubEntry = new System.Collections.ArrayList()
};
for (int i = 0; i < 100; i++)
{
var cell = ws.Cells[i, 0];
//text
cell.Value = string.Format(“Row number {0}”, i + 1);
//bg color
{
var style = cell.GetStyle();
style.ForegroundColor = System.Drawing.Color.LightGray;
style.Pattern = BackgroundType.Solid;
cell.SetStyle(style);
}
if (i % 25 == 0)
{
ws.HorizontalPageBreaks.Add(i);
var bmCell = new PdfBookmarkEntry()
{
IsOpen = true,
Destination = cell,
Text = string.Format(“Row number {0}”, i + 1)
};
bmRoot.SubEntry.Add(bmCell);
}
}
{ //header
const int LEFT = 0;
var ps = ws.PageSetup;
ps.SetHeader(LEFT, “&16&BFile Header”);
}
var so = new PdfSaveOptions(SaveFormat.Pdf);
so.Bookmark = bmRoot;
string path = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), “file.pdf”);
wb.Save(path, so);
}