Support for ODF 1.2, Show Cell Ranges as Data Labels and Copy Sparklines Group with Aspose.Cells for Android 8.3.1

aspose Cells for Android 100 Support for ODF 1.2, Show Cell Ranges as Data Labels and Copy Sparklines Group with Aspose.Cells for Android 8.3.1Aspose.Cells for Android 8.3.1 has been released. This release contains some useful features and other improvements. Below, we list some major features and other enhancements in the new release.

Save ODS File in ODF 1.1 and 1.2 Specifications

Aspose.Cells APIs have extended its support for the OpenDocument Format. Now users can save the ODS (OpenDocument Spreadsheets) in conformance to ODF 1.2 specifications. Aspose.Cells APIs have exposed the methods isStrictSchema11 & setStrictSchema11 for the OdsSaveOptions class to support this feature. The default value of the setStrictSchema11 property is false, which means that from version 8.3.1 of Aspose.Cells, ODS files will be saved as ODF format version 1.2 by default. For more details, please check the article Save ODS file in ODF 1.1 and 1.2 Specifications.

Insert Values in ListObjects using Row/Column Offset

Normally, you add values inside the ListObject/Table using the Cell.putValue method, however, the putValue method must be associated with an instance of a Cell to identify the correct location where value has to be inserted. This mechanism is not usable when you need to add values inside the ListObject using the row and column offsets. Aspose.Cells for Android 8.3.1 has exposed the methods Cell.getTable & ListObject.putCellValue methods to facilitate the users in Accessing the ListObject from a Cell and Add Values using the Row and Column Offsets.

Create Sparkline by Specifying Data Range and Location

Aspose.Cells APIs have exposed the SparklineCollection.add(String dataRange, int row, int column) method to Specify the Data Range and Location of Sparkline Group.

Show Cell Ranges as Data Labels

Aspose.Cells provides the DataLabels.setShowCellRange attribute to select or clear the option Label Contains – Value From Cells. For more details, please see the article Showing Cell Range as the Data Labels.

Other Enhancements and Fixes

Aspose.Cells for Android 8.3.1 has provided fixes and other enhancements for several important issues, such as, reading/writing Microsoft Excel files, calculating formulas, manipulating charts and shapes, sheet to image, chart to image and Excel to PDF bugs, etc.

 

To see a complete list of enhancements and fixes and to download Aspose.Cells for Android 8.3.1, please visit the download page.

Posted in Aspose for Android APIs, Aspose.Cells Product Family | Leave a comment

Announcing Aspose for Java vs Docx4j 1.1 – Now with Added Features

aspose words for java Announcing Aspose for Java vs Docx4j 1.1   Now with Added Featuresdocx4j Announcing Aspose for Java vs Docx4j 1.1   Now with Added FeaturesWe’ve created a new release of the Aspose for Java comparison to Docx4j. The new release, Missing Features of Docx4j in Aspose 1.1, shows a number of Aspose.Words features missing in Docx4j.

The source code of these examples is freely hosted on popular social coding sites like CodePlexGitHubBitbucket and SourceForge.

This release contains a few new examples of features that are only available in Aspose APIs and not in Docx4j API of Project Docx4j and related tools.

What’s New

Existing Samples

There is much more yet to come and many more examples with documentation are available at Aspose Docs. Keep visiting us.

Related Posts

 

Posted in Aspose for Java APIs, Aspose.Total Product Family, Aspose.Words Product Family | Leave a comment

Use Aspose for Cloud PHP SDK to Work with Bookmarks, Hyperlinks, Headers and Footers in Word Documents

Aspose.Words for Cloud

aspose Words for CloudAPIs 100 Use Aspose for Cloud PHP SDK to Work with Bookmarks, Hyperlinks, Headers and Footers in Word DocumentsAspose.Words for Cloud’s platform independent document manipulation API is a true REST API that can be used with any language: .NET, Java, PHP, Ruby, Rails, Python, jQuery and many more. You can use it with any platform — web, desktop, mobile, and cloud.

With Aspose.Words for Cloud you can modify and convert documents on the cloud. It supports DOC, DOCX, OOXML, RTF, HTML, OpenDocument, PDF, XPS, EPUB and many other formats. Learn More

