Horizontal Page Break Issues

Aspose.Cells Product Family
1

I have added page break using worksheet.HorizontalPageBreaks.Add() for below positions.

worksheet.HorizontalPageBreaks.Add(“S31”);
worksheet.HorizontalPageBreaks.Add(“S69”);

When i’m try to get the page break details using worksheet.GetPrintingPageBreaks() is not giving the correct page break which are already added.
I got below result for above one.

CellArea - E5:S30 -Correct
CellArea - E31:S67 -Wrong -i have added upto S69 but i’m getting here as S67
CellArea -E68:S68 - Coming in the next page.

So i want the reason why its not displaying as per the Horizontal page break value…
Is the horizontal page break value should not reflect in GetPrintingPageBreaks() or
Is any default rows (limit for each page) are available for each page break in GetPrintingPageBreaks()?

2

@RajRitheesh,
Please share your sample file and complete (runnable) code snippet with us for our testing. We will reproduce the problem and provide our feedback after analysis.

3

@ahsaniqbalsidiqui Thanks for your response.

I have found the issue in my code…Sorry for late reply

4

@RajRitheesh,

Good to know that you have sorted it out now. In the event of further query or issue, feel free to write us back, we will happy to assist you soon.

5

@Amjad_Sahi sure… Thanks:-)