Pagebreaks

[pedgaard]

Hi,

I am facing a problem when trying to access page horizontal breaks with Spire.
I need to get the row number of the these horizontal page breaks.

No matter what I try, I get this once I try to use the PageBreak.

"Unable to cast object of type 'Spire.Xls.Core.Spreadsheet.XLSHPageBreak to type Spire.Xls.HPageBreak"

lWorkBook:= lWorkBook.Workbook;
lWorkBook.LoadFromFile('C:\NAV\name.xlsx',FALSE);
lWorkSheets := lWorkBook.Worksheets;
lWorkSheet := lWorkSheets.Item('Ark1');
lPageBreaks1 := lWorkSheet.HPageBreaks; //lPageBreaks1 = Spire.Xls.Collections.HPageBreaksCollection.'Spire.XLS, Version=7.11.1.7040, Culture=neutral, PublicKeyToken=663f351905198cb3'

//MESSAGE(FORMAT(lPageBreaks1.Count)); //This works fine...

lPageBreak1 := lPageBreaks2.Item(0); //lDoes not work ! lPageBreak1 = Spire.Xls.Core.IHPageBreak.'Spire.XLS, Version=7.11.1.7040, Culture=neutral, PublicKeyToken=663f351905198cb3'

[Betsy.jiang]

Hi pedgaard,

Thanks for your inquiry.
Please try to use explicit conversions, convert lPageBreaks2.Item(0) to type Spire.Xls.HPageBreak.
If there is still issue, please provide us entire code you were using for investigation.

Sincerely,
Betsy
E-iceblue support team

[pedgaard]

Hi,

I just checked again, and no luck.

Here is code - might look strange to you, as this is Microsoft Dynamics NAV C/AL code - that gets converted to C#.

lWorkBook:= lWorkBook.Workbook;
lWorkBook.LoadFromFile('C:\NAV\name.xlsx',FALSE);
lWorkSheets := lWorkBook.Worksheets;
lWorkSheet := lWorkSheets.Item('Ark1');
lPageBreaks1 := lWorkSheet.HPageBreaks;
lPageBreak1 := lPageBreaks1.Item(0); //Cast error

Please try and see if you can access a workbooks individual pagebreak items without cast error

[Betsy.jiang]

Hi pedgaard,

Thanks for your information again.
I have noticed the issue and posted it to our Dev team. We will inform you when it is fixed.
Sorry for inconvenience.

Sincerely,
Betsy
E-iceblue support team

[pedgaard]

Thank you.

[Betsy.jiang]

Hi pedgaard,

Thanks for your waiting.
Now the issue has been resolved in Spire.XLS Pack Hotfix Version:7.11.13, welcome to test it.

Best wishes,
Betsy
E-iceblue support team

[pedgaard]

I will test immediately.

[pedgaard]

Thank you, the issue has been solved.

[Betsy.jiang]

Dear pedgaard,

Thanks for your feedback.
Please feel free to contact us if there is any question.

Sincerely,
Betsy
E-iceblue support team