Place Image to Excel Page Header & Selecting Range of Cells in Worksheet

The long awaited version of Aspose.Cells for Java 7.6.0 has been released. This release supports selecting a range of cells in the worksheet while activating the worksheets in the output Excel file. You may also specify a first page header and footer image for worksheet. We had a number of complaints regarding the image quality in chart-to-image conversion and have improved the quality to a certain extent. We have also resolved a number of exceptions encountered when reading and writing Microsoft Excel files, rendering charts to images and converting worksheets to image files. This release is also a maintenance release that contains enhancements and fixes for issues reported in earlier versions. In this release, we have fixed issues with manipulating charts and shapes. Several other important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, manipulating charts, manipulating worksheets and rendering to PDF format. Issues pertaining to the formula calculation engine have also been fixed in this release. This release includes plenty of improved features and bug fixes as listed below

• Saving Excel sheet with a few cells selected
• Place image to the header (only for the first page)
• Create STRAIGHT_CONNECTOR in MS Excel 2003 format
• GB18030 Characters display issues are resolved
• Chart Quality is enhanced
• Copying sheet lost ActiveX control’s properties and the control becomes a simple shape control is now fixed
• Setting image quality effect is enhanced in this release
• Workbook has Worksheets with duplicate CodeNames is now fixed
• Deleting chart causes unreadable spreadsheet is now fixed
• SheetRender.toImage() with ImageFormat.getJpeg() returns PNG image file
• Resizing Textbox in XLSX is resolved
• “#VALUE!” error after Calculation is fixed
• calculateFormula() issue is fixed and now work for INDEX function
• Error executing replace in text box is fixed
• The image shrank resolution increases and expands when decreases is now fixed

Other most recent bug fixes are also included in this release.

Code16K Encoding, Dark Images Recognition & Enhanced Image Processing

What's New in this Release?

The latest version of Aspose.BarCode for .NET5.8.0 has been released. This release adds an overall greatly improved recognition performance. We are pleased to share that from this version you can encode the Code16K symbology. This release also includes a number of new features and enhancements along with bug fixes. In order to improve the efficiency and effectiveness of the image processing part, it adds complex background and invert image techniques. Below is the list of new and improved features supported in this version

• Code16K new feature
• Provide a separate library for .NET 4.5
• New recognition hint: InvertImage
• Color quantification and new recognition hint
• Support dark images recognition
• MedianSmoothingWindowSize
• Another Median Smoothing method
• Return wrong location while reading PostNet barcodes is fixed
• Pdf417 barcode recognition is enhanced
• Recognition of barcode on dark background is improved
• Recognition of EAN13 from Tiff is fixed
• Recognition time is increased with new algorithm for barcode detection
• Recognition of DataMatrix is enhanced
• Taking too long to recognize barcode from a multi-page tiff is now fixed
• MIcroPDF417. Better method to detect rectangle.
• Code128 barcode performance issue is resolved
• Recognize of QR barcodes from PNG images is enhanced
• Incorrect size of detected barcode is fixed
• Recognition of QR code from the Pdf file is fixed
• Performance improved with Code128 bar code multi-page tif images
• Slow recognition speed while reading code128 bar codes from Tif file formats is enhanced
• Recognition of PDF417 codes from PNG images is enhanced
• Incorrect codetext found for PDF417 is fixed
• PDF417 recognition performance
• Incorrect recognition of NonStandard DataMatrix images is fixed
• Incorrect file description in details is now fixed
• Unable to recognize rectangular Datamatrix is now fixed
• Bad recognition speed of Aztec barcode is fixed
• Performance issues resolved with Code39 bar codes
• Recognition of QR code from jpg image is fixed
• Incorrect angle detected of a rotated bar code image is fixed
• Recognition of RM4SCC code from JPG image is fixed
• Incomplete code text when tried to read RM4SCC from JPG image

Other most recent bug fixes are also included in this release.

• Homepage of C# & VB.NET Barcode Component Aspose.BarCode for .NET

Resample Added Images to a Slide to Reduce File Size during Excel to PDF

The long awaited version of Aspose.Cells for .NET 7.6.0 has been released. The new release lets you select a different paper source when printing worksheets. Moreover, the collection objects are now Lambda/Linq friendly. We have added some significant enhancements for reading non-native Microsoft Excel files: now the component throws the appropriate exception when loading such files. We have improved the module for inserting OLE objects. This release, also supports resampling images added to slides to reduce the overall file size and improve performance. So, if you want to compress images while saving Excel to PDF format. We have fixed a few exceptions as well when reading/writing Excel files and refreshing pivot tables in the template files. In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, rendering and manipulating pivot tables, converting Excel files to HTML format, rendering and manipulating charts, rendering image files from charts and exporting Excel workbooks to PDF format have been resolved. A few improvements are also made pertaining to the formula calculation engine. We have made a few enhancements and fixed some bugs regarding context menu in IE8 browser type. We fix an issue for the Undo button while calculating formulas in the web based Grid control provided by Aspose.Cells for .NET.  We also included a few enhancements regarding formula calculations and formatting while importing Excel file in the desktop based Grid control provided by Aspose.Cells for .NET. This release includes few enhanced features and plenty of bug fixes as listed below

• Select a different PaperSource in Aspose.Cells
• Add collection objects to Lambda/Linq friendly
• PowerPoint file formats are detected now correctly by Aspose.Cells
• Publicize some older APIs (classes, methods etc.) after updating them (e.g. Shape.Paths, ShapePathCollection etc.)
• Inserting OLE Documents as linked – Issue resolved when updating SourceFullName attribute
• Set Excel VBS / CreateObject font color and cell’s shading color
• Support Re-sampling for the added images to reduce the file size
• Calculation of the height (via CalculateTextSize() method) is incorrect
• Output PDF's PivotTable does not look the same as its original XLSX file
• improved saving an XLSX file as a PDF
• Pivot chart with Dates in X-axis now appear in the output PDF
• Pivot table’s calculation field is now calculating correctly in the output PDF
• Pivot table’s vertical alignment always resets to Center is now fixed
• PivotTables are now auto-fitting rows to display the word wrapped contents correctly
• The background color is not rotated but text is rotated in the HTML is now fixed
• The generated Excel file from HTML format now have defined Cell Names
• Subtotal row of Date columns in the PDF does not have the same Date formatting
• Insert blank lines not working in other Pivot columns other than the first in the output PF is now fixed
• Background color doesn't match in Excel if exporting to HTML is now fixed
• Generated PDF does not have the PivotTables’ Page Breaks is now fixed
• SharedStrings are retained even after clearing data from the worksheet since v7.5.2.1 is now resolved
• XLS to PDF conversion prints all the pages instead of Print Area is now fixed
• Excel to PDF Arabic conversion issue is resolved
• Bug is fixed in converting Excel (RTL (Right-to-Left) format) to PDF
• Issue resolved with copying PivotTable in MS Excel 2010
• Text wrap setting is enhanced on refreshing PivotTable in Values’ columns
• PivotTables in XLS files cause corruption is now fixed
• Half of the dates are correct, but the other half is formatted as numbers is fixed
• Graph data labels are now rendered correctly
• Problem with setting Gradient fill color in the Line chart type series
• Equation and RSquared are now hiding in the Trend Lines
• Incorrect Pie charts issue is fixed after conversion from XLSX to XLS
• Chart to Image conversion issue is resolved
• Data sorter obliterates rich text formatting is now fixed
• Excel syntax now supported by Aspose.Cells - it should print 360
• Excel found unreadable content in XLSX is now fixed
• DATEDIF function problem in Aspose.Cells for .NET is resolved
• Formula calculation is much enhanced
• Security Alert in MS Excel after converting the file is fixed
• Japanese Fonts’ display problem is resolved
• “IFERROR(IF…” formula values now appear in PivotTable in output PDF
• Bugs resolved with right click menu and IE8 browser type
• Bug with Undo button in formulas’ calculation is fixed
• Link to cells in the same workbook is fixed
• Enhanced ADDRESS formula’s calculation

Other most recent bug fixes are also included in this release.

Convert PDF Files to HTML & Pdf to Image Conversion in Java Applications

The long awaited version of Aspose.Pdf for Java 4.3.0 has been released. This new release provides an exciting feature to convert PDF files to HTML format by using just two lines of code. We’ve previously provided the feature to extract PDF file contents as HTML using the PdfExtractor class’ extractTextAsHTML(..) method but the new approach greatly improves the output fidelity.

Here is the code:

// Load source PDF file
com.aspose.pdf.Document pdfDocument = new com.aspose.pdf.Document("c:/source.pdf");
// Save the file into HTML format
pdfDocument.save("c:/output.html", com.aspose.pdf.SaveFormat.Html);

In this new release, we have introduced a separate JAR file, aspose-pdf-4.3.0-jdk14.jar, targeted for JDK1.4 and JDK1.5. Furthermore, this release also provides better PDF to image conversion, both in terms of results and performance. Some important bug fixes included in this release are given below

• PDF to HTML
• Aspose.Pdf for Java 4.0.0(Merged version) is now compatible with jdk 1.5
• PDF to JPEG Conversion- Performance is much improved
• PDF to HTML - some words overlap and formatting issues are resolved
• Insert method of PdfFileEditor class causing problems are now fixed
• TextSegment class missing issue is resolved from com.aspose.pdf.facades package

Image Scaling in Presentations & PPTX to PDF Export with Large Images

The long awaited version of Aspose.Slides for .NET (7.9.0) has been released. In this release we have made many improvements. We’ve implemented support for setting a relative picture frame size as available in Microsoft PowerPoint. Please visit the documentation for an example. We have also made great improvement towards SmartArt rendering support and many issues encountered when rendering presentations with SmartArt shapes have been rectified. We have also addressed performance related issues and have made some good improvements in this area. Many PDF and thumbnail generation issues involving charts, tables and text have also been rectified. Some important bug fixes included in this release are given below

• Support for scaling options of image added in slide shapes
• Hanging Bullet text indentation lost resolved when text is moved to second line
• Performance is enhanced and resulting file is too large when exporting pptx with large images into PDF
• Support for appropriate exception messages on loading MS Office files using Aspose.Slides
• Reading and saving PPTM file corrupts the presentation is fixed
• Text Orientation rendering is enhanced in generated thumbnail
• Wrong slide LayoutType is read by Aspose.Slides for template presentation
• SmartArt text missing or improperly rendering is fixed in Aspose.Slides saved presentation
• Chart series labels rendering is much enhanced
• CellEx.Height and Table.GetRowHeight returns inaccurate values ar efixed
• Corrupted PPT generation on serializing shapes in PPT is enhanced
• Wrong word wrap calculation in TextLayout is fixed
• Scatter chart missing in generated PDF is fixed
• Line chart missing is resolved in the generated PDF
• Legends are now properly rendered in generated PDF
• Text alignment is enhanced in the generated PDF
• Chart category axis is fixed and now properly rendered in generated Pdf
• Enhanced text wrapping in the generated PDF
• SmartArt shape background missing is fixed in saved presentation and PDF
• SmartArt text is now properly rendered on saving presentation
• Vertical text is  now properly rendered in generated PDF
• Chinese font rendering is enhanced in the generated PDF
• Graph legend overlay property is improved & now retain in generated thumbnail/Pdf
• Wrong font rendering in exported XPS is resolved
• Text rendered outside of the shape in generated XPS
• Bullets rendering is enhanced in the generated PDF
• Master is now properly applied on cloned slides

Memory Management is Enhanced When Processing Large Size PDF Documents

The long awaited version of Aspose.Pdf for Java 4.2.1 has been released. This release provides better memory management when processing large size documents and performing operations that consume lots of memory. Furthermore, with this version, you only need to initialize the license using the com.aspose.pdf.License object and there is no need to explicitly set the license for legacy versions of Aspose.Pdf for Java (the aspose.pdf package). Recently, a customer contacted us who needed to search for two strings and remove the text appearing between them. We are pleased to share that this feature has been implemented. Please try using the following code snippet. Some important bug fixes included in this release are given below

• OutOfMemoryError during form manipulation is fixed
• Memory Leak issue is resolved on IPdfStreamAccessor.DataChanged
• Issues is resolved for filling form
• Single approach to initialize the license
• Aspose.Pdf for Java logging(log4j.xml) conflicts with tomcat logging is fixed
• Errors resolved after migrate from Aspose.Pdf.Kit to Aspose.Pdf 4.0.0
• Searching text and remove contents in between issues are resolved

Convert PDF to EPUB & XFA to PDF or Image, Get Status of PDF Printing

The latest version of Aspose.Pdf for .NET (8.5.0) has been released. This new release includes new features like PDF to EPUB conversion, dynamic XFA to PDF or image conversion, getting the status of a PDF printing job (finding out whether the process completed successfully or got stuck in the middle of execution) and specifying a particular page number to open when viewing the document. These entire features are introduced in latest release of Aspose.Pdf for .NET 8.5.0. At Aspose, we love to keep things simple and effective. Keeping that tradition alive, PDF to EPUB conversion is as simple as EPUB to PDF conversion. Just specify the source PDF file and leave the rest of the conversion job to Aspose.Pdf for .NET. Please visit the blog announcement page to view the code snippets for PDF to EPUB & dynamic XFA to PDF or image conversion. This release also includes other fixes related to converting PDF to HTML, converting PDF to image, creating tables inside a PDF file, manipulating bookmarks and converting PDF to PDF/A. This release includes plenty of new and improved features as listed below

• Convert PDF to ePUB
• Convert Dynamic XFA to PDF format
• Convert XFA form to Image format
• Checking success of a print Job
• Specify PDF page when viewing the document
• Implement tables import from different sources
• Optimize SVG file generation
• PDF to HTML: specify folder for SVG/other image resources(PNG,JPEG etc)
• Introduce Alignment.Justify setting in TextFragment object
• Component Hangs on corrupted document
• Incorrect coordinates of text Segment are being returned
• Annotation Import - Text Callout looses its arrow and box gets re-sized
• Incorrect XFA to Standard form conversion
• Table Alignment and Overlap issues
• Cell Padding Conflicts With Page Break
• When importing Annotation with 270 angle, sticking to textbox outline is fixed
• Extra padding over bottom when importing annotation is now fixed
• After adding LaunchAction, when closing the file, save message appearance is fixed
• Generating Pdf from HTML: Error on opening PDF file is resolved
• PDF to JPEG - Contents missing from resultant JPEG file is now fixed
• HTML Table to PDF is enhanced
• After saving a PDF the empty file issue is resolved
• HTML to PDF conversion problem is fixed
• Enhanced generating of password protected PDF file
• PDF to TIFF - Application hangs during conversion is now fixed
• PDF to TIFF - Contents over first page are now properly appearing
• Cell vertical alignment issue is resolved
• Alignment justification issue is resolved with hyphens
• XSL-FO to PDF: rendering of list blocking is now fixed
• PDF to TIFF: PdfConverter.StartPage gets wrong value is now fixed
• Validate method returning the wrong value is now fixed
• Bookmark zoom is now properly being recognized
• XFDF to PDF: Font size issue is resolved
• Bookmarks removal is fixed when converting PDF version to 1.4
• Infinite loop detection is fixed when saving PDF with table
• Table row height miscalculation is fixed

 

Create New Metafile from Raster Graphics, Write to WMF & EMF Formats

A new stable version of Aspose.Metafiles for Java 1.9.0 is released. This release version provides new support for saving the WMF and EMF metafiles as well. Now you can load the EMF, WMF or raster graphics files using Aspose.Metafiles classes and can save them to respective EMF and WMF formats. For more details about the supported features, please visit this documentation link. Below is the list of new and improved features included in this release

• Implement writing to WMF format
• Implement writing to EMF format
• Implement ability for creating new Metafile from raster graphics
• Metafile now detect the sizes of images
• EMF image rendered as black box is now fixed

Search & Replace Text in all Pages of PDF Document Using C# & VB.NET

This technical tip shows how to replace text in all pages of a PDF Document inside .NET Applications. In order to replace text in all the pages of a PDF document, you first need to use TextFragmentAbsorber to find the particular phrase you want to replace. After that, you need to go through all the TextFragments to replace the text and change any other attributes. Once you have done that, you only need to save the output PDF using Save method of the Document object.
The following code snippet shows you how to replace text in all pages of PDF document.

[C#]

//open document
Document pdfDocument = new Document("input.pdf");
//create TextAbsorber object to find all instances of the input search phrase
TextFragmentAbsorber textFragmentAbsorber = new TextFragmentAbsorber("Figure");
//accept the absorber for all the pages
pdfDocument.Pages.Accept(textFragmentAbsorber);
//get the extracted text fragments
TextFragmentCollection textFragmentCollection = textFragmentAbsorber.TextFragments;
//loop through the fragments
foreach (TextFragment textFragment in textFragmentCollection)
{
//update text and other properties
textFragment.Text = "New Phrase";
textFragment.TextState.Font = FontRepository.FindFont("Verdana");
textFragment.TextState.FontSize = 22;
textFragment.TextState.ForegroundColor =Aspose.Pdf.Color.FromRgb(System.Drawing.Color.Blue);
textFragment.TextState.BackgroundColor =Aspose.Pdf.Color.FromRgb(System.Drawing.Color.Green);
}
pdfDocument.Save("output.pdf");

[VB.NET]

'open document
Dim pdfDocument As New Document("input.pdf")
'create TextAbsorber object to find all instances of the input search phrase
Dim textFragmentAbsorber As New TextFragmentAbsorber("Figure")
'accept the absorber for all the pages
pdfDocument.Pages.Accept(textFragmentAbsorber)
'get the extracted text fragments
Dim textFragmentCollection As TextFragmentCollection = textFragmentAbsorber.TextFragments
'loop through the fragments
For Each textFragment As TextFragment In textFragmentCollection
'update text and other properties
textFragment.Text = "New Phrase"
textFragment.TextState.Font = FontRepository.FindFont("Verdana")
textFragment.TextState.FontSize = 22
textFragment.TextState.ForegroundColor = Aspose.Pdf.Color.FromRgb(System.Drawing.Color.Blue)
textFragment.TextState.BackgroundColor = Aspose.Pdf.Color.FromRgb(System.Drawing.Color.Green)
Next TextFragment
pdfDocument.Save("output.pdf")

• Homepage of Aspose.Pdf for .NET

Add Outlook MSG File to PST & Create/Save Contacts, Tasks & Notes as MSG

We are pleased to announce the release of Aspose.Email for .NET 3.4.0. This month’s release includes a major enhancement to the PST functionality that improves its performance when adding large amounts of data to PST. This enhancement reduces the overall disc I/O operations and, as a result, enhances the overall speed of adding Outlook MSG files to the PST. In addition, the AddMessages method has been added; it lets you copy a collection of messages to a PST folder. For a detailed example, refer to the Adding Bulk Messages article from our online documentation. Creating contacts, tasks and notes and adding them to PST had been supported in our earlier versions. However, saving these as an MSG file to disc or stream was not available. With this month’s release, creating and saving contacts, tasks and notes as MSG files is supported. In addition, adding photo data to an Outlook contact, a feature that was missing, is also supported. With this month’s release, conversion of S/MIME messages from EML to MSG (and vice versa) with preserving digital signatures is supported. The preserveSignature parameter in the MapiMessage.FromMailMessage method preserves the digital signature during conversion. It also includes a number of bug fixes reported by our customers. Specific to PST, the issue of large PST file size (created with Aspose.Email) as compared to those created with Outlook, has been fixed. Other issues such as message encoding disturbance during conversion of MSG to EML, message ID truncation, linked resources and others have also been fixed in this month’s release.

Render Excel Files to PDF, XPS, ODS & SVG Formats inside Android Apps

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v1.1.0. In this release, we have supported some more file formats, e.g. ODS, XPS, SVG etc. Moreover, Aspose.Cells for Android 1.1.0 includes all the important and useful features present in its native Aspose.Cells for Java. For example, the component now supports the following file formats and conversions, rendering Workbook to PDF, XPS, ODS and SVG formats, Worksheet to Image, Chart to Image, Excel to PDF, Shape to Image and many more. This release includes plenty of new & enhanced features as listed below

• Support rendering Excel files to PDF, XPS, ODS and SVG formats
• Support Shape to image and Chart to image features
• Support Sheet to image feature

 

Visio Diagram Embedded Resources Retrieval & Enhanced VSD to HTML Conv.

We are pleased to announce the new release of Aspose.Diagram for .NET 3.5.0. It improves the retrieval of embedded resources. This release also includes the most recent bug fixes such as Garbage text generation during embedded text file extraction, Shapes missing during the export of vdx to pdf, redirecting through a rendered hyperlink during VSD to HTML conversion, Extra white space when exporting VSD diagram to any image format and many more .

EPUB to PDF Conversion, Replace Text in a PDF: Aspose.Newsletter October 2013

Aspose Newsletter for October 2013 has now been published that highlights all the newly supported features offered in the recent releases of its JasperReports exporters, SQL Server rendering extensions, .NET, Java, SharePoint components, Android and REST APIs. It shares information about how to use Aspose for Android APIs to work with MS Office & Adobe Acrobat documents. A Case Study about how Digital Group uses Aspose.Cells for .NET instead of Interop to generate financial reports in MS Excel. The latest version of Aspose.Pdf for .NET now lets you convert EPUB to PDF with ease.

-  Collect original copy of Aspose.Newsletter, October – 2013