Get Table Alignment Add Remove Comment Reply by using Aspose.Words for Android via Xamarin 17.10

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

Aspose.Words for Android via Xamarin

We are pleased to announce the new monthly release of Aspose.Words for Android via Xamarin 17.10′. Aspose.Words for Android via Xamarin’ has full functionality of Aspose.Words for .NET 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 .NET 17.10, see following release notes for more information.

Except fixes and improvements from Aspose.Words for .NET, the following improvements have been made in this Aspose.Words for Android via Xamarin release:

  • TIFF image reading is implemented
  • Path gradient rendering is now supported.

You can now perform the following tasks by using Aspose.Words for Android via Xamarin 17.10:

‘Aspose.Words for Android via Xamarin’ is an advanced Word document processing API to perform a wide range of document processing tasks directly within your native Android applications. You can integrate this API through Xamarin framework for Android applications. ‘Aspose.Words for Android via Xamarin’ 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 Xamarin

‘Aspose.Words for Android via Xamarin’ 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 Xamarin’ 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 Xamarin’ (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 Xamarin’ 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

Filtering Appointments from Exchange with Aspose.Email for Android via Xamarin

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

aspose_email-for-android-via-xamarin-1-150x150We are pleased to announce the release of Aspose.Email for Android via Xamarin 17.10. This month’s release, ported from Aspose.Email for .NET 17.10, includes the same features and bug fixes. These improve the overall stability of the API for working with Xamarin framework. Details about new features and improvements are available in the release notes section of API documentation.

Improvements in Aspose.Email for Android via Xamarin 17.10

 This release includes several improvements in terms of features and bug fixes that makes the API functionality more stable and feature-rich. Android application developers can use this latest version of the API to provide rich emailing functionality in their applications. Improvements and features included in this month’s release are as follow:

  • Support for Filtering Appointments from Exchange Server: This release supports filtering appointments from Exchange Server using the API’s IEWSClient. Appointments can be filtered based on date or recurrence information from the server.
  • Attachment name encoding issues have been fixed
  • EWS client of the API has been enhanced to handle mailboxes containing large number of messages
  • Issues with MapiMessage API have been fixed, resulting in correct retrieval of message body information
  • Certain issues with PST files have been fixed that were losing properties of Calendar items upon merging
  • The API’s IMAP client has been enhanced to work with Yahoo mail for listing folders. This feature was broken due to some changes in the API client.
  • Issues with calendar items in terms of all day events have been fixed
  • EMLx to EML conversion has been improved

API Resources

Aspose.Email for Android via Xamarin’s documentation section is your one stop for learning all about the API. You can visit the documentation page of the API to know more about the API. For any of your queries, feel free to write to us over Aspose.Email forum.

Posted in Aspose.Email Product Family | Leave a comment

First Version of Aspose.Words for Mac via Xamarin Targeting Xamarin.Mac Framework Released

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

We are pleased to announce the first release of Aspose.Words for Mac via Xamarin (17.10).  In future, regular monthly releases will be published. ‘Aspose.Words for Mac via Xamarin’ has full functionality of Aspose.Words for .NET 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 .NET 17.10, see following release notes for more information.

Aspose.Words for .NET 17.10 release notes
Aspose.Words for Mac via Xamarin 17.10 release notes

Aspose.Words for Mac via Xamarin is an advanced Word document processing API to perform a wide range of document processing tasks directly within your native Mac applications. You can integrate this API through Xamarin framework for Mac applications. Aspose.Words for Mac via Xamarin 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 Mac via Xamarin

Aspose.Words for Mac via Xamarin 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 Mac via Xamarin’ API for evaluation. The evaluation download is the same as the purchased download. Please check How to License Aspose.Words for Mac via Xamarin.

The evaluation version of Aspose.Words for Mac via Xamarin (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 Mac via Xamarin’ 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

Filtering Appointments from Exchange Server with Aspose.Email for Java

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

aspose-email-for-javaAspose.Email for Java 17.10 has been released. Ported from its equivalent .NET version, this month’s release includes enhancement of filtering appointments from Exchange Server using EWS client of the API. It also includes several bug fixes which further improve the overall API functionality. For a detailed note on what is new and fixed, please visit the release notes section of Aspose.Email for Java 17.10.

Filtering Appointments from Exchange Server using EWS

This release of Aspose.Email for Java introduces the capability of filtering appointments from Exchange Sever using its IEWSClient. Appointments can be filtered from Exchange server using the IEWSClient of the API with the help of ExchangeQueryBuilder. Appointments can be filtered from server by:

  • Date
  • Recurrence

The following code snippets show filtering appointments from Exchange server using this new feature.

Filtering Appointments by Date

IEWSClient client = EWSClient.getEWSClient(mailboxUri, username, password, domain);

SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
		
ExchangeQueryBuilder builder = new ExchangeQueryBuilder();
builder.getAppointment().getStart().since(sdf.parse("10/05/2016 10:00:00"));
builder.getAppointment().getEnd().beforeOrEqual(sdf.parse("10/15/2016 10:00:00"));
MailQuery query = builder.getQuery();
Appointment[] appointments = client.listAppointments(query);

Filtering Appointments by Recurrence

builder = new ExchangeQueryBuilder();
builder.getAppointment().isRecurring().equals(false);
MailQuery query = builder.getQuery();
Appointment[]appointments = client.listAppointments(query);

Other Improvements

This month’s release also includes several bug fixes that further add to the overall stability of the API. In addition, since the API is ported from its equivalent .NET version, it also includes all those fixes which were part of the .NET version. Detailed information about the fixes can be found in the release notes section of the API documentation.

API Resources

We have detailed information available online for getting started with the Aspose.Email for Java API. These are:

Posted in Aspose.Email Product Family | Leave a comment

Support of One Bit Pixel Image Add Remove Comment Reply Footnote Layout Columns and Use Machine Fonts in HtmlFixed

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

Aspose.Words for .NET logoWe are pleased to announce our next version Aspose.Words for .NET 17.10. This month’s release contains over 76 useful new features, enhancements and bug fixes. Please see the release notes for more detail. If you are planning to upgrade from older version of Aspose.Words to the current version, we would strongly suggest you to check the Public API and Backward Incompatible Changes section to know what APIs are changed so far.


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

  • “Don’t add extra space for raised/lowered characters” compatibility option is supported.
  • Multiple improvements in RTL and Asian text handling.
  • LINQ Reporting Engine supports dynamic chart series removal.
  • ‘Black and white’ images with one bit per pixel format rendering implemented. PixelFormat.Format1bppIndexed was introduced.
  • An option to prevent the fonts embedding into HTML Fixed output implemented. Introduced HtmlFixedSaveOptions.UseTargetMachineFonts property.
  • Rendering of HTML fixed documents with “PRC” encoding fonts has been improved.
  • An algorithm, which mimics the behavior of MS Word when rendering of rotated VML shapes with text boxes.
  • Rendering of “Surface” and “Stock” DrawingML Charts has been improved.
  • Added CompareOptions.Target property and enumeration ComparisonTargetType.
  • Added public methods to add and remove replies to comment.
  • Ability to get and set the number of footnote layout columns.
  • Provide API similar to SignatureSet.AddSignatureLine Method (Office).
  • Expose Table.HorizontalAlignment property public.

Added Public Property CompareOptions.Target and Enumeration ComparisonTargetType

A new feature has been added in this release to use the base document during comparison of documents. This feature is related to Microsoft Word “Show changes in” option in “Compare Documents” dialog box. We have added Public property CompareOptions.Target to the CompareOptions class to provide ability to determine base document upon documents comparison. Please read following article for more detail.
Set Target Document for Comparison Differences

/// <summary>
/// Specifies which document shall be used as a target during comparison.
/// </summary>
public ComparisonTargetType Target
{
  get { return mTargetType; }
  set { mTargetType = value; }
}
/// <summary>
/// Allows to specify base document which will be used during comparison.  
/// Default value is <see cref="Current" />. /// </summary> /// <remarks> /// Relates to Microsoft Word "Show changes in" option in "Compare Documents" dialog box. /// </remarks> public enum ComparisonTargetType { /// <summary> /// This document is used as a base during comparison. /// </summary> Current, /// <summary> /// Other document is used as a base during comparison. /// </summary> New }

LINQ Reporting Engine Supports Dynamic Chart Series Removal

We have added a new feature in LINQ Reporting Engine to remove chart series dynamically. In particular, this feature is useful when you need to restrict access to sensitive data in chart series for some users of your application. Please read more detail from here.
Using Charts to Represent Sequential Data

Added Feature to Add and Remove Comment Reply

We have added public methods Comment.AddReply and Comment.RemoveReply in this version of Aspose.Words to add and remove comment’s reply. Please refer to the following article for more detail. 
How to Add and Remove Comment’s Reply

/// <summary>
/// Adds a reply to this comment.
/// </summary>
/// <param name="author">The author name for the reply.</param>
/// <param name="initial">The author initials for the reply.</param>
/// <param name="dateTime">The date and time for the reply.</param>
/// <param name="text">The reply text.</param>
/// <returns>The created <see cref="Comment"/> node for the reply.</returns>
/// <remarks>
/// Due to the existing MS Office limitations only 1 level of replies is allowed in the document.
/// An exception of type <see cref="InvalidOperationException"/> will be raised if this method is
/// called on the existing Reply comment.
/// </remarks>
public Comment AddReply(string author, string initial, DateTime dateTime, string text);
 
/// <summary>
/// Removes the specified reply to this comment.
/// </summary>
/// <param name="reply">The comment node of the deleting reply.</param>
/// <remarks>All constituent nodes of the reply will be deleted from the document.</remarks>
public void RemoveReply(Comment reply);
 
/// <summary>
/// Removes all replies to this comment.
/// </summary>
/// <remarks>All constituent nodes of the replies will be deleted from the document.</remarks>
public void RemoveAllReplies();

Added Feature to Save Black and White Image with One Bit Per Pixel Format

A new enumeration value Format1bppIndexed has been added to ImagePixelFormat for ImageSaveOptions.PixelFormat property. Previously setting ImageSaveOptions.ImageColorMode as BlackAndWhite would produce black and white image but with more than one bit per pixel format. For now black and white image with one bit per pixel format could be produced using Aspose.Words 17.10. Please read following article for detail.
Save Black and White Image with One Bit Per Pixel Format

Added Feature to Get and Set Number of Footnote Layout Columns

We have added public property FootnoteOptions.Columns to set or get the number of columns with which the footnotes area is formatted. Please read following article for more detail.
Working with Footnote and Endnote

/// <summary>
/// Specifies the number of columns with which the footnotes area is formatted.
/// </summary>
/// <remarks>
/// If this property has the value of 0, the footnotes area is formatted with a 
/// number of columns based on the number of columns on the displayed page.
/// The default value is 0. /// </remarks> public int Columns { get; set; }

The Document.EndnoteOptions and PageSetup.EndnoteOptions properties have been changed to be of the EndnoteOptions type. This new EndnoteOptions class has the same properties as FootnoteOptions except the Columns property:

/// <summary>
/// Represents the endnote numbering options for a document or section.
/// </summary>
public class EndnoteOptions
{
    /// <summary>
    /// Specifies the endnotes position.
    /// </summary>
    public EndnotePosition Position { get; set; }
 
    /// <summary>
    /// Specifies the number format for automatically numbered endnotes.
    /// </summary>
    public NumberStyle NumberStyle { get; set; }
 
    /// <summary>
    /// Specifies the starting number or character for the first automatically numbered endnotes.
    /// </summary>
    public int StartNumber { get; set; }
 
    /// <summary>
    /// Determines when automatic numbering restarts.
    /// </summary>
    public FootnoteNumberingRule RestartRule { get; set; }
}

The similar Position property of the FootnotePosition type is added into the FootnoteOptions class. The property should be used instead of the obsolete Location property. The new public enum types FootnotePosition and EndnotePosition have the following items:

/// <summary>
/// Defines the footnote position.
/// </summary>
public enum FootnotePosition
{
    /// <summary>
    /// Footnotes are output at the bottom of each page.
    /// </summary>
    BottomOfPage = 1,
 
    /// <summary>
    /// Footnotes are output beneath text on each page.
    /// </summary>
    BeneathText = 2
}
 
/// <summary>
/// Defines the endnote position.
/// </summary>
public enum EndnotePosition
{
    /// <summary>
    /// Endnotes are output at the end of the section.
    /// </summary>
    EndOfSection = 0,
 
    /// <summary>
    /// Endnotes are output at the end of the document.
    /// </summary>
    EndOfDocument = 3
}

Added Feature to Sign Word document using Signature Provider Identifier

We have Added public properties SignOptions.ProviderId and SignatureLine.ProviderId in this version of Aspose.Words to sign Word document using signature provider identifier. Please refer to the following articles.
Signing Word Document using Signature Provider Identifier
Create New Signature Line Sign Word Document using Provider Identifier

Added Feature to Get to Relative Alignment of Table

A new feature has been added in this release to get the table’s alignment. You can get the relative table’s alignment using Table.RelativeHorizontalAlignment and Table.RelativeVerticalAlignment properties when its text wrapping is “Around”. Please read following article for more detail.
How to Get the Table Alignment

// Gets table relative horizontal alignment.
public HorizontalAlignment RelativeHorizontalAlignment
 
// Gets table relative vertical alignment.
public VerticalAlignment RelativeVerticalAlignment

Prevent Embedding Fonts while Saving into HTML Fixed Format

We have introduced HtmlFixedSaveOptions.UseTargetMachineFonts property to use fonts from target machine when document is saved to HtmlFixed. For more detail, please check following link. 
Prevent Embedding Fonts while saving Document into HtmlFixed


/// <summary>
/// Flag indicates whether fonts from target machine must be used to display the document.
/// If this flag is set to true, <see cref="FontFormat"/> and <see cref="ExportEmbeddedFonts"/> properties do not have effect,
/// also <see cref="ResourceSavingCallback"/> is not fired for fonts.
/// Default is false.
/// </summary>
public bool UseTargetMachineFonts

Aspose.Words for .NET Resources

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

  • Home page of .NET API.
  • Download Section.
  • Install using NuGet Package
  • Documentation – up-to-date documentation containing Programmer’s Guide, Knowledge Base and much more.
  • API Reference Guide – detailing the publicly exposed classes, methods, properties, constants & interfaces.
  • Aspose.Words Product Family Forum – post your technical questions and queries, or any other problem you are facing while working with Aspose.Words APIs.
  • Enable Blog Subscription – do not limit yourself, you can keep yourself updated with the latest news on Aspose.Words APIs, new features, fixes and other API related topics by subscribing to Aspose.Words blog.
  • Examples – we have published our code examples on the social coding website GitHub.com. Anyone could explore the code examples for learning purposes.
Posted in Aspose.Words Product Family | Leave a comment

Support for OTP format and improved shapes formatting in Aspose.Slides for Cloud

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

Aspose.Slides for Cloud logoWe are pleased to announce the release of Aspose.Slides for Cloud 17.9.

This release has been built on the basis of latest Aspose.Slides for .NET 17.9 API. Aspose.Slides for .NET 17.9 is enriched with some new features including support for exporting slide notes in generated HTML. We have included some new features in Aspose.Slides for Cloud as well. Please check Aspose.Slides for Cloud 17.9 Release Notes for summarized information about all changes in this release.

Features and Enhancements

  • Support for OTP template

  • EffectFormat property support to Shape & Background resources

  • Implement Slide resizing

  • Use Aspose.Slides for .NET 17.9 features

  • Add Reset task to the Pipeline resource

  • Add ShowMasterShapes property to slide resource

  • Implement InvertedSolidFillColor for Chart Series

  • Aspose.Slides fails on loading large files

  • Can’t retrieve Korean text items

Aspose for Cloud Resources

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

Posted in Aspose.Slides Product Family | Leave a comment

Improved Rendering of Word Document to PDF in Aspose.Words for Cloud 17.9

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

Aspose.Words for Cloud is platform independent document manipulation REST API, that can be used with any language. We are pleased to announce release of Aspose.Words for Cloud 17.9. This release is a maintenance release with a number of bug fixes and improved functionality.

This month’s release includes a number of fixes to issues reported by our users in addition to our internal efforts for functionality improvement of our REST API. The core library of Aspose.Words for Cloud has also been updated to Aspose.Words for .NET 17.9. Please check release notes of Aspose.Words for Cloud 17.9 for complete list of bug fixes.

Improvements

There are 6 improvements and fixes in this regular monthly release

WORDSCLOUD-238: System.IndexOutOfRangeException is thrown while converting DOCX to PDF

WORDSCLOUD-239: DOCX to PDF conversion issue with Chart’s color

WORDSCLOUD-242: Index field is duplicated in Swagger

WORDSCLOUD-244: Make nodePath parameter mandatory for borders

WORDSCLOUD-252: PUT formfields does not add form field

WORDSCLOUD-253: PUT Create method creates DOCX documents as DOC

Aspose for Cloud Resources

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

Aspose.Words for Cloud

Aspose.Words for Cloud Online Documentation

Aspose for Cloud UI Help Topics

Aspose.Words Forum

Live Examples

Aspose for Cloud SDKs

Aspose for Cloud Plugins

Work with Aspose for Cloud Storage using Web GUI or Aspose for Cloud Service

Work with Third Party Storages

Work with API Usage and Logs using Web GUI or Aspose for Cloud Service

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.Words Product Family | Leave a comment

Filtering Appointments using EWS with Aspose.Email for .NET 17.10

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

aspose-email-for-.NETWe are pleased to announce the release of Aspose.Email for .NET 17.10. This release includes enhancement for filtering appointments from Exchange server using Exchange Web Service (EWS) client of the API. It also includes improvements in terms of bug fixes which further add to the overall functionality of the API. For a detailed note on what is new and fixed, please visit the release notes section of API documentation.

Enhancements in Aspose.Email for .NET 17.10

Filtering Appointments using EWS Client: The EWS client of the API already provides the capability of filtering messages from Exchange server. This month’s release further enhances the functionality of searching items on Exchange server. You can now filter appointments from Exchange server mailbox based on:

  • Date and Time
  • Recurrence

The ExchangeQueryBuilder class is the user interface in this case. The following code samples show filtering appointments from Exchange server using IEWSClient of the API.

Filtering Appointments by Date Time

IEWSClient client = EWSClient.GetEWSClient(mailboxUri, username, password, domain);
DateTime startTime = new DateTime(2017,09, 15);
DateTime endTime = new DateTime(2017, 10, 10);
ExchangeQueryBuilder builder = new ExchangeQueryBuilder();
builder.Appointment.Start.Since(startTime);
builder.Appointment.End.BeforeOrEqual(endTime);
MailQuery query = builder.GetQuery();
Appointment[] appointments = client.ListAppointments(query);

Filtering Appointments by Recurrence

builder = new ExchangeQueryBuilder();
builder.Appointment.IsRecurring.Equals(false);
query = builder.GetQuery();
appointments = client.ListAppointments(query);

Other Improvements

In addition to enhancement mentioned above, this month’s release also includes several bug fixes that add to the overall stability of the API in terms of expected output. Details about the fixed issues can be found in the release notes section of the API.

API Resources

The following API resources can be of help to you in getting started with Aspose.Email API.

Posted in Aspose.Email Product Family | Leave a comment

Tile picture as a Texture inside shapes and set default font when rendering to PDF or image file with other enhancements in Aspose.Cells for Android via Java 17.9

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.9. This release includes a number of new features, enhancements and several bug fixes that further improve the overall stability and usability of the API. 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.

Tile Picture as a Texture inside the Shape

Aspose.Cells supports image tiling feature which allows you to display images that are too large to be displayed entirely as a single unit on a typical computer. The feature allows you to display by segmenting it into smaller, more manageable image tiles.

//Load sample Excel file
Workbook wb = new Workbook(dirPath + "e:\\test2\\Book1.xlsx");

//Access first worksheet
Worksheet ws = wb.getWorksheets().get(0);
  
//Access first shape inside the worksheet
Shape sh = ws.getShapes().get(0);
  
//Tile Picture as a Texture inside the Shape 
sh.getFill().getTextureFill().setTiling(true);

//Save the output Excel file
wb.save(dirPath + "e:\\test2\\out1.xlsx");

Please see this article that explains how to Tile Picture as a Texture inside the Shape.

Using Formula parameter in Smart Marker field

Sometimes, you need to embed formula in Smart Markers. Aspose.Cells allows you to make use of Formula parameter in Smart marker field. For more detail, please see this article.

Apply Advanced Filter of Microsoft Excel to Display Records Meeting Complex Criteria

Microsoft Excel allows you to apply Advanced Filter on worksheet data to display records that meet complex criteria. You can apply Advanced Filter with Microsoft Excel via its Data > Advanced command as shown in this screenshot.

Aspose.Cells also allows you to apply the Advanced Filter using the Worksheet.advancedFilter() method. For more detail, please see this article.

Import Data from Microsoft Access Database ResultSet Object to the Worksheet

Aspose.Cells can import data to worksheet from ResultSet object which can be created from any database. However, the following article specifically creates ResultSet object from Microsoft Access Database. Since, the code is same for all types of databases, so you can use it in general.

Implement Errors and Boolean Value in Russian or Any Other Language

If you are using Microsoft Excel in Russian Locale or Language or any other Locale or Language, it will display Errors and Boolean values according to that Locale or Language. You can achieve the similar behavior of Microsoft Excel using Aspose.Cells with the GlobalizationSettings class. Please see the following article for more help.

Read Numbers Spreadsheet Developed by Apple Inc. using Aspose.Cells

Numbers is a spreadsheet application developed by Apple Inc. Aspose.Cells can read Numbers spreadsheet but it does not support writing to it. It can read Numbers spreadsheet’s Data, Style and Formulas. Here is the article link for more detail.

Set DefaultFont property of PdfSaveOptions and ImageOrPrintOptions

When saving to PDF or image, Aspose.Cells will first try to use Workbook’s default font. This behavior can be changed using DefaultFont attribute in PdfSaveOptions/ImageOrPrintOptions. For more detail, please see this article.

Determine if Paper Size of Worksheet is Automatic

Most of the time, paper size of the worksheet is automatic. When it is automatic, it is often set as Letter. Sometime user sets the paper size of the worksheet as per their requirements. In this case, the paper size is not automatic. You can find if the worksheet paper size is automatic or not using the Worksheet.getPageSetup().isAutomaticPaperSize() method.

Output Blank Page when there is Nothing to Print

If the sheet is empty, then Aspose.Cells will not print anything when you export worksheet to image. You can change this behavior by using the ImageOrPrintOptions.OutputBlankPageWhenNothingToPrint property. When you will set it true, it will print the blank page.

// Create workbook
Workbook wb = new Workbook();
 
// Access first worksheet - it is empty sheet
Worksheet ws = wb.getWorksheets().get(0);
 
// Specify image or print options
// Since the sheet is blank, we will set OutputBlankPageWhenNothingToPrint to true
// So that empty page gets printed
ImageOrPrintOptions opts = new ImageOrPrintOptions();
opts.setImageFormat(ImageFormat.getPng());
opts.setOutputBlankPageWhenNothingToPrint(true);
 
// Render empty sheet to png image
SheetRender sr = new SheetRender(ws, opts);
sr.toImage(0, dirPath + "OutputBlankPageWhenNothingToPrint.png");

Export Comments while Saving Excel file to Html

When you save your Excel file into HTML, comments are not exported. However, Aspose.Cells provides this feature using the HtmlSaveOptions.IsExportComments property. If you set it true, then HTML will also display comments present in your Excel file.

Disable Downlevel Revealed Comments while saving to HTML

When you save your Excel file to HTML, then Aspose.Cells reveal Downlevel Conditional Comments. These conditional comments are mostly relevant to old versions of Internet Explorer and are irrelevant to modern Web Browsers. You can read about them in detail at this link. Aspose.Cells allows you to eliminate these Downlevel Revealed Comments by setting the HtmlSaveOptions.DisableDownlevelRevealedComments property to true.

The screenshot shows the effect of this property on output Html when it is not set true.

Disable Downlevel Revealed Comments

Add Digital Signature to an already signed Excel file

Aspose.Cells provides the Workbook.addDigitalSignature(DigitalSignatureCollection digitalSignatureCollection) method that you can use to add digital signature to an already signed Excel file.

Please note while adding digital signature to an already signed Excel document, if the original document is Aspose.Cells generated document, it works well. But if the original document is generated by other engines (e.g. Microsoft Excel etc.), Aspose.Cells cannot keep the file same after loading and re-saving it, this will make the original signature to be invalid.

Copy VBA Project having User Form from Template to Target Workbook

Aspose.Cells allows you to copy VBA project from one Excel file into another Excel file. VBA project consists of various types of modules i.e. Document, Procedural, Designer etc. All modules can be copied with simple code but for Designer module, there is some extra data called Designer Storage needs to be accessed or copied. The following two methods deal with Designer Storage.

  • VbaModuleCollection.getDesignerStorage()
  • VbaModuleCollection.addDesignerStorage()

Please see the following article for more detail and sample code.

Send Shape Front or Back inside the Worksheet

When there are multiple shapes present in the same location then how will they be visible is decided by their z-order positions. Aspose.Cells provides Shape.toFrontOrBack() method which changes the z-order position of the shape. If you want to send shape to back you will use negative number like -1, -2, -3 etc. and if you want to send shape to front, you will use positive number like 1, 2, 3 etc.

This screenshot shows the effect of the code in the above article on the source workbook. As you can see, the z-order positions of shapes have been changed as per sample code.

Sort Data in Column with Custom Sort List

You can sort data in the column using custom list. This can be done using DataSorter.addKey(int key, SortOrder order, String customList) method. However, this method works only if the items in custom list do not have commas inside them. If they have commas like “USA,US”, “China,CN” etc., then you must use DataSorter.addKey(int key, SortOrder order, String[] customList) method. Here, the last parameter is not String but Array of Strings.

//Load the source Excel file
Workbook wb = new Workbook(dirPath + "sampleSortData_CustomSortList.xlsx");
  
//Access first worksheet
Worksheet ws = wb.getWorksheets().get(0);
  
//Specify cell area - sort from A1 to A40
CellArea ca = CellArea.createCellArea("A1", "A40");
  
//Create Custom Sort list
String[] customSortList = new String[] { "USA,US", "Brazil,BR", "China,CN", "Russia,RU", "Canada,CA" };
  
//Add Key for Column A, Sort it in Ascending Order with Custom Sort List
wb.getDataSorter().addKey(0, SortOrder.ASCENDING, customSortList);
wb.getDataSorter().sort(ws.getCells(), ca);
  
//Save the output Excel file
wb.save(dirPath + "outputSortData_CustomSortList.xlsx");

Add PDF Bookmarks with Named Destinations

Named Destinations are special kinds of bookmarks or links in PDF that do not depend on PDF pages. It means, if pages are added or deleted from PDF, bookmarks may become invalid but named destinations will remain intact. To create Named Destination, please use the PdfBookmarkEntry.setDestinationName() method.

Control loading of External Resources in MS Excel Workbook while rendering to PDF

Your Excel file may contain external resources e.g. linked images or objects. When you convert your Excel file to Pdf, Aspose.Cells retrieves these external resources and renders them to Pdf. But sometimes, you do not want to load these external resources and more than that, you want to manipulate them. You can do this using PdfSaveOptions.StreamProvider which implements the IStreamProvider interface.

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

Copy Range with Paste Options using Aspose.Cells for Cloud 17.9

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

Aspose Cells for CloudWe are pleased to announce the release of Aspose.Cells for Cloud 17.9. Aspose.Cells for Cloud is a platform independent REST API that allows developers to process their Excel files on Cloud. This release comes up with some new feature and enhancements. Please check Release Notes for summarized information about all the changes in this release.

Convert Excel File to HTML in Cloud

When Excel file is converted to HTML, it does not generate just a single file. Instead, the conversion generates many related files like multiple HTML files, CSS files, JavaScript files etc. In this release, we zip all of these related files together and send back to user a single zip file which he can download and unzip at his end. Please see the following article for more help.

Copy Range in a Worksheet with Paste Options

You can copy range in a worksheet with different paste options. Please see the following URI and JSON that can be used for this purpose.

http://api.aspose.cloud/v1.1/cells/sampleRangeCopyTo.xlsx/worksheets/Sheet1/ranges
{
  "Operate": "copyto",
 
  "Source": {
    "ColumnCount": 5,
    "ColumnWidth": 8.43,
    "FirstColumn": 1,
    "FirstRow": 0,
    "RowCount": 7,
    "RowHeight": 15,
  },
  "Target": {
    "ColumnCount": 5,
    "ColumnWidth": 8.43,
    "FirstColumn": 10,
    "FirstRow": 20,
    "RowCount": 7,
    "RowHeight": 15,
  }
,
  "PasteOptions": {
    "OnlyVisibleCells": true,
    "PasteType": "All",
    "SkipBlanks": true,
    "Transpose": false
  }
}

Change Heights of Rows and Widths of Columns inside the Range

You can change the heights of rows and widths of the columns inside the range with the following URIs.

~/{file-name}/worksheets/{sheetname}/ranges/rowHeight
~/{file-name}/worksheets/{sheetname}/ranges/columnWidth

Import CSV Data into Worksheet with Custom Parser

You can import CSV data into worksheet with custom parser. Custom Parser defines which column is to be formatted with custom format. Please see the following JSON that contains the CustomParsers object inside it.

{  
   "SeparatorString":",",
   "ConvertNumericData":true,
   "FirstRow":1,
   "FirstColumn":2,
   "SourceFile":"TestImportDataCSV.csv",
   "CustomParsers":[  
      {  
         "ColumnIndex":6,
         "ParseMethod":"ToString",
         "CustomStyle":"0%"
      }
   ],
   "DestinationWorksheet":"Sheet1",
   "IsInsert":true,
   "ImportDataType":"CSVData",
   "Source":null
}

Aspose.Cells for Cloud 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 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.Cells Product Family, Muhammad Shakeel Faiz | Leave a comment