New Words Features in the Aspose for Cloud PHP SDK

We have implemented the following functions to the Aspose for Cloud PHP SDK:

Installing the Aspose for Cloud PHP SDK

You can download it using “Composer” from any of the following places:

Usage Examples

Get all Bookmarks from a Word Document

use Aspose\Cloud\Common\AsposeApp;
use Aspose\Cloud\Common\Product;
use Aspose\Cloud\Words\Document;

Product::$baseProductUri = 'http://api.aspose.com/v1.1';
AsposeApp::$appSID = "XXXXXXXXXX";
AsposeApp::$appKey = "XXXXXXXXXX";

$document = new Document('Test.docx');
$result = $document->getBookmarks();
print_r($result);

Start a Free Trial Today

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

Posted in Aspose SDKs, Aspose for Cloud APIs | Leave a comment

Support for ODF 1.2, Insert Values in ListObjects using Offset, Copy Sparkline Group with Aspose.Cells for Java 8.3.1

aspose Cells for Java 100 Support for ODF 1.2, Insert Values in ListObjects using Offset, Copy Sparkline Group with Aspose.Cells for Java 8.3.1We are pleased to announce that the Aspose.Cells for Java 8.3.1 is now available for public use. This release contains many useful improvements, including the long awaited  support for the ODF 1.2 specifications. Please refer to the release notes of Aspose.Cells for Java 8.3.1 for a full list of bug fixes and improvements. If you are planning to upgrade the API from any previous version, we would suggest you to check the Public API Changes section first.

While you are downloading the latest build, here is a look at the biggest features in this release.

Save ODS File in ODF 1.1 and 1.2 Specifications

Aspose.Cells APIs have extended its support for the OpenDocument Format. Now users can save the ODS (OpenDocument Spreadsheets) in conformance to ODF 1.2 specifications. Aspose.Cells APIs have exposed the methods isStrictSchema11 & setStrictSchema11 for the OdsSaveOptions class to support this feature. The default value of the setStrictSchema11 property is false, which means that from version 8.3.1 of Aspose.Cells, ODS files will be saved as ODF format version 1.2 by default. For more details, please check the article Save ODS file in ODF 1.1 and 1.2 Specifications.

Insert Values in ListObjects using Row/Column Offset

Normally, you add values inside the ListObject/Table using the Cell.putValue method, however, the putValue method must be associated with an instance of a Cell to identify the correct location where value has to be inserted. This mechanism is not usable when you need to add values inside the ListObject using the row and column offsets. Aspose.Cells for Java 8.3.1 has exposed the methods Cell.getTable & ListObject.putCellValue methods to facilitate the users in Accessing the ListObject from a Cell and Add Values using the Row and Column Offsets.

The following sample code loads the source spreadsheet, and adds values inside the table.

//Create workbook from source Excel file
Workbook workbook = new Workbook("source.xlsx");

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

//Access cell D5 which lies inside the table
Cell cell = worksheet.getCells().get("D5");

//Put value inside the cell D5
cell.putValue("D5 Data");

//Access the Table from this cell
ListObject table = cell.getTable();

//Add some value using Row and Column Offset
table.putCellValue(2, 2, "Offset [2,2]");

//Save the workbook
workbook.save("output.xlsx");

Create Sparkline by Specifying Data Range and Location

Aspose.Cells APIs have exposed the SparklineCollection.add(String dataRange, int row, int column) method to Specify the Data Range and Location of Sparkline Group. Please note, Excel provides the same feature through following steps.

  1. Select the cell containing your Sparkline.
  2. Select Edit Data from the Sparkline section inside the Design tab.
  3. Choose Edit Group Location & Data.
  4. Specify Data Range & Location.

You may achieve the same as discussed above while using the following code snippet.

//Create workbook from source Excel file
Workbook workbook = new Workbook("source.xlsx");

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

//Access the first sparkline group
SparklineGroup group = worksheet.getSparklineGroupCollection().get(0);

//Add Data Ranges and Locations inside this sparkline group
group.getSparklineCollection().add("D5:O5", 4, 15);
group.getSparklineCollection().add("D6:O6", 5, 15);
group.getSparklineCollection().add("D7:O7", 6, 15);
group.getSparklineCollection().add("D8:O8", 7, 15);

