Free Support Forum -

Get unexpected Border.LineType for a cell in .NET


when I use this code
Workbook wbXL = new Workbook(“XL.xlsx”);
Worksheet ws = wbXL.Worksheets[0];
CellBorderType cbType = ws.Cells[“C26”].GetDisplayStyle().Borders[Aspose.Cells.BorderType.BottomBorder].LineStyle;
CellBorderType cbType2 = ws.Cells[“C26”].GetStyle().Borders[Aspose.Cells.BorderType.BottomBorder].LineStyle;

from this file (14.4 KB)

the type is ‘dotted’ and not ‘continuous’ as expected.
If I use the VBA code, I get ‘continuous’, too.

Can you check what happens ?



Please notice, I am able to reproduce the issue as you mentioned using your template file. I found I got wrong and unexpected Border.LineType for a cell. I have logged a ticket with an id “CELLSNET-48022” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Please try the latest fix 21.4.3.
Aspose.Cells21.4.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.4.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.4.3 For .NetStandard20.Zip (5.5 MB)

The issues you have found earlier (filed as CELLSNET-48022) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao