Can't change Theme and Color


#1

Hi all,
I’m using Aspose Cell 19.2 to create a workbook.
I open it, go to Page Setup -> Themes and choose another theme but it does not work.

Here is my example:

Workbook _wb = new Workbook(FileFormatType.Xlsx);
_wb.Save(“d:\saved.xlsx”, SaveFormat.Xlsx);
Process.Start(“d:\saved.xlsx”);


#2

@DungLT,
Change of theme is not much noticeable in blank worksheet. You can test it by creating an empty workbook with MS Excel and change the theme. I can not notice any problem using Aspose.Cells for .NET 19.10.4 version. Share screenshots if you still notice this issue.

Aspose.Cells19.10.4 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells19.10.4 For .Net4.0.Zip (5.0 MB)


#3

@DungLT,

After further evaluation, I am able to observe the issue as you mentioned by creating a new workbook (file) by Aspose.Cells APIs. I found that Theme and Color are not changed for the output file (by Aspose.Cells) in MS Excel. I opened the output file into MS Excel manually, clicked on Page Setup and then clicked on Themes. I noticed when hovering over different themes (by mouse) in the list does not change the row/column matrix (UI). Even I changed to some other theme and it does not change anything. I then tested by opening a new Workbook in Ms Excel manually and did the same procedure which works ok. I have logged a ticket with an id “CELLSNET-46993” for your issue. We will look into it soon.

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


#4

@DungLT,
Please set scheme type of the default font as minor, see following codes:

Workbook _wb = new Workbook(FileFormatType.Xlsx);
Style style = _wb.DefaultStyle;
style.Font.SchemeType = FontSchemeType.Minor;
_wb.DefaultStyle = style;
_wb.Save(dir + "dest.xlsx");

Let us know your feedback.


#5

Hi ahsaniqbalsidiqui,
I tried and it work fine :slight_smile:
Thank you for your support.


#6

@DungLT,

Good to know that your issue is sorted out by the suggested code segment. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.