Get unexpected Border.LineType for a cell in .NET

Aspose.Cells Product Family
,
1

Hi,

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 XL.zip (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 ?

Regards,
Guido

2

@Nachti,

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.

3

@Nachti,
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.

4

@Nachti
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)

5

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