Predefined Excel Styles

Aspose.Cells Product Family
1

Hi,

There are a couple of styles predefined standard in Excel 2007 - Are they available somehow in Aspose.Cells, or shall I try to match them myself?
Thanks
Emmanuel
2

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Well, I am afraid your requested feature is not supported at the moment. We have added your requirement to our internal issue tracking system with issue id: CELLSNET-16859. We will look into it and get back to you soon.

Sorry for the inconvenience,

3

Hi,

Have you decided to implement this? if it is the case, do you have a approximate timeline?
Thanks!
Emmanuel
4

Hi Emmanuel,

We expect to support this feature before the end of this month.

5

Sorry for being pushy

Any update?
Thanks!
6

Hi,

We are sorry that we could not deliver the feature yet. We have to work on some other important tasks in parallel, so could not find much time to work on this feature individually. Hopefully, we can incorporate this feature within 15 days or so.


Thanks for your understanding!

7

Has this been implemented?

Thanks

8

Hi,

We are in the final phase of delivering the feature. It should be completed and the final testing would be done in no more than 10 days. We will let you know if it is implemented.

Sorry for any inconvenience caused!

9

Hi Emmanuel,

Please use the attached updated version Aspose.Cells5.2.0.4.zip. The issue has been fixed.

Code snippet:
Workbook workbook = new Workbook();
Style style = workbook.Styles.CreateBuiltinStyle(BuiltinStyleType.Accent1);
workbook.Worksheets[0].Cells["A1"].SetStyle(style);
workbook.Save(@"D:\FileTemp\dest.xlsx");

Thanks,

10

Great!

Thanks
11

There is a bug in BuiltinStyleType enumeration: BuiltinStyleType.Good is interchanged with BuiltinStyleType.Neutral. Neutral is Green and Good is Yellow.

12

Hi Bengt,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after using the following code with the latest version: Aspose.Cells for .NET 8.2.1. BuiltinStyleType.Good is interchanged with BuiltinStyleType.Neutral.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-43020.

I have attached the output Excel file generated by the code for a reference.

C#


Workbook workbook = new Workbook();


workbook.Worksheets[0].Cells[“A1”].PutValue(“Good”);

Style style = workbook.Styles.CreateBuiltinStyle(BuiltinStyleType.Good);

workbook.Worksheets[0].Cells[“A1”].SetStyle(style);


workbook.Worksheets[0].Cells[“B2”].PutValue(“Neutral”);

style = workbook.Styles.CreateBuiltinStyle(BuiltinStyleType.Neutral);

workbook.Worksheets[0].Cells[“B2”].SetStyle(style);


workbook.Save(@“dest.xlsx”);

13

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.2.1.1 and let us know your feedback.

14

The issues you have found earlier (filed as CELLSNET-43020) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.