We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Background for cell in excel doesn't work

Version 7.0.2 and 7.0.3

the next example fine works http://www.aspose.com/documentation/java-components/aspose.cells-for-java/colors-background-patterns.html

but if remove code style.setPattern( BackgroundType.VERTICAL_STRIPE );
or set style.setPattern( BackgroundType.SOLID );
The background will be empty.




The solution is using style.setTwoColorGradient




final Color color = Color.getBrown();
Style style = cell.getStyle();
style.setTwoColorGradient( color, color, GradientStyleType.HORIZONTAL,
4 );
cell.setStyle( style );
cell.setValue( color.toArgb() );

Hi,


"but if remove code style.setPattern( BackgroundType.VERTICAL_STRIPE );
or set style.setPattern( BackgroundType.SOLID );
The background will be empty."

Please see the “Note” in the topic:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/colors-background-patterns.html

Note: If you select BackgroundType.None value from the BackgroundType enumeration, forground color will not be applied whereas background color is not applied if you select BackgroundType.None or BackgroundType.Solid value

Thank you.