Import ASE model and create rectangular Torus into the Scene with Aspose.3D for .NET 18.1

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn


Aspose.3D for .NET logo
We are pleased to announce the availability of new version 18.1.0 of Aspose.3D for .NET API. The new version 18.1 of the API has been released with the support of importing 3D ASE models. Developers can create rectangular torus object in 3D scene as well as set the load option of RVM model to center the scene by moving the root node.

Import ASE models into the Aspose.3D API

With the help of Aspose.3D for .NET API, developers can import ASE 3D models, and then save to supported 3D formats. The multiple constructors and Open method of Diagram class allow to import 3D models. Please refer to this help topic: Reading a 3D Scene

Create rectangular Torus object in 3D Scene

With the recent version 18.1 of Aspose.3D for .NET API, developers can create rectangular Torus object in 3D scene. In order to achieve this, we have added RectangularTorus class. Please refer to the code example as documented in this help topic: Create rectangular Torus in 3D Scene

Furthermore, CenterScene member has been added to the A3DObject class. It helps to center the scene by moving the root node. This is the code example:

// initialize a 3D scene
Scene scene = new Scene();
scene.Open(@"c:\temp\test.rvm", new RvmLoadOptions() {CenterScene = true});

Aspose.3D for .NET Resources

The following resources will help you work with Aspose.3D for .NET:

  • Home page for Aspose.3D for .NET API
  • Aspose.3D product family forum – Post your technical questions, queries and any other problem you faced while running Aspose.3D APIs.
  • Aspose.3D for .NET online documentation – help documentation and API reference documents.
  • Enable Blog Subscription – Do not limit yourself, you can keep yourself updated with the latest news on Aspose.3D APIs, new features, fixes and other API related topics by subscribing to Aspose.3D blog.
  • Aspose.3D for .NET Examples – We have published our code examples on the social coding website GitHub.com. Anyone could explore the code examples for learning purposes.
  • Install Aspose.3D NuGet package – We publish each version of Aspose.3D for .NET API as a NuGet package on the NuGet gallery and recommend our clients upgrade old version to the latest one.
  • Release Notes – For details on API fixes, please check Release Notes having a complete list of the new features.

We hope you will enjoy this new release that save time and huge efforts for related files manipulation. The API is quite simple and can easily be used in any application.

Posted in Aspose.3D Product Family, Imran.Rafique | Leave a comment

Preserve Meta Characters During Replacement Show Hide Chart Axis using Aspose.Words for Android via Java 18.1

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn
Aspose.Words for Android via Java

We are pleased to announce the new monthly release of Aspose.Words for Android via Java 18.1. Aspose.Words for Android via Java has full functionality of Aspose.Words for Java with few limitations, minor API changes and additional requirements. This version also includes all bug fixes and public API changes made in Aspose.Words for Java 18.1, see following release notes for more information.

Aspose.Words for Java 18.1 release notes
Aspose.Words for Android via Java 18.1 release notes

Aspose.Words for Android via Java 18.1 now allows you to perform following tasks:

Here is a look at just a few of the biggest features and API changes in this month’s release.

  • Performance improvements.
  • Improved character spacing control logic.
  • Improved space shrinking for Verdana font.
  • Improved “allow handing punctuation” handling when kerning is enabled.
  • Fixed clip issue with semi-broken tables.
  • Fixed draw order of wrapped shapes in 2013 mode.
  • Fixed repeated header height problem during field update.
  • Fixed the bug causing error in page numbers in multi-page documents rendered into PostScript.
  • Proper calculation of undocumented margins in DrawingML Charts implemented.
  • Horizontal axis of Bubble Chart scaling fixed.
  • Vertical axis of 3DArea Chart scaling fixed.
  • MS Word 2016 approach for rendering of DrawingML Charts axis labels implemented; (Labels are rotated to fit the chart).
  • Fixed rendering of Legend markers for 3D-LineChart.
  • Improved rendering of composite (with multiple series) charts.
  • Chart title with ManualLayout rendering fixed.

