We are excited to announce the release of Spire.XLS for Java 12.7.0. This version supports filling the chart series markers with custom images and supports loading and saving files in UOS format. In addition, it fixes some known issues such as the data was incorrect after updating pivot tables. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-3948 | Supports filling the chart series markers with custom images.
IShapeFill markerFill = chart.getSeries().get(0).getDataFormat().getMarkerFill();
markerFill.customPicture("pic.png");
markerFill.setTexture(...);
markerFill.SetPattern(...);
//If use pattern filling, foreground color and backgroud color are needed.
markerFill.setForeColor(...);
markerFill.setBackColor(...);
|
| New feature | - | Supports loading and saving files in UOS format.
Workbook workbook = new Workbook();
workbook.loadFromFile("input.uos");
workbook.saveToFile("output.uos", FileFormat.UOS);
|
| Bug | SPIREXLS-3891 | Optimized support for multiple cultural names and regions. |
| Bug | SPIREXLS-3899 | Fixes the issue that the data was incorrect after updating pivot tables. |
| Bug | SPIREXLS-3925 | Fixes the issue that the styles were incorrect after converting charts to images. |
| Bug | SPIREXLS-3930 | Fixes the issue with incorrectly reading the trendline equations. |
| Bug | SPIREXLS-3931 | Fixed the issue of judging whether the excel file is encrypted incorrectly. |
| Bug | SPIREXLS-3938 | Fixes the issue that the image position moved up after converting HTML to Excel. |
| Bug | SPIREXLS-3939 | Fixes the issue that the text after the checkbox control was lost after Excel was converted to PDF. |
Click the link to download Spire.XLS for Java 12.7.0:
