We are excited to announce the release of Spire.Office 10.1.0. In this version, Spire.Doc supports checking and modifying hyperlinks for images and shapes; Spire.XLS supports the CSCH, RANDARRAY, COTH, SEQUENCE, EXPAND functions; Spire.Presentation supports obtaining the file name of embedded OLE objects; Spire.PDF enhances the conversion from XPS to PDF and PDF to PNG, HTML, SVG, OFD, XPS, and Excel. More details are listed below.
In this version, the most recent versions of Spire.Doc, Spire.XLS, Spire.Presentation, and Spire.PDF are included.
DLL Versions:
- Spire.Doc 13.1.4
- Spire.XLS 15.1.3
- Spire.Presentation 10.1.1
- Spire.PDF 11.1.0
- Spire.PDF 11.1.5
Click the link to get the version Spire.Office 10.1.0:
More information of Spire.Office new release or hotfix:
Here is a list of changes made in this release
Spire.Doc
| Category | ID | Description |
| New feature | SPIREDOC-10532 SPIREDOC-11019 |
Support judging and modifying hyperlinks for images and shapes.
foreach (Section section in doc.Sections)
{
foreach (Paragraph paragraph in section.Paragraphs)
{
foreach (DocumentObject documentObject in paragraph.ChildObjects)
{
if (documentObject is DocPicture)
{
DocPicture pic=documentObject as DocPicture;
if (pic.HasHyperlink)
{
pic.HRef = "";
}
}
if (documentObject is ShapeObject)
{
ShapeObject shape = documentObject as ShapeObject;
if (shape.HasHyperlink)
{
shape.HRef = "";
}
}
}
}
}
|
| Bug | SPIREDOC-10551 | Fixes the issue that the program threw “The given key ‘5’ was not present in the dictionary” exception when converting HTML documents to Word documents. |
| Bug | SPIREDOC-11022 | Fixes the issue that the obtained ListText of paragraphs was incorrect. |
Spire.XLS
| Category | ID | Description |
| New feature | SPIREXLS-5542 | Supports the CSCH function |
| New feature | SPIREXLS-5548 | Supports the RANDARRAY function. |
| New feature | SPIREXLS-5621 | Supports the COTH function. |
| New feature | SPIREXLS-5622 | Supports the SEQUENCE function. |
| New feature | SPIREXLS-5627 | Supports the EXPAND function. |
| New feature | SPIREXLS-5638 | Supports the CHOOSECOLS function. |
| New feature | SPIREXLS-5639 | Supports the CHOOSEROWS function. |
| New feature | SPIREXLS-5642 | Supports the DROP function. |
| New feature | SPIREXLS-5656 | Support setting HyLink for XlsPrstGeomShape.
PrstGeomShapeCollection prstGeomShapeType = worksheet.PrstGeomShapes;
for (int i = 0; i < prstGeomShapeType.Count; i++)
{
XlsPrstGeomShape shape = (XlsPrstGeomShape)prstGeomShapeType[i];
shape.HyLink.Address = "https://www.baidu.com/";
}
|
| Bug | SPIREXLS-5570 | Fixes the issue that the charts were lost when converting XLSM to PDF. |
| Bug | SPIREXLS-5608 | Fixes the issue that the content was lost when converting Excel to PDF. |
| Bug | SPIREXLS-5611 | Fixes the issue that setting ShowLeaderLines did not take effect. |
| Bug | SPIREXLS-5612 | Fixes the issue that the data bar colors were incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5625 SPIREXLS-5647 |
Fixes the issue that the values were incorrect after calling the CalculateAllValue() method to calculate formula values. |
| Bug | SPIREXLS-5635 | Fixes the issue that setting the worksheet tab color to Color.Empty resulted in black. |
| Bug | SPIREXLS-5640 | Fixes the issue that the images were extracted incorrectly. |
| Bug | SPIREXLS-5657 | Fixes the issue that it failed to delete pivot fields in pivot tables. |
| Bug | SPIREXLS-5659 | Fixes the issue that the text orientation in shapes was reversed when converting Excel to PDF. |
Spire.Presentation
| Category | ID | Description |
| New feature | SPIREPPT-2658 | Supports obtaining the file name of embedded OLE objects.
IOleObject oleObject = shape as IOleObject; oleObject.EmbeddedFileName |
| Bug | SPIREPPT-2652 | Fixes the issue that the program threw an exception "object reference not set to object instance" when loading PPTX documents. |
| Bug | SPIREPPT-2657 | Fixes the issue that underlines were discontinuous when converting PPTX to SVG. |
| Bug | SPIREPPT-2690 | Fixes the issue that content was lost when converting PPTX to PDF. |
| Bug | SPIREPPT-2692 | Fixes the issue that checkboxes were missed when converting PPTX to PDF. |
| Bug | SPIREPPT-2702 | Fixes the issue that the program threw an "Object reference not set to an instance of an object" exception when obtaining font names. |
| Bug | SPIREPPT-2703 | Fixes the issue that setting ”Shrink text on overflow“ resulted in incorrect format. |
| Bug | SPIREPPT-2705 | Fixes the issue that setting "Resize shape to fit text" did not take effect. |
Spire.PDF
| Category | ID | Description |
| Bug | SPIREPDF-7162 | Fixes the issue that multi-threaded PDF text extraction error happened. |
| Bug | SPIREPDF-7201 | Fixes the issue that there were incorrect links when converting XPS to PDF. |
| Bug | SPIREPDF-7235 | Fixes the issue that extracting incorrect content from PDF tables. |
| Bug | SPIREPDF-7246 | Fixes the issue that some content turned black when converting PDF to PNG. |
| Bug | SPIREPDF-7248 | Fixes the issue that HTML documents were too large when converting PDF to HTML. |
| Bug | SPIREPDF-7250 | Fixes the issue that annotation content wasn't displayed when converting PDF to XPS. |
| Bug | SPIREPDF-7264 | Fixes the issue that content was lost when converting PDF to images. |
| Bug | SPIREPDF-7279 SPIREPDF-7301 |
Fixes the issue that there were incorrect fonts when converting PDF to SVG. |
| Bug | SPIREPDF-7280 | Fixes the issue that character spaces were missed when converting XPS to PDF. |
| Bug | SPIREPDF-7286 | Fixes the issue that the program threw an "Object reference not set to an instance of an object." exception when loading PDF documents. |
| Bug | SPIREPDF-7288 | Fixes the issue that seal content was cut when converting PDF to OFD. |
| Bug | SPIREPDF-7289 | Fixes the issue that the program threw an "Object reference not set to an instance of an object." exception when converting PDF to grayscale PDF. |
| Bug | SPIREPDF-7051 | Fixes the issue that the content was incorrect when printing PDF. |
| Bug | SPIREPDF-7159 SPIREPDF-7294 |
Fixes the issue that replacing text caused some text to be lost. |
| Bug | SPIREPDF-7211 | Fixes the issue that the program suspended when saving PDF. |
| Bug | SPIREPDF-7221 | Fixes the issue that modifying the value of text fields consumed a long time. |
| Bug | SPIREPDF-7249 | Fixes the issue that some Chinese characters were garbled after converting PDF to XPS. |
| Bug | SPIREPDF-7275 | Fixes the issue that converting PDF to grayscale PDF consumed a long time. |
| Bug | SPIREPDF-7278 | Fixes the issue that the result was incorrect when converting PDF to Excel. |
| Bug | SPIREPDF-7312 | Fixes the issue that the value of the field disappeared when the mouse entered the field after filling the text box field. |
