Setting interior color bug

Aspose.Cells Product Family
1

I ran into a very specific and strange issue.

When setting the interior color of a cell where the following items are met:

  • The row (collection of rows) directly above it is (are) grouped but detail is still shown (i.e. the row group is not collapsed)
  • The cell directly above it has a bottom border

After setting the color, when you attempt to hide the detail of the group above, the bottom border of the cell directly above remains showing, when it should be hidden.

I have attached example input, actual output and expected output files.
border issue v1.zip (22.5 KB)

2

@ianpaul,

Thanks for sample files and some details.

Could you share sample code (runnable) to generate the output file by Aspose.Cells and highlight the issue(s)
(by encircling in red color) while comparing both output file (by Aspose.Cells) Vs your expected file (by MS Excel) in screenshots. This will help us really to evaluate your issue precisely and to consequently figure it out soon.

3

Yes sorry I forgot to specify which cell was having the issue.

If you collapse row 17 and view row 18, you will see that the formatting of cell D18 still shows a top border (incorrect) while cell C18 and E18 both have the correct formatting.

sample code:

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(path);

        Aspose.Cells.Worksheet worksheet = workbook.Worksheets["Sheet1"];

        for (int i = 1; i <= 8; i++)
        {
            int row = i * 3 - 1;

            Aspose.Cells.Cell cell = worksheet.Cells[row, 3];

            Style style = cell.GetStyle();

            style.Pattern = BackgroundType.Solid;
            style.ForegroundColor = Color.PaleVioletRed;

            cell.SetStyle(style);
        }

        workbook.Save(path2);
4

@ianpaul,
Could you please use the folowing codes to get the style of the cell.

Style style = cell.GetStyle(false);

Let us know your feedback.