Change color of smartArt of excel to black and white

Aspose.Cells Product Family
1

Please find attached the excel having smartArt. I want ti change the smartArt to black and white or grayscale using Aspose.cells. Ihave used the below code but it is not applying black and white color
foreach (Shape shape in sheet.Shapes)
{
// Check if the shape is a SmartArt (GroupShape in Excel)
if (shape.IsSmartArt)
{
// Get the SmartArt result and extract the grouped shapes
var smartArt = shape.GetResultOfSmartArt();

    // Loop through each shape inside the SmartArt
    foreach (Shape innerShape in smartArt.GetGroupedShapes())
    {
        // Set the fill color of the shape to white
        innerShape.Fill.FillType = FillType.Solid;
        innerShape.Fill.SolidFill.Color = Color.White;

        // Set the line color of the shape to black
        innerShape.Line.FillType = FillType.Solid;
        innerShape.Line.SolidFill.Color = Color.White;
    }
}

}

Please find attached the excel below
smartart.zip (14.5 KB)

2

@nraj,

Thanks for the template Excel file.

After initial testing, I am able to reproduce the issue as you mentioned by using your template Excel file and sample code snippet. I found the color of SmartArt shapes in Excel spreadsheet is not changed to black and white and is remained with existing (previous) colors.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will either devise code snippet or deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57931

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@nraj
We only support reading cached shapes of smart art. We do not support updating SmartArt. SmartArt is a complex feature that we cannot support in the short term.
We apologize for the inconvenience caused to your work!

4

Same thing I have observed for textbox as well, we are not able to fill color in it but excel supports filling color. Do I need to create separate ticket for this or you can keep track of this as well?

5

@nraj
Would you like to provide your sample file and test code? We will check it soon.

6

@nraj
Is the textbox you mentioned in SmartArt? If you could provide a sample file, it would be very helpful for us to locate the issue. We will check it soon.

7

Please find attached the excel below
textBox.zip (7.4 KB)

8

@nraj
By testing on the latest version v25.2 using the following sample code, we can obtain the expected result. Please refer to the attachment. out_net.zip (8.5 KB)

// Instantiating a Workbook object
Workbook workbook = new Workbook(filePath + "textBox.xlsx");

// change fill color
Shape shape = workbook.Worksheets[0].Shapes[0];
shape.Fill.SolidFill.Color = Color.Red;

// Saving the Excel file
workbook.Save(filePath + "out_net.xlsx");

If you still have questions, please provide runnable test code and we will check it soon.

9

Yes, for textbox it is working fine in latest version. Only smartArt will remain as issue.

10

@nraj
Thank you for your feedback. Aspose.Cells currently does not support updating SmartArt. We will notify you promptly once there is any progress. Sorry for the inconvenience caused to you.