‘Aspose.Words for Android via Java’ is an advanced Word document processing API to perform a wide range of document processing tasks directly within your native Android applications. Aspose.Words for Android via Java API supports DOC, OOXML, RTF, HTML, OpenDocument, PDF, XPS, EPUB and other formats. You can generate, modify, convert and render documents.
Learn more about Aspose.Words for Android via Java

Aspose.Words for Android via Java API Resources

Following are the links to some useful resources you may need to accomplish your tasks.

Start a Free Trial Today

Start a free trial today – all you need is to sign up with Aspose. Once you have signed up, you are ready to try all the powerful file processing features offered by Aspose.

You can easily download ‘Aspose.Words for Android via Java’ API for evaluation. The evaluation download is the same as the purchased download. The evaluation version simply becomes licensed when you add a few lines of code to apply the license.

The evaluation version of Aspose.Words for Android via Java (without a license specified) provides full product functionality, but it inserts an evaluation watermark at the top of the document on open and save, and limits the maximum document size to several hundred paragraphs.

If you want to test ‘Aspose.Words for Android via Java’ API without the evaluation version limitations, you can also request a 30-day Temporary License. Please refer to How to get a Temporary License?

Posted in Aspose.Words Product Family | Leave a comment

Vector Format Support in Aspose.BarCode for SSRS 18.1

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.BarCode for SSRS We are pleased to announce the release of Aspose.BarCode for Reporting Services 17.1. The major development in this release is the support to the generated barcode image in Vector format.

Setting Vector Format Of Barcode Image

Aspose.BarCode for Reporting Services now enable the developers to save the generated barcode image in vector format. Two new formats EMF and SVG has been introduced. Saving barcode image in vector format is very simple and is demonstrated in the code snippet given below. The code snippet contains comments that makes it self explanatory.


// Instantiate BarCodeBuilder object
Aspose.BarCode.ReportingServices.BarCodeBuilder builder = new Aspose.BarCode.ReportingServices.BarCodeBuilder();

// Set the Code text for the barcode
builder.CodeText = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

// Set the symbology type to QR
builder.EncodeType = Aspose.BarCode.Generation.EncodeTypes.Code128;

//Save the image
builder.Save("code128.svg", Aspose.BarCode.ReportingServices.BarCodeImageFormat.Svg);

Other Improvements

This release also fixes exceptions that were reported by our valued customers. Complete list of fixes in this release is as follows.

  • It was noticed that when font is specified while saving the barcode image in vector format. The barcode inaccurate text was displayed. The process of drawing barcode text has been improved.
  • Setting big text size with StringAlignment.Far option, it was noticed that the barcode text disappears. Now the issue has been fixed.
  • Working of CodeLocation property has been improved.

To view the complete list of new features and fixes, please visit the release notes page. This release also includes many important API and Backward Incompatible changes. The list of all such changes are worth seeing and can be view on release notes page. You can download the latest version by visiting the Aspose.BarCode for Reporting Services 18.1 page in downloads section.

Aspose.BarCode for Reporting Services Resources

The following resources will help you work with Aspose.BarCode for SSRS:

Posted in Aspose.BarCode Product Family | Leave a comment

Saving Barcode Image In Vector Format With Aspose.BarCode for .NET 18.1

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.Barcode for .NET We are pleased to announce the release of Aspose.Barcode for .NET 18.1. The major development in this release is the support to save the generated barcode image in Vector format. This release also supports enhanced process of drawing barcode text when font is specified in the code snippet. Improved working of CodeLocation property has also been incorporated in this release.

Support of Vector Image Format

Aspose.BarCode supports the functionality to save the generated barcode image in vector format. Two new values EMF and SVG has been introduced in Aspose.BarCode.BarCodeImageFormat enumeration which can be set before saving barcode image. Aspose.BarCode.BarCodeImageFormat enumeration now contains:

  • Bmp
  • Gif
  • Jpeg
  • Png
  • Tiff
  • TiffInCmyk
  • Emf
  • Svg
How a developer can save barcode image in vector format is quite simple and is demonstrated in the code snippet given below. The code snippet contains comments that makes it self explanatory.


// Instantiate BarCodeBuilder object
Aspose.BarCode.BarCodeBuilder builder = new Aspose.BarCode.BarCodeBuilder();

// Set the Code text for the barcode
builder.CodeText = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

// Set the symbology type to QR
builder.EncodeType = Aspose.BarCode.Generation.EncodeTypes.Code128;

//Save the image
builder.Save("code128.svg", Aspose.BarCode.BarCodeImageFormat.Svg);

Other Improvements

This release also fixes exceptions that were reported by our valued customers. Complete list of fixes in this release is as follows.

  • It was noticed that when font is specified while saving the barcode image in vector format. The barcode inaccurate text was displayed. The process of drawing barcode text has been improved.
  • Setting big text size with StringAlignment.Far option, it was noticed that the barcode text disappears. Now the issue has been fixed.
  • Working of CodeLocation property has been improved.

To view a complete list of enhancements and fixes, please visit the release notes page. This release also includes many important API and Backward Incompatible changes. The list of all such changes are worth seeing and can be view on release notes page. You can download the latest version by visiting the Aspose.Barcode for .NET 18.1 page in downloads section. You can access the same through Nuget Gallery.

Aspose.BarCode for .NET Resources

You can get started with Aspose.BarCode for .NET by making use of information available in the following:

Posted in Aspose.BarCode Product Family | Leave a comment

Fix to use the API on Mac and other enhancements included in Aspose.Cells for JavaScript via Java 17.12

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

We are pleased to announce the release of Aspose.Cells for JavaScript via Java 17.12. This release includes a number of features, enhancements and bug fixes which further improve the overall stability and usability of the API. Aspose.Cells for JavaScript via Java has almost full functionality of Aspose.Cells for Java with a few limitations, minor API changes and additional requirements. See the following release notes on major features and other improvements for your reference.
Aspose.Cells for JavaScript via Java 17.12 release notes

This release includes an important fix for using Aspose.Cells for JavaScript via Java on Mac environment. Since the code base of Aspose.Cells for JavaScript via Java is derived from its parent Aspose.Cells for Java, so most of the features, changes, enhancements and fixes included in the Aspose.Cells for Java v17.12 are also included in this Aspose.Cells for JavaScript via Java release. Both Aspose.Cells for Java and Aspose.Cells for JavaScript via Java share the same Docs. Please check the list of document/articles added for the new release in the Aspose.Cells for Java Wiki Docs:

Aspose.Cells for JavaScript via Java Resources

Following are the links to some useful resources you may need to accomplish your tasks.

Posted in Aspose.Cells Product Family | Leave a comment

New Improvements and Code Snippets added in Aspose.Pdf for C++ 17.12

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

aspose-pdf-for-cppAs per the regular monthly update process, Aspose.Pdf for C++ 17.12 has been released and is now available for download. Since it has always been our objective to provide more features and improvements in our APIs, new code snippets against classes of the API are added in this release of Aspose.Pdf for C++. If you are going to upgrade to latest version, we suggest you to please visit release notes page of Aspose.Pdf for C++ 17.12, in order to have an overview of improvements and changes in the API.

One of the major changes in Aspose.Pdf for C++ 17.12 is, we have used new version of ICU (i.e ICU59) instead of ICU58. Along with that we have improved the performance of Regex class in this new version of API. You can see the list of all classes in release notes, for which we have added new code snippets in the library. Adding more code snippets to the classes have made Aspose.Pdf for C++ 17.12, more efficient and user friendly.  Furthermore, we also have made sure that all features offered by the existing classes and methods of the API, are properly listed and comprehensive.

In order to use the newly added code snippets, you can browse the Aspose.Pdf.Cpp folder, after unzipping the downloaded package and open any class (e.g PdfFileEditor.h) in some text editor (e.g Notepad) or Visual Studio. You will be able to find that code snippet(s) are given above each method of the class with its description. We would also like to share that process of updating API documentation is also in progress and we are trying our best to provide each and every example in the API docs to demonstrate the features of the API.

Miscellaneous Resources

Please visit the following links for information regarding latest release of Aspose.Pdf for C++ 17.12 and Release Notes section. In case you have any question about Aspose.Pdf for C++, you can post your inquiry in Aspose.Pdf forums. We will be more than happy to assist you there.

Posted in Aspose.Pdf Product Family, Asad Ali | Leave a comment

Text Extraction Error Reporting and PDF Incremental Updates Features

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

We are pleased to announce that Aspose.Pdf for Java 17.12 is available for download with new features and improvements. In case you are planning to updgrade your existing API to the latest version, we recommend you to please check the release notes of Aspose.Pdf for Java 17.12 for an overview of public API changes and improvements. However, following are some major improvements and fixes in terms of text extraction and document manipulation features.

Implemented Text Extraction Error Reporting Functionality

While investigating a scenario where a PDF document used PDF Type 3 fonts, it was observed that the TextAbsorber class was not retrieving the text correctly. Reason was that the fonts used in the PDF, contained different encoding and it is not possible to extract text from such documents, by using Adobe Reader itself. We realized the necessity to implement a functionality in the API that such error in the document can be reported. We are pleased to inform you that text extraction error reporting has been implemented for TextAbsorber and TextFragmentAbsorber classes, which is available with Aspose.Pdf for Java 17.12. Following code snippet can be used to detect errors while extracting text from a PDF document:

Document pdf = new Document("test.pdf");
TextAbsorber absorber = new TextAbsorber();
absorber.getTextSearchOptions().setLogTextExtractionErrors(true);
pdf.getPages().accept(absorber);
if (absorber.hasErrors()) {
// Information about found errors and locations is stored in
// Errors collection.
for (TextExtractionError error : absorber.getErrors()) {
// TextExtractionError object contains information about the
// text extraction error found during processing concrete
// text fragment.
System.out.println(error);
System.out.println(String.format("Extracted text: '{0}'",
error.getExtractedText()));
}
}

Save PDF document into Stream object using Incremental Updates

It was observed that when you load a PDF document from binary, manipulate it (i.e add some annotations) and save it to a different binary – the content of the PDF document was used to be totally changed. In order to avoid such issues, we have implemented an additional method i.e saveIncrementally() into the Document class. Now you will be able to save document into a Stream object, using Incremental Updates.

Miscellaneous Fixes

As it always recommended to use latest release of our API’s as they include latest features / improvements and fixes related to issues reported in earlier released versions. Therefore, please download the latest release of Aspose.Pdf for Java 17.12.

Posted in Aspose.Pdf Product Family, Asad Ali | Leave a comment

Preserve Meta Characters During Replacement Show Hide Chart Axis using Aspose.Words for Java 18.1

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.Words for Java

We are pleased to announce the new monthly release of Aspose.Words for Java 18.1. The release of this month contains number of new features, enhancements and bug fixes of the issues reported by our users in previous versions. Please check the detailed release notes of Aspose.Words for Java 18.1 to get an idea about all the new features/enhancements and fixes made in this release. Furthermore, if you are planning to upgrade the API from any previous version, we strongly recommend you to check the Public API Changes section of current release and other intermediate releases from release notes folder, to know what has been changed since your current revision of the API.

The following sections describe some details regarding these newly added features/enhancements.

Enhanced Support of Single-Column Table Data Bands and Conditional Blocks for LINQ Reporting Engine

We have enhanced the support of data band inside a single-column table row for LINQ Reporting Engine. In previous versions of Aspose.Words, when opening and closing foreach tags are inside same cell, the output contents would be in the same cell. Starting from Aspose.Words 18.1, you can export the single-column data band in separate new row using greedy switch. Please refer to the following article for more detail.
Working with Table-Row Data Bands

In this release, we have enhanced the support of conditional blocks in table’s row for LINQ Reporting Engine. If you put an opening if, elseif, or else tag and a closing if tag in the same cell, the engine treats a template option formed by these tags as a common one rather than a table-row one by default. However, you can override this behavior making the engine to treat such a template option as a table-row one by specifying a greedy switch. Please refer to the following article for more detail.
Working with Table-Row Conditional Blocks

Added Feture to Preserve Meta-Characters During Replacement

We have added FindReplaceOptions.PreserveMetaCharacters property in Aspose.Words 18.1 to preserve meta-characters beginning with “&” during replacement. Please check the detail and code example from following article.
How to Preserve Meta-Characters During Replacement


/// 
/// True indicates that meta-characters beginning with "&" are preserved.
/// Default value is false.
/// 
public boolean PreserveMetaCharacters

Removed Obsolete Method in CompositeNode

In this release, we have removed following obsolete public method from CompositeNode class. The parameter “isLive” is not used anymore. Please use CompositeNode.GetChildNodes(NodeType nodeType, bool isDeep) instead.


public NodeCollection getChildNodes(NodeType nodeType, boolean isDeep, boolean isLive)

Added Feature to Show Hide Chart Axis

We have added new feature in the release of Aspose.Words to show or hide the chart axis. You can use ChartAxis.Hidden property to achieve this. Please refer to the following article for more detail.
How to Hide Chart Axis


/// 
/// Gets or sets a flag indicating whether this axis is hidden or not.
/// 
/// 
/// Default value is false.
/// 
public boolean Hidden
{
    get; set;
}

Added Feature to Get StoreItemID Property of StructuredDocumentTag

XmlMapping.StoreItemId property has been added in this release to specify the custom XML data identifier for the custom XML data part. Please read DataBinding class for more detail about storeItemID property.


/// 
/// Specifies the custom XML data identifier for the custom XML data part which
/// shall be used to evaluate the  expression.
/// 
public String StoreItemId

Other Improvements

There are 63 improvements and fixes in this regular monthly release. The most notable are:

  • Improved character spacing control logic.
  • Improved space shrinking for Verdana font.
  • Improved “allow handing punctuation” handling when kerning is enabled.
  • Fixed clip issue with semi-broken tables.
  • Fixed draw order of wrapped shapes in 2013 mode.
  • Fixed repeated header height problem during field update.
  • Fixed the bug causing error in page numbers in multi-page documents rendered into PostScript.
  • Proper calculation of undocumented margins in DrawingML Charts implemented.
  • Horizontal axis of Bubble Chart scaling fixed.
  • Vertical axis of 3DArea Chart scaling fixed.
  • MS Word 2016 approach for rendering of DrawingML Charts axis labels implemented; (Labels are rotated to fit the chart).
  • Fixed rendering of Legend markers for 3D-LineChart.
  • Improved rendering of composite (with multiple series) charts.
  • Chart title with ManualLayout rendering fixed.

Aspose.Words for Java Resources

The following resources will help you work with Aspose.Words for Java:

Posted in Aspose.Words Product Family | Leave a comment

QR Barcode Version Setting Using Aspose.BarCode for JasperReports 17.12

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.BarCode for JasperReports We are pleased to announce new Aspose.BarCode for JasperReports 17.12 release.

This release includes support to generate the QR barcode with version number setting. Enhanced speed and quality of 1D barcode recognition process has also been incorporated in this release.

To view a complete list of new features, enhancements and fixes, please visit Aspose.Barcode for JasperReport 17.12 release notes page.

You can download the latest release of Aspose.BarCode for JasperReports from the following link: Download Aspose.BarCode for JasperReports 17.12

Aspose.BarCode for JasperReports Resources

The following API resources can be of help to you in getting started:

Posted in Aspose.BarCode Product Family | Leave a comment

Read and Write External Connection of XLSB file, Query Cell Areas Mapped to XmlMap Path and Implement Cell.FormulaLocal in Aspose.Cells for Android via Java 17.12

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.Cells for Android logoWe are pleased to announce the release of Aspose.Cells for Android via Java 17.12. This release includes a number of features, enhancements and bug fixes that further improve the overall stability and usability of the API. We also recommend our clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Please check the release notes in order to get an idea about what is new and what has been fixed with this revision of Aspose.Cells for Android via Java. While you are downloading the latest build, here is a look at the most worth mentioning features in this release.

Read and Write External Connection of XLSB file

Aspose.Cells already supports read and write external connection of xlsx file but now, it also supports this feature for xlsb file. However, the code is same for both types of format. Please see the following article that explains how to make use of this feature.

Specify how to cross string in output HTML using HtmlCrossType

When cell contains text or string but it is larger than the width of the cell, then the string overflows if the next cell in next column is null or empty. When you save your Excel file into HTML, you can control this overflow by specifying the cross type using the HtmlCrossType enumeration.

Interrupt or Cancel the Formula Calculation of Workbook

Aspose.Cells provides a mechanism to interrupt or cancel the formula calculation of workbook using the AbstractCalculationMonitor.interrupt() method. This is useful when formula calculation of workbook is taking too much time and you want to cancel its processing.

//Implement calculation monitor class
class clsCalculationMonitor extends AbstractCalculationMonitor
{
    public void beforeCalculate(int sheetIndex, int rowIndex, int colIndex)
    {
        //Find the cell name
        String cellName = CellsHelper.cellIndexToName(rowIndex, colIndex);
  
        //Print the sheet, row and column index as well as cell name
        System.out.println(sheetIndex + "----" + rowIndex + "----" + colIndex + "----" + cellName);
  
        //If cell name is B8, interrupt/cancel the formula calculation
        if (cellName.equals("B8") == true)
        {
            this.interrupt("Interrupt/Cancel the formula calculation");
        }//if
  
    }//beforeCalculate
  
}//clsCalculationMonitor
  
//---------------------------------------------------------     
//---------------------------------------------------------
  
public void Run() throws Exception
{   
    //Load the sample Excel file
    Workbook wb = new Workbook(dirPath + "sampleCalculationMonitor.xlsx");
 
    //Create calculation options and assign instance of calculation monitor class
    CalculationOptions opts = new CalculationOptions();
    opts.setCalculationMonitor(new clsCalculationMonitor());
 
    //Calculate formula with calculation options
    wb.calculateFormula(opts);
}

Set the Values Format Code of Chart Series

You can set the values format code of chart series using the Series.ValuesFormatCode property. This property is not only useful for the series which are based on the range inside the worksheet but also works well for the series created with array of values.

Utilize Sheet.SheetId property of OpenXml using Aspose.Cells

Sheet.SheetId property is found inside the DocumentFormat.OpenXml.Spreadsheet namespace and is part of OpenXml. You can see this property and its value inside workbook.xml. Aspose.Cells provides the equivalent property as Worksheet.TabId.

Find the root element name of Xml Map

Aspose.Cells allows you to find the root element name of XML map using XmlMap.RootElementName property. For more detail, please see this article.

Query Cell Areas Mapped to Xml Map Path

You can query cell areas mapped to xml map path with Aspose.Cells using the Worksheet.xmlMapQuery() method. If the path exists, it will return the list of cell areas related to that path inside xml map. The first parameter of Worksheet.xmlMapQuery() method specifies the xml element path and the second parameter specifies the xml map you want to query.

The following sample code queries the xml map two times and prints the list of cell areas returned by the Worksheet.xmlMapQuery() method on console.

//Load sample Excel file having Xml Map
Workbook wb = new Workbook(dirPath + "sampleXmlMapQuery.xlsx");

//Access first XML Map
XmlMap xmap = wb.getWorksheets().getXmlMaps().get(0);

//Access first worksheet
Worksheet ws = wb.getWorksheets().get(0);

//Query Xml Map from Path - /MiscData
System.out.println("Query Xml Map from Path - /MiscData");
ArrayList ret = ws.xmlMapQuery("/MiscData", xmap);

//Print returned ArrayList values
for (int i = 0; i < ret.size(); i++)
{
    System.out.println(ret.get(i));
}

System.out.println("");

//Query Xml Map from Path - /MiscData/row/Color
System.out.println("Query Xml Map from Path - /MiscData/row/Color");
ret = ws.xmlMapQuery("/MiscData/row/Color", xmap);

//Print returned ArrayList values
for (int i = 0; i < ret.size(); i++)
{
    System.out.println(ret.get(i));
}

Determine Smart Art Shape and Convert it to Group Shape

Smart Art shapes are special shapes that allow you create complex diagrams automatically. Aspose.Cells allows you to detect Smart Art shapes and convert them to Group shape that enables you to handle smart art shape like a group shape. Consequently, you will have access to the individual parts or shapes of the group shape.

Create and Protect a Shared Workbook

Microsoft Excel allows you to create a shared workbook. When you share the workbook, then more than one user can edit the workbook. Aspose.Cells enables you to create a shared workbook with Workbook.Settings.Shared property. Besides, you can protect or unprotect a shared workbook.

Render Sequence of Pages using PageIndex and PageCount Properties of ImageOrPrintOptions

Aspose.Cells allows you to render sequence of pages of your Excel file to images using ImageOrPrintOptions.PageIndex and ImageOrPrintOptions.PageCount properties. These properties are useful when there are so many pages in your worksheet but you need to render a few pages only. This will not only save the processing time but also saves the memory consumption of the rendering process.

Ignore Errors while Rendering Excel to PDF

You can ignore all errors during the conversion process using the PdfSaveOptions.IgnoreError property. This way, conversion process will be completed smoothly without throwing any error or exception but data loss may occur.

Implement Cell.FormulaLocal similar to Excel VBA Range.FormulaLocal

Microsoft Excel formulas may have different names in different locales/regions or languages. For example, SUM function is called SUMME in German. Aspose.Cells cannot work with non-English function names. In Microsoft Excel VBA, there is Range.FormulaLocal property that returns the name of the function as per its language or region. Aspose.Cells also provides Cell.FormulaLocal property for this purpose. However, this property will only work when you will implement GlobalizationSettings.getLocalFunctionName(String standardName) method. For more detail, please see this article.

The following sample code explains how to implement GlobalizationSettings.getLocalFunctionName(String standardName) method.

//Implement GlobalizationSettings class
class GS extends GlobalizationSettings {

	public String getLocalFunctionName(String standardName)
	{
		//Change the SUM function name as per your needs.
		if(standardName.equals("SUM"))
		{
			return "UserFormulaLocal_SUM";				
		}
				
		//Change the AVERAGE function name as per your needs.
		if (standardName.equals("AVERAGE"))
		{
			return "UserFormulaLocal_AVERAGE";
		}

		return "";
	}//getLocalFunctionName
}//GS extends GlobalizationSettings

//-----------------------------------------
//-----------------------------------------

public void Run() throws Exception {

	//Create workbook
	Workbook wb = new Workbook();

	//Assign GlobalizationSettings implementation class
	wb.getSettings().setGlobalizationSettings(new GS());

	//Access first worksheet
	Worksheet ws = wb.getWorksheets().get(0);

	//Access some cell
	Cell cell = ws.getCells().get("C4");

	//Assign SUM formula and print its FormulaLocal
	cell.setFormula("SUM(A1:A2)");
	System.out.println("Formula Local: " + cell.getFormulaLocal());

	//Assign AVERAGE formula and print its FormulaLocal
	cell.setFormula("=AVERAGE(B1:B2, B5)");
	System.out.println("Formula Local: " + cell.getFormulaLocal());
}

Render Office Add-Ins while converting Excel to Pdf

Aspose.Cells now supports to render MS Office Add-ins (in Excel files) in the output PDF. You do not need to use any special method or property to render Office Add-Ins in the output PDF. For more detail, please see this article.

Auto populate Smart Markers data to other worksheets if data is too large to handle in a single worksheet

Sometime, you want to auto populate smart marker data to other worksheets if it is too large. Suppose, your data source has 1500000 records. These are too many records for a single worksheet, then you can move the rest of the records to next worksheet. For more detail and sample code, please see this article.

Set the Shape type of Data labels of chart

You can change the shape type of data labels of the chart using the DataLabels.ShapeType property. It takes the value of DataLabelShapeType enumeration and changes the shape type of data labels accordingly. For more detail, please see this article.

Export worksheet CSS separately in output HTML

Aspose.Cells provides the feature to export worksheet CSS separately when you convert your Excel file to HTML file format. Please use HtmlSaveOptions.ExportWorksheetCSSSeparately property for this purpose and set it to true while saving Excel file to HTML format. For more detail on the feature, please see this article/document for your reference.

Prefix Table elements Styles with HtmlSaveOptions.TableCssId property

Aspose.Cells allows you to prefix table elements styles with HtmlSaveOptions.TableCssId property. For more detail, please see this article.

Aspose.Cells for Android via Java Resources

The resources, you may need to accomplish your tasks:

Posted in Aspose.Cells Product Family | Leave a comment