//Save the workbook
workbook.save("output.xlsx");

Other Enhancements & Improvements

The most notable  enhancements in this release are as follow:

  • Improved the Sparkline rendering.
  • Improved the Chart rendering mechanism to address the misalignment of legend entries.
  • Tweaked the rendering engine to generate PDF that are now much closer to how Excel does.

Please visit the documentation for details, and if you still have any questions, we always welcome inquiries on Aspose.Cells Support Forum.

Posted in Aspose for Java APIs, Aspose.Cells Product Family, Babar Raza | Leave a comment

Support for ODF 1.2, Show Cell Ranges as Data Labels and Insert Values in ListObjects using Offset with Aspose.Cells for .NET 8.3.1

aspose Cells for net 100 Support for ODF 1.2, Show Cell Ranges as Data Labels and Insert Values in ListObjects using Offset with Aspose.Cells for .NET 8.3.1Aspose.Cells for .NET 8.3.1 has been released. This release contains a few useful features and a number of other enhancements. It contains over 40 improvements, including the new features listed below. It also includes the long awaited support for ODF 1.2 specifications. If you are planning to upgrade the API from a previous release, we suggest you to check documents in the Public API Changes section.

Save ODS file in ODF 1.1 and 1.2 Specifications

The Aspose.Cells APIs have extended support for the OpenDocument format. Now it is possible to save the ODS (OpenDocument Spreadsheets) in conformance with the ODF 1.2 specifications. The Aspose.Cells APIs have exposed the methods IsStrictSchema11 for the OdsSaveOptions class to allow developers to save spreadsheets in ODS format conforming to ODF 1.2 specification. The default value of IsStrictSchema11 property is false, and means that from version 8.3.1 of the Aspose.Cells APIs, the ODS files will be saved as ODF format version 1.2 by default. For more details, please check the article Save ODS file in ODF 1.1 and 1.2 Specifications.

Insert Values in ListObjects using Row/Column Offset

Normally, you add values inside the ListObject/Table using the Cell.PutValue method, however, the PutValue method must be associated with an instance of a cell to identify the location the value should be inserted at. This mechanism can’t be sued when you need to add values inside the ListObject using the row and column offsets. Aspose.Cells for .NET 8.3.1 has exposed the Cell.GetTable and ListObject.PutCellValue methods to allow you to access the ListObject from a cell and add values using row and column offsets.

The following sample code loads the source spreadsheet, and adds values inside the table.

//Create workbook from source Excel file
Workbook workbook = new Workbook("source.xlsx");

//Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];

//Access cell D5 which lies inside the table
Cell cell = worksheet.Cells["D5"];

//Put value inside the cell D5
cell.PutValue("D5 Data");

//Access the Table from this cell
ListObject table = cell.GetTable();

//Add some value using Row and Column Offset
table.PutCellValue(2, 2, "Offset [2,2]");

//Save the workbook
workbook.Save("output.xlsx");

Show Cell Ranges as Data Labels

Aspose.Cells provides the DataLabels.ShowCellRange property to select or clear the option Label Contains – Value From Cells. For more details, please see the article Showing Cell Range as the Data Labels.

Create Sparkline by Specifying Data Range and Location

Aspose.Cells APIs have exposed the SparklineCollection.Add(String dataRange, int row, int column) method to specify the data range and location of the sparkline group.

You may achieve the same as discussed above while using the following code snippet.

//Create workbook from source Excel file
Workbook workbook = new Workbook("source.xlsx");

//Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];

//Access the first sparkline group
SparklineGroup group = worksheet.SparklineGroupCollection[0];

//Add Data Ranges and Locations inside this sparkline group
group.SparklineCollection.Add("D5:O5", 4, 15);
group.SparklineCollection.Add("D6:O6", 5, 15);
group.SparklineCollection.Add("D7:O7", 6, 15);
group.SparklineCollection.Add("D8:O8", 7, 15);

//Save the workbook
workbook.Save("output.xlsx");

Other Enhancements and Fixes

In the new version, we have also provided the following new enhancements:

  • Specify a prefix for image URLs in CSS and HTML files.
  • Get/set Cell background color in Cell.HtmlString attribute.
  • Retrieve Cell.DisplayStringValue with conditional formatting.

We have fixed a few exceptions that occurred while loading and opening Microsoft Excel file formats. We have also fixed the exceptions that occurred in manipulating shapes, rendering sheets, calculating formulas and manipulating pivot tables. We have also improved the performance when loading Microsoft Excel files.

In this release, several important issues have been addressed. For example, issues around reading/writing Microsoft Excel file formats, printing spreadsheets, rendering HTML file format, manipulating OLE Objects, copying worksheets, manipulating shapes, manipulating rows and columns, rendering images from Excel worksheets, manipulating charts with formatting, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have also fixed some issues regarding the Aspose.Cells formula calculation engine to enhance it.

We have also fixed a few issues in the web based Grid control by Aspose.Cells for .NET while loading/saving an Excel file.

To see a complete list of enhancements and fixes, and to download Aspose.Cells for .NET 8.3.1, please visit the download page.

Posted in Aspose for .NET APIs, Aspose.Cells Product Family | Leave a comment

Export Drupal Contents to PDF Document using Aspose.Pdf for Cloud

drupal logo big Export Drupal Contents to PDF Document using Aspose.Pdf for CloudDrupal is a free, open-source web development platform for online content and user communities. Drupal powers some of the busiest sites on the web, and can be adapted to virtually any visual design. Drupal runs over a million sites, including WhiteHouse.gov, World Economic Forum, Stanford University, and Examiner.com. It’s built, used, and supported by an active and diverse community of people around the world.

Cloud PDF Import Export Drupal Contents to PDF Document using Aspose.Pdf for CloudAspose PDF Exporter Module for Drupal allows administrators to export article contents to a PDF document. This module demonstrates the powerful export feature Aspose.Pdf provides. It adds a simple update option: Aspose Export to PDF to the Drupal interface. When the bulk action is called, it exports all articles to an Adobe Acrobat PDF document.

 

Installing the Aspose PDF Exporter Module

You can download the Aspose PDF Exporter Module from one of the following locations:

Once downloaded, please follow these steps to install the module to your Drupal website:

  1. Extract the files. When you first get the module, it will appear in a compressed file format, either tar.gz or .zip. On Windows, use a program like 7-zip to extract it.
  2. Upload the folder. Using SFTP (file transfer protocol) or Git (version control), upload your files to the “sites/all/modules” folder in your Drupal installation.
  3. Enable the module. Navigate to Administer, then Site building and finally Modules. Check the Enabled option next to the Aspose PDF Exporter module and click the Save Configuration button at the bottom.
  4. Include Aspose Keys. Click on the configure button next to the Aspose PDF Exporter module and then add APP SID & APP KEY. For further details on how to get app keys, click here.

Using Aspose PDF Exporter Module

After you have installed Aspose PDF Exporter Plugin it is really simple to start using it on your website. Please follow these steps to get started.

  1. Make sure you are logged-in to a Drupal site as Admin level account.
  2. Make sure you have set up Aspose App Key & Id on the module configuration page. For further details on how to get app keys, click here.
  3. Navigate to the Content Page.
  4. Select  the articles or pages you want to export and then select Aspose Export to PDF from Update Options.
  5. Click Update.
    This will export all selected articles or pages to a PDF document file and gives you link for downloading the PDF file.
Posted in Aspose SDKs, Aspose.Pdf Product Family, Aspose.Total Product Family | Leave a comment

Revamped Aspose.Tasks API – Coming Soon!

Aspose.Tasks (.NET and Java) APIs have been in the field for quite a long time now and provide a rich set of project documents manipulating functionality such as:

  • Creating and saving new documents in Microsoft Project (MSP) XML format.
  • Writing updated data back to MPP format.
  • Adding tasks, resources and resource assignments.
  • Calculating critical path.
  • Rendering project data to various formats such as BMP, PNG, HTML, PDF, etc.

These are just a few of the supported features. Though Aspose.Tasks’ present implementation provides an easy to use API functionality,  we see areas where the API can be improved in terms of  usage. This has lead us to introduce a revamped version of Aspose.Tasks API.

We are currently in the development phase of the revamped version of Aspose.Tasks. A few of the key features of this new version are:

Calculation modes: The new API will provide manual as well as automatic recalculation modes similar to Microsoft Project (MSP). Manual mode will calculate only the necessary fields whereas automatic mode will recalculate everything.  This will eliminate the need to calling the recalculating methods manually and improve ease of use.

Provision of Get/Set methods: The new API provides general Get and Set methods for the Project, Task, Resource and Assignment classes. These methods will perform all calculations and free developers from worrying about performing recalculations. Moreover, the introduction of these methods will limit the quantity of publicly available properties and make the API easier to use.

These are few key features that will be part of the Aspose.Tasks’ revamped version. We’ll be sharing more improvements with time to time for keeping you updated. In case of any inquiry in this regard, please feel free to contact us over Aspose.Tasks forum.

Posted in Aspose for .NET APIs, Aspose for Java APIs, Aspose.Tasks Product Family | Leave a comment

Justify Text in Local Mode with ReportViewer 2010 with Aspose.Pdf for Reporting Services 3.0.0

aspose Pdf for SSRS e1389176637706 Justify Text in Local Mode with ReportViewer 2010 with Aspose.Pdf for Reporting Services 3.0.0We are very much excited to announce a maintenance release of Aspose.Pdf for Reporting Services 3.0.0 which provides fixes for issues reported in earlier release versions. Text justification is one of the features provided by Aspose.Pdf for Reporting Services which is not supported by of Microsoft Report Viewer or Report Server’s default PDF rendering feature. With the addition of a simple custom feature either in a particular report or by defining a configuration on the Report server, you can output text with justified or fully justified alignment when rendering reports to PDF or XPS format. In this new release, we have particularly fixed the text alignment feature when rendering a report in local mode using Microsoft Report Viewer 2010.

Please get the download and start exploring the exciting new release of Aspose.Pdf for Reporting Services 3.0.0.

Posted in Aspose.Pdf Product Family, Nayyer Shahbaz, Reporting Services Extensions | Leave a comment

Create, Edit and Convert PDF files with Aspose for Cloud iOS SDK

Aspose.Pdf for Cloud

aspose pdf for CloudAPIs 100 Create, Edit and Convert PDF files with Aspose for Cloud iOS SDKAspose.Pdf for Cloud is a REST API for creating and editing PDF files. It can also be used to convert PDF files to different formats like DOC, HTML, XPS, TIFF and many more. Aspose.Pdf for Cloud gives you control: create PDFs from scratch or from HTML, XML, template, database, XPS or an image. Render PDFs to image formats such as JPEG, PNG, GIF, BMP, TIFF and many others. Aspose.Pdf for Cloud helps you manipulate elements of a PDF file like text, annotations, watermarks, signatures, bookmarks, stamps and so on. Its REST API also allows you to manage PDF pages by using features like merging, splitting, and inserting.

Working with Aspose.Pdf

  1. To integrate Aspose Cloud SDK into your iOS project, please read Getting Started with the Aspose for Cloud iOS SDK
  2. Sign up with Aspose Cloud service at: https://cloud.aspose.com/SignUp
  3. Create a new App and get your App SID and App Key.
  4. Call setAppKey:andAppSID: class method of AsposeApp with your App SID and App Key as an arguments to this method.
  5. Set the base product URI to http://api.aspose.com/v1.1 by calling setBaseProductUri: class method of Product.
  6. appkeyandsid Create, Edit and Convert PDF files with Aspose for Cloud iOS SDK

  7. Import AsposeAPIs.h header file in your class.
  8. Now you are ready to work with Aspose.PDF APIs.
  9. Please go through this Programmers Guide, and with Aspose.PDF package in Aspose for Cloud iOS SDK you can access all these APIs with just one line of code.

Unit Tests for Aspose.Pdf

To help you get started we also provided unit test coverage to Aspose.Pdf’s APIs.

Start a Free Trial Today

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

Customer Feedback

Your feedback is very important to us. Please feel free to provide feedback and raise feature requirements. We are keen to implement customer driven features since we are a 100% customer driven company.

Posted in Aspose SDKs, Aspose for Cloud APIs | Leave a comment

Convert DWG to PDF, Recover TIFF Data, Dithering & Extensive Support for JPEG Format with Aspose.Imaging for Java 2.4.0

aspose Imaging for Java e1378110009543 Convert DWG to PDF, Recover TIFF Data, Dithering & Extensive Support for JPEG Format with Aspose.Imaging for Java 2.4.0Aspose.Imaging for Java 2.4.0 has been released and we are pleased to announce that this release contains many useful improvements, including the long awaited feature of AutoCAD DWG Drawings to PDF conversion. Please refer to the release notes of Aspose.Imaging for Java 2.4.0 for a full list of bug fixes and improvements. If you are planning to upgrade the API from any previous version, we would suggest you to check the Public API Changes section first.

While you are downloading the latest build, here is a look at the biggest features in this release.

DWG Drawings to PDF Conversion

With the release of 2.4.0, Aspose.Imaging for Java supports loading DWG files for conversion to PDF format. Currently we support reading AutoCAD 2004 DWG (version 16.0 Release 18) format only. We will add more DWG revisions with future releases of Aspose.Imaging APIs whereas the support for DWG 2005 and 2010 are on the top of our priority list.

DWG to PDF conversion uses the PdfOptions class to specify the resultant PDF page size, and additional settings such as which Layout to render, BackgroundColor, DrawType and ScaleMethod. These properties have to be set before calling the Image.Save method for converting DWG to PDF format. Please read more about Customizing CAD to PDF Conversion.

Data Recovery for TIFF Image Format

The TIFF file format stores data in strips. When a few strips are damaged, other strips may still retain the correct information, therefore it is possible to recover the correct data strips by filling the damaged strips with a background color. The data recovery module offered by Aspose.Imaging allows the user to retrieve the correct data portions (strips) in a similar fashion. In order to assist the users, Aspose.Imaging provides two data recovery modes, ConsistentRecover and MaximalRecover, which provide different results depending on the user’s data recovery needs.

Dithering Support for the RasterImage Class

Aspose.Imaging provides dithering support for the RasterImage class by introducing the DitheringSettings property. The DitheringMode class, now available in the com.aspose.imaging.dithering package, specifies the dithering to be applied. The dithering feature needs to implicitly or explicitly call the RasterImage.LoadPixels method after the RasterImage.DitheringSettings have been specified. Please check the complete detailed article on the link shared above.

Raw Data Processing

Another exciting feature that is now available for public use is Raw Data Processing. Prior to 2.4.0, Aspose.Imaging used Color[] to internally store data. This approach had issues. First of all, an array of structs affected the performance during copy operations. Secondly, the Color struct required more memory for data storage because the API had to store additional system information together with 4 bytes of data.

With this release, we have partially switched the internal structure to use byte[] instead Color[] in order to assist developers in getting the best performance out of Aspose.Imaging API. At the moment this system has been introduced for BMP file format only, but soon all other image formats will be supported too.

Add Thumbnails to EXIF & JFIF Segments of JPEG Images

Aspose.Imaging has exposed additional properties to add thumbnails to EXIF and JFIF data segments of JPEG images. Both types of segments can store only 65,535 bytes of data including the thumbnail image according to the JPEG specifications, therefore Aspose.Imaging API will throw appropriate exception in case the added image is bigger than the specified limit.

Support for Image Cropping

Aspose.Imaging now provides the long awaited feature of image cropping for the RasterImage class by introducing the crop method. There are two overload versions of thecrop method available based on two different approaches as discussed below,

  • Shift Mode: One of the overloads accepts 4 integer parameters denotes as Left, Right, Top and Bottom. Based on these values, the Crop method shrinks the image boundaries toward the center of the image while discarding everything outside the boundaries.
  • Rectangle Mode: As the name suggests, this mechanism can be used to highlight a particular area by cutting it out of the image. The area should be defined using an instance of the Rectangle class and passed to the other overload of the crop method.

As always we appreciate your feedback so if you ever have anything to tell us about this release or anything else, please head to the Aspose.Imaging forum for a chat.

Posted in Aspose for Java APIs, Aspose.Imaging Product Family, Babar Raza | Leave a comment