Hi,
Hi,
Thank you,
Hi,
Hi,
Hi,
We think you must have re-saved the Simple.xls by Excel2007 or later versions. From excel2007 there are more pre-defined named styles automatically created. The extra styles in the re-saved xls are just those new named styles imported from excel2007.
We are afraid Workbook.getStyles() cannot fit your requirement here. The StyleCollection returned by this method only contains named styles, not includes the styles used by cells. If you required, we may consider to provide a new method for you to get all styles that used by cells. However, colors are used not only by cells, also they can be used by other objects such as shapes, charts, …etc. If your template file contains only cells data with formattings, your current way of checking and replacing colors can work. But if there are other objects such as chart, it is not enough for the used colors by checking colors used by style objects only.
Hi,
Hi,
Thanks for your feedback and future request. We will look into it and consider adding it.
In fact if you are using excel2007 to view the generated xls file, there should be no color lost even if the color is not in the palette. When one color is not in the palette, we will choose the nearest color in palette to represent the custom color for excel2003 and prior versions for display. At the same time the information of the custom color also be saved into the xls file and the custom color can be shown correctly for excel2007 and later versions. So please confirm whether you need to make so complicate logic to change the palette. To check the whether one color has been used by any object in workbook is complicated and time-consumed. Finally if you decide you really need to change palette in this way, we will look into this requirement to decide how to provide you some APIs for this purpose(provide style list for you to check by yourself or check it at our end for you).
Hi,
Hi,
Hi,
That’s good news!
Many thanks!
The issues you have found earlier (filed as CELLSJAVA-40011) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.
The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan