I have added page break using worksheet.HorizontalPageBreaks.Add() for below positions.
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()?