#Worksheet rendering to PDF

[file-formats-programming]

Protect Excel VBA Project & Apply DBNum Custom Pattern Formatting inside .NET Apps

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for .NET 17.4.0. Protect VBA Project of Excel Workbook and Lock it for Viewing, Specify Sort Warning While Sorting Data and Apply DBNum Custom Pattern Formatting in .NET.  The new release includes some valuable features and other enhancements with critical bug fixes. We have added certain features regarding VBA project’s protection for the users. There is also an enhancement for data sorting and custom pattern formatting. Aspose.Cells now supports the feature of protecting the VBA (Visual Basic for Applications) Project of Excel Workbook and locking it for viewing. Besides, users can also find if an existing VBA project is already protected and locked for viewing. The code snippet demonstrates how to protect an Excel Workbook VBA Project dynamically using Aspose.Cells and lock it for viewing. Aspose.Cells already supports Data Sorting, however earlier users could not sort a textual data as numerical data. For this purpose, Aspose.Cells implemented the DataSorter.SortAsNumber property. Whenever users sort textual data that looks like a number, MS-Excel shows this warning. DataSorter.SortAsNumber property implements this MS-Excel warning. It supports the DBNum custom pattern formatting. For example, if a cell value is 123 and users specify its custom formatting as [DBNum2][$-804]General then it will be displayed like 壹佰贰拾叁. Developers can specify custom formatting of a cell using Cell.GetStyle() method and Style.Custom attribute. Aspose.Cells for .NET 17.4.0 has enhanced its core for more stability as well as fixed many critical bugs. Moreover, there are numerous minor enhancements in order to improve the overall usage of the API.A few of the worth mentioning enhancements includes, such as Set Column Header ToolTip, sparklines disappear after re-saving and rendering to PDF, Formatting error inside shapes texts when Excel is converted to PDF, VbaProject.Sign causes an exception and Re-adding a picture to the same XLS throws a Null Reference error. Furthermore, in this release, we have fixed several other issues, such as issues around reading/writing MS Excel file formats, manipulating Pivot Tables, applying formatting to cells, manipulating Ole Objects and shapes, rendering and manipulating charts, rendering HTML to Excel and vice versa, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. The formula calculation engine is enhanced too in the new release. This release includes several enhanced features and bug fixes as listed below

Support "Lock project for viewing" Protection option in VbaProject Properties

Password protect the VBA project

Implement Sort Warning feature - Sort anything that looks like a number

Function SetColumnHeaderToolTip(int colIndex, string toolTip) missing in newer APIs set - Aspose.Cells.GridWeb

Change filter list to multiple checkbox selection list for GridWeb

PivotTable Grouping and Pivot Report Filter selection disappear when loading in GridWeb

Sparklines disappear after rendering to PDF

Sparklines disappear after re-saving the file

OutOfMemoryException while saving CSV to PDF

Format tag in the SpreadsheetML content keeps hanging on loading

Remove some calls to string.ToUpper() method (if possible) in the source code

Some shapes are separated/distorted and dim in the rendered PDF file

Removing worksheet causes to save a corrupt XLSM

Saving worksheet as HTML with overflowed text in cells

Some text is overlapping or invisible and vertical alignment is not right in Excel to HTML rendering

When HTML is saved as XLSX, text layout is different

When HTML is saved as XLSX, text format is changed

When HTML is saved as XLSX, part of content is missing

When loading HTML and save it as XLSX, paragraphs are missing and changed

Issue with Pivot Filters Text

Number format does not work correctly in the Pivot Table

Some text is overlapping with other cells and vertical alignment is not right

Problem while importing dates around 1900 from CSV file

Font is bolder in the output PDF file when setting the PDF optimization type to "MinimumSize"

Font changed in the output image/PDF

Slight Vertical Alignment Difference between Excel and Aspose.Cells Pdfs

Font is different and percentage sign is missing in the output PDF file

Charts have "Axis Title"

3D Column charts are not rendered fine in the output PDF file

Category axis labels are not showing of chart in the output PDF

Deleting worksheet in XLSM leaves behind a remnant sheet in vba project

When specific file is saved, the output is corrupted

Excel documents gets corrupted after Save

Formula 'DAYS' in Excel tables gets replaced with a NamedRange

Setting LightAngle value corrupts Excel file

Inserting rows breaking formulas linking to external workbook

The table style was changed (The table lines are missing) after re-save in a specific XLS

Aspose.Cells sorts fine but formulas are converted to values

Cells range deletion with shift up option does not style on cells

Workbook gets corrupt after open and save

Datatable is not being shifted down properly in an XLSX

Cannot read worksheets of a password protected XLSX file

Cells.DeleteRange() is not working properly

Cannot update OleObject.ObjectSourceFullName property

Cells range deletion with shift up option does not decrease hyperlink count

Incorrect hyperlinks count when duplicating the single row data in an XLS

Moving the array in Input2.xlsx results in an unopenable file that crashes Excel on startup

Reference in the array does not update when the referenced cells are moved in Input.xlsx

Replace background for shape doesn't work

The "Locked" attribute of ActiveX control (ComboBox) is not changed while protecting worksheet

Horizontal scrollbar lost (in Google chrome) in GridWeb

Big lags (in scrolling, selecting a cell, etc.) when using long list of merged cells

The alignment of the cells lost when inserting/pasting values into the cells

Percentage value changes to NaN

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Password Protect the VBA Project of Excel Workbook

Specifying Sort Warning While Sorting Data

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

Homepage of Aspose.Cells for .NET C#

Download Aspose.Cells for .NET

Online documentation of Aspose.Cells for .NET

[legacypiner]

Anychart pdf landscape export

ANYCHART PDF LANDSCAPE EXPORT HOW TO

ANYCHART PDF LANDSCAPE EXPORT FOR MAC

ANYCHART PDF LANDSCAPE EXPORT PDF

ANYCHART PDF LANDSCAPE EXPORT INSTALL

ANYCHART PDF LANDSCAPE EXPORT FULL

If its location is different from the default one, or you are installing Export Server on Windows, check the location where Phantom JS is installed and set the right path for the server: java -Dphantomjs.binary.

Download An圜hart Export Server binary file.Īn圜hart Export Server needs PhantomJS.

ANYCHART PDF LANDSCAPE EXPORT INSTALL

Install Java: version above 6, 7, 8 - ).

or download it from the chromedriver official site and add it to the PATH.

ANYCHART PDF LANDSCAPE EXPORT FOR MAC

brew install chromedriver for Mac users.

Alternatively, install Chrome or Chromium browser (version 60.0 and above) and install chromedriver:.

or download it from the geckodriver official site and add it to the PATH.

Install Firefox browser (version 56.0 and above) and install geckodriver:.

Download PhantomJS from the PhantomJS official site and make sure PhantomJS binary is in the PATH.

To run the An圜hart Export Server, do the following: Exporting to CSV, JSON, and XML does not require PhantomJS: the server acts only as an intermediary allowing the file to be saved using a browser.Īn圜hart Export Server is a Java application (JAR file) that runs using Java, so it works on Windows, Linux, MacOS, or any other OS where Java is available. If you need to take a screenshot of a page on the Internet or in a local HTML file, you can just use Chrome or Firefox in the headless mode without the An圜hart Export Server. EnvironmentĪn圜hart Export Server uses PhantomJS, which emulates a browser on the server (WebKit), runs our charts in it, gets SVG, and converts it into *.PNG, *.JPG, or *.PDF files. In such cases, we suggest that you use An圜hart Export Server.Īn圜hart Export Server is also used to provide chart export to PNG, JPG, PDF, SVG, CSV, Excel, JSON, and XML. Server-side rendering is a tool that is very helpful in many cases: when you have an automated email system, and you need to include charts in letters when you need charts in reports that are generated on servers when you need to show charts on a Smart TV with a stripped version of a browser and so on.

Triple Exponential Moving Average (TRIX).

Moving Average Convergence Divergence (MACD).

Place all files from the sample to your server and open autosave.html file.ĭownload sample: Replace all charts by images Sample. In the sample below JavaScript is used to replace all charts on the page by images, images are generated by server-side PHP script, you need to have PHP 4.3.0 or higher enabled web-server with GD support to watch this sample in work.

ANYCHART PDF LANDSCAPE EXPORT HOW TO

Also, it shows how to center data horizontally on a page :)ex.

ANYCHART PDF LANDSCAPE EXPORT PDF

To export page with Flash Charts to PDF you need to replace all flash content by images. The video shows a quick demonstration on how to save an Excel worksheet in Landscape as a PDF. Please review PDFSaver.php before deploying PDF Saver on your server.ĭownload PDF Generation Scripts: PDFGeneration Script. You can download script that is used at An圜hart.Com to generate PDF documents from the link below, please note that this script is written on PHP and uses 3rd party html2ps and html2pdf generation library. Image type defines image format to be passed to script - this allows to use PNG or JPG (if your converter doesn't support one of these formats).Īll samples in An圜hart Gallery and Live Previews in documentation have "Save as PDF" button (you can also see "Save as PDF" menu item on chart right-click), this button invokes method that passes image to server and server-side script generates PDF document that is passed back to chart. In An圜hart, you can configure context menu item that allows to save chart as PDF, you can set where converter script is located and image sizes (for example to fit letter page format). They use LGPL PHP html2ps and html2pdf Library to create PDF documents, but you can use any other library of your choice. Sample below demonstrate how PDF export image can be implemented.

ANYCHART PDF LANDSCAPE EXPORT FULL

When An圜hart finishes rendering a chart on client-side it can create a PNG or JPEG image and send it to server or application, PNG or JPEG image data is sent in base64 encoding and server should decode it and output to the server.Īny server side script that is capable to create PDF document can now use this image data to create PDF document with chart.Īlso, you can embed a JavaScript that will replace all Flash charts on the page by images (which should be generated by server-side script), and then pass full HTML page to PDF export script, that allows to convert HTML to PDF. This feature requires server side scripts that are capable of creating PDF documents. Sometimes it very important to have an ability to be able to generate a PDF report, a lot of Paperless office use PDF as a standard for documents, An圜hart allows to create PDF reports with charts, using "Save as Image" feature.

[baseblog701-blog]

Hyperlinks Not Working In Excel 2016

Excel Spreadsheet Hyperlinks Not Working

Break Link Not Working In Excel 2016

Dan has a shared workbook into which he needs to insert a hyperlink. However, as long as the workbook is shared, the hyperlink features in Excel are not available. Dan wonders if there is a way to insert hyperlinks into shared workbooks.

The short answer is no, there is not. When you choose to share a workbook, some options in Excel are simply not available any more; inserting hyperlinks is one of those options that is removed once the workbook is shared.

If you absolutely must add the hyperlink to the workbook, the only option is to unshare the workbook, add the hyperlink, and then again share the workbook. You'll no longer be able to add any more hyperlinks, but the one you added while the workbook was unshared will work just fine.

Option 2: disable hyperlinks as you type. To remove the hyperlink completely, select it and then press Delete. Delete Worksheet in Excel VBA – Disable Application Alerts or Warning message: While executing the above code, we got a warning message. MS Excel 2016: Set up a cell to allow a maximum number of characters. Excel Hyperlinks Stopped Working. Excel Details: Why have the hyperlinks in Excel 2013 stopped working.Excel Details: Check your Excel settings to see if the interpretation of a hyperlink value in a cell should be rendered as regular text or if it should be a live hyperlink.Go to Options - Proofing and ensure 'Ignore Internet and file addresses' is checked on. Links not opening in excel.

There is one caveat in taking this approach to adding the hyperlink—you need to be careful that you don't unshare the workbook if you have the Track Changes feature of Excel turned on. In the process of unsharing the workbook, Excel will turn off the tracking and discard the change history. If this is important to you, the only option is to make sure that you add the hyperlinks before sharing the workbook and first turning on Track Changes.

Follow one of the steps depending on the Excel version you are using: In Excel 2016, Excel 2013, and Excel 2010: Click the File tab. Click Properties, and then select Advanced Properties. In the Summary tab, in the Hyperlink base text box, type the path that you want to use. I am using your Acrobat Pro XII trial version, I am running Excel 2016 for PC. I have hyperlinks in my excel form and when I convert it to PDF they do not transfer over. I have tried 'Save as' a PDF and also 'Print', save as PDF, convert the Excel file to PDF using Adobe PDF maker.

-->

Original KB number: 310049

Symptoms

Assume that you set Internet Explorer as your default browser in Windows. When you select a hyperlink in Microsoft Outlook, you receive one of the following error messages, depending on your Outlook version:

This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.

Your organization's policies are preventing us from completing this action for you. For more info, please contact your help desk.

Resolution

To resolve this problem, follow these methods in order. Check whether the problem is resolved after each method.

Method 1: Reset Internet Explorer settings

Internet Explorer 11 and Internet Explorer 10

Warning

If you are using Windows 10, Windows 8.1 or Windows 8, proceed to method 2.

Start Internet Explorer.

Select Tools > Internet Options.

Select Advanced > Reset.

In the Reset Internet Explorer Settings window, select Delete personal settings > Reset.

Select Close when it is completed.

Close and restart Internet Explorer.

Select Tools > Internet Options.

Select Programs > Set programs.

Select Set your default programs.

In the Programs list, select Microsoft Outlook > Set this program as default.

Scroll back up to the top of the default programs list and highlight Internet Explorer and select Set this program as default.

Select OK, and close the Default Programs dialog box.

Internet Explorer 9

Start Internet Explorer.

Select Tools > Internet Options.

Select Advanced > Reset.

In the Reset Internet Explorer Settings window, select the Delete personal settings > Reset.

Select Close when it is completed.

Restart Internet Explorer.

Select Tools > Internet Options.

Select Programs > Set programs.

Select Set your default programs.

In the Programs list, select Microsoft Outlook > Set this program as default.

Select OK, and then close the Default Programs dialog box.

In the Internet Options dialog box, select the Programs tab, and then select Make default under Default web browser.

Select OK.

Internet Explorer 8 and Internet Explorer 7

Start Internet Explorer.

On the Tools menu, select Internet Options.

Select Advanced > Reset.

Select Programs > Set programs.

Select Set Default Programs.

Select Microsoft Outlook > Set this program as default.

Select OK, and then close the Default Programs dialog box.

In the Internet Options dialog box, select the Programs tab, and then select Make default under Default web browser.

Select OK.

Internet Explorer 6

Start Internet Explorer.

On the Tools menu, select Internet Options.

Select Programs > Reset Web Settings.

Under Internet programs, make sure that the correct email program is selected.

Select the Internet Explorer should check to see whether it is the default browser check box.

Select Apply > OK.

Note

You may receive the following message when Internet Explorer starts: Internet Explorer is not currently your default browser. Would you like to make it your default browser?

If you receive this message, select Yes.

Method 2 - Export and import the registry key from another computer

This section is intended for advanced computer users. For help with advanced troubleshooting, ask your system administrator or contact Microsoft Support.

Important

Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.

Excel Spreadsheet Hyperlinks Not Working

Note

Use this method only if the earlier instructions for each browser do not work to resolve this problem.

Step 1: Export the registry key from another computer

On a computer that does not encounter this problem, select Start > Run.

In the Open box, type regedit, and then select OK.

Locate, and then select the registry subkey: HKEY_LOCAL_MACHINESoftwareClasseshtmlfileshellopencommand.

On the File or Registry menu (depending on your operating system), select Export.

Note the location where the file will be saved.

Type a unique file name, and then select Save.

Exit Registry Editor.

Step 2: Import the registry key

Copy the exported registry key to the desktop on the problem computer.

Double-click the .reg file.

You may receive the following message:

Windows 10, Windows 8.1, and Windows 8

Adding information can unintentionally change or delete values and cause components to stop working correctly. If you do not trust the source of this information in C:Users<yourlogon>Desktopregkey.reg, do not add it to the registry.

Windows 7

Are you sure you want to add the information in drive: location file was copied tofile name.reg to the registry?

Select Yes > OK.

Step 3: Verify that the String (Default) value of the HKEY_CLASSES_ROOT .html key is htmlfile

Break Link Not Working In Excel 2016

Select Start > Run.

In the Open box, type regedit, and then select OK.

Locate, and then select the registry subkey: HKEY_CLASSES_ROOT .html.

Make sure that the value of the String (Default) is 'htmlfile'. If it's not htmlfile, right-click (Default), select Modify, input htmlfile in the Value data box, and then select OK.

Exit Registry Editor.

[itssoftigator]

VectorWorks 2018-2019 Crack MAC

VectorWorks Crack Mac + Serial quantity Cost-free Obtain

VectorWorks 2018 Crack is an remarkable software. Moreover, it permits your drafts, products, and existing interface in a one and interesting interface. In addition, it carries out an awesome 2D and 3D structure for landscape, layout or drama packages or solutions. Hence, it involves a nice tool for complex drawings, cartography, and 3D modeling. Also, it delivers a ideal BIM and CAD programming in the globe. The program crack variation incorporates an comprehensive theoretical drawing or enhancing instrument. Hence, it is composed of lots of modern-day methods similarly tape, cell pages, and rotating sights. You can see the out there icons or instruments. As properly as, it has an ascending or descending instrument and also a essential dimension mapping resource.

VectorWorks Crack + Serial essential

Dependent on the best rendering motor of CINEMA 4D, it can generate excellent patterns. This software program enables you to carry your impressive suggestions to every day daily life. Furthermore, it will work with most broadly-utilized file formats, like DXF, DWG, EPSF, 3DS, PDF, SAT, Shapefile, IGES, Rhino, Para-sound and much numerous, which include numerous importing houses of SketchUp 3D designs. Via Vector Performs manager, you can down load and put in many libraries. You will see a lot of collections like architectural objects for constructing designs, landscape elements, home furnishings, light-weight methods and much more.

VectorWorks Crack Full Verison

The application designer software lets you make a simple to elaborate layouts and create BIM- organization data mode and SIM-Web-site details modeling attributes for your amazing venture. Therefore, the person can arrive with complete documentation to contain content analysis, expense, and energy effectiveness, as well as making bordering inspection. The greatest thing about it is its versatility. This application is not confined to architectural modeling but handles other regions, likewise technological modeling, which is applicable to Tv set and the leisure sector, general.

Critical Attributes

Thus, it includes a exclusive ink device

As properly as, it features a drainage device

Improving the range instruments command

Also, it maximized the audiovisual tools

Appear with a stanchion and rope software

Supporting inventory symbols and various plugin

What`s new VectorWorks Full Crack Keygen:

Fixed difficulties:

Marionette – undo Thriller Object

Fractional screen for proportions- aligned badly

Crash in DWG_library! ExGsMaterialDumpview::Triangle out

Crash in GETappropriateObjectOpacity

During the execution of solar animation, VW will harm

Configurations like ecosystem lighting are skipped when you do Save and Commit RW track record

When the witness strains offset is zero, you are unable to resize a dimension

Threads trapped in Parasolid

Crash updating worksheets

Opening AutoCAD file crashes Vector Is effective

POPUP

Light-weight XML file not getting latest updates when go or insertion initiated

Undertaking Sharing- chain dimension and revision cloud incredibly gradual

Brace works

Bare minimum Computer Demands:

OS:   All Windows versions

CPU:  Intel Ci3 or afterwards

RAM: 4GB is fantastic plenty of

HDD: 20 GB absolutely free place

Display screen: 1240 X 786

Other Important Phrases

Vectorworks crack, Vectorworks 2017 crack acquire, Vectorworks 2017 cracked obtain, Vectorworks 2018 comprehensive crack, Vectorworks 2018 windows crack

The Crack Installation Method:

Initial of all, Download VectorWorks 2019 Crack

Right after getting it

Wait around for the subsequent system

Run it

At last, all is carried out

Bingo

Screenshots:

VectorWorks 2018 Whole + Crack 

Review JetBrains CLion 2018.3.2 Crack License Key Free Software

Originally Published Here: VectorWorks 2018-2019 Crack MAC

[groupdocscom]

Get the list of folders and subfolders from your OST and PST Outlook data files; render the messages from these folders to PDF, HTML and Image formats with the help of the new monthly release of the .NET document rendering API. Latest version also supports ignoring empty columns while rendering Microsoft Excel worksheets within your .NET apps to reduce processing time and optimize memory usage when working with large files. Also included in this release of GroupDocs.Viewer for .NET are a number of key enhancements and bug fixes – http://bit.ly/2UNFCDL

YouTube video tutorials of the GroupDocs API – http://bit.ly/2UKFx3L

[file-formats-programming]

Create, Manipulate & Convert Excel Spreadsheets without using MS Excel in PHP APPs

What's New in this Release?

Aspose team is pleased to announce the first public release of Aspose.Cells for PHP via Java v18.7. The new API incorporates MS Excel data processing and rendering functionalities in PHP (a widely-used open source scripting language). Aspose.Cells for PHP via Java has full functionality of Aspose.Cells for Java with a few limitations, minor API changes and additional requirements. Aspose.Cells for PHP is a subset API that includes all the important and useful features present in its native Aspose.Cells for Java. Aspose.Cells for PHP via Java is equally robust and feature rich component. It supports high-fidelity file format conversions to and from XLS, XLSX, XLSM, SpreadsheetML, CSV, Tab Delimited, HTML, MHTML and OpenDocument Spreadsheet in PHP. The developers will have full programmatic access through a rich APIs set to all MS Excel document objects and formatting that allows to create, modify, extract, copy, merge, and replace spreadsheet content. With Aspose.Cells for PHP via Java, developers can export data, format spreadsheets to the most granular level, create, manipulate and render charts, apply and calculate complex formulas efficiently and much more. The list of most notable new and improved features in this release are listed below

Supports for XLS, SpreadsheetML (XLSX, XML), Comma Separated Value (CSV), HTML, OpenDocument Spreadsheet (ODS), PDF, Tab Delimited, Plain Text (TXT)

Render spreadsheet to vector images (EMF)

Render worksheets to raster images (Multipage TIFF, GIF)

Render worksheets to raster images (PNG, JPEG, etc.)

Render Spreadsheet to PDF with high fidelity

Render spreadsheet to vector images (EMF)

Render worksheets to raster images (Multipage TIFF, GIF)

Render worksheets to raster images (PNG, JPEG, etc.)

Render Spreadsheet to PDF with high fidelity

Copy or move worksheets within or between workbooks

Insert images, Create conventional and custom charts and Set gradient background for charts using API

Add comments to cells

Microsoft Excel 2007/2010 themes and colors

Create auto-filters

Implement data validations

Implement data sorting

Find and replace text

Merge/split Cells

Group/ungroup rows and columns

Create custom page breaks

Calculate complex Excel formulae

Support advanced conditional formatting supported in Microsoft Excel 2007/2010

Freeze/unfreeze Panes

Insert hyperlinks to link data

Implement Smart Markers

Specify document properties settings

Protect/unprotect worksheets

Specify advanced protection options introduced in Excel XP and later versions

Create list object/Microsoft Excel tables

Create subtotals

Insert form controls and other drawing shapes/objects

Create pivot tables and pivot charts

Preserve or remove addin, VBA, macros

Manipulate named ranges

Add, preserve or extract OLE objects from the spreadsheets.

Implement Microsoft Excel sparklines

Apply all characters formatting in the cells including fonts, colors, effects, borders and shading

Apply all the number format settings (supported in Microsoft Excel) for the cells

Set all types of text alignment settings

Apply different kinds of Font Settings for the cells

Apply different colors to cells, fonts, gridlines, graphic objects etc.

Apply different rich text formatting in a single cell

Apply different border settings on cells

Apply different background patterns on cells

Apply Format settings on a worksheet, row, column or a range of cells etc.

Adjust your page orientation, scaling, paper size

Specify your margins and page centering

Create or edit your header and/or footer

Set print area, print titles, or turn on gridlines etc.

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for PHP via Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Product Overview

Converting Excel Files to HTML

Overview: Aspose.Cells for PHP

Aspose.Cells for PHP via Java is an Excel Spreadsheet Processing API that allows the developers to add the ability to read, write, convert and manipulate Excel spreadsheets in their on PHP applications while using the JavaBridge. The new API is equally robust and feature rich component. It supports high-fidelity file format conversions to and from XLS, XLSX, XLSM, SpreadsheetML, CSV, Tab Delimited, HTML, MHTML and OpenDocument Spreadsheet in PHP.It is capable of converting spreadsheets to PDF, XPS & HTML formats while maintaining the highest visual fidelity. 

More about for Aspose.Cells for PHP

Homepage Aspose.Cells for PHP via Java

Download Aspose.Cells for PHP via Java

Online documentation of Aspose.Cells for PHP via Java

Post your technical questions/queries to Aspose.Cells Forum

[file-formats-programming]

Show/Hide Pivot Items of Pivot Field & Resize List Object or Table in a Worksheet using REST APIs

What's New in this Release?

We are pleased to announce the release of Aspose.Cells for Cloud 16.12.0 with important new features and improvements. With Aspose.Cells for Cloud users can work with all aspects of spreadsheets e.g. worksheets, rows, columns, cells, text, data, images, links, comments, formulas, charts and save them to PDF, HTML, XPS and many other formats. It is a complete solution for performing any operation users can wish to perform on Microsoft Excel and OpenOffice spreadsheets in the cloud. This release now supports to show or hide pivot items of pivot field inside the pivot table. Article on the blog announcement and resource API explain how to show or hide pivot items of pivot fields. Users can also resize list object or table inside the worksheet using this release. Documentation articles on the blog announcement page explain how to utilize this feature. Following are the important features and enhancements included in this release.

Show/Hide the PivotItems of PivotField

Support to Resize Table in Aspose.Cells for Cloud API

Shape to image error while converting spreadsheet to PDF file format

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

Overview: Aspose for Cloud

Aspose for Cloud is a cloud-based document generation, conversion and automation platform for developers that offer a unique suite of APIs to work with Word documents, Excel spreadsheets, PowerPoint presentations, PDFs, and email formats and protocols. It supports all features for file processing, document scanning, barcodes creation and recognition, and allows extracting text or images too. Users can also work with SaaSpose APIs using REST SDKs that can be called from .NET, Java, PHP and Ruby etc.

More about Aspose for Cloud

Learn More about Aspose.Cells for Cloud

Download Aspose.Cells for Cloud

Aspose.Cells for Cloud Documentation

[file-formats-programming]

Aspose.Newsletter February 2019: Enhance Productivity using JDK 11 Compatible PDF API & More

Aspose Newsletter for February 2019 has now been published that highlights all the newly supported features offered in the recent releases. It includes information about Enhancing productivity & performance using JDK 11 compatible PDF API, Loading Excel workbook efficiently without loading VBA project, Use latest version of Aspose.PDF for C++ with new codebase changes, Create PST folder hierarchy with string notation, Detect archive-based file format and work with AMF files in .NET and Java 3D applications and more.

Planning to move PDF applications to Java 11 or 10?

Enhance productivity & performance using JDK 11 compatible PDF API. Aspose.PDF for Java offers native API to generate, manipulate, convert, compress, render, secure and print PDF documents without needing Adobe Acrobat. Developers can also create new PDF documents directly through the API or via XML templates. With just a few lines of code – Convert PDF to Word, Excel, PowerPoint, HTML, images and many other file formats. Download Trial

Loading Excel workbook efficiently without loading VBA project

Aspose.Cells APIs provide the ability to create, manipulate, convert or render Microsoft Excel spreadsheets. Excel files might have large number of macros but sometimes, it is needed to load worksheets only without loading these VBA projects just like extracting the sheet names from loaded workbook. Aspose.Cells has introduced a filter option LoadDataFilterOptions.VBA within Aspose.Cells for .NET, Java and Android via Java APIs that can load/skip VBA projects.

Use latest version of Aspose.PDF for C++ with new codebase changes

Aspose.PDF for C++ is a native C++ API to create, read, edit or render PDF documents from within C++ applications. The latest version announces entire codebase change, ported from Aspose.PDF for .NET to C++ API this making it more exciting and appealing for developers along with improved performance and stability. Read more details

Email API for .NET & Java – Create PST folder hierarchy with string notation

Aspose.Email offers native email formats processing APIs to create, edit, convert and transmit emails without using Microsoft Outlook. This release adds an overload to AddSubFolder(string name, bool createHierarchy) and CreatePredefinedFolder(string name, StandardIpmFolder defaultFolder, bool createHierarchy) functions that enable you to create folder hierarchy using string notation within any type of .NET and Java applications.

Detect archive-based file format and work with AMF files in .NET and Java 3D applications

Aspose.3D API seamlessly supports manipulating 3D documents without using any 3D modeling and rendering software. The latest version now announces support of standard 3D printing format i.e. AMF along with a new feature to detect archive-based file format within .NET and Java applications. Read more details

Code Example: Applying custom formatting for Time field and control threshold for TIFF binarization in .NET and Java

Aspose.Words offers market-leading APIs for word documents processing on any platform. Aspose.Words for .NET now supports a new feature to apply custom formatting to Time field as per customer requirements. A new property ThresholdForFloydSteinbergDithering in ImageSaveOptions class is also introduced to control threshold for TIFF binarization within .NET and Java applications.

Code Example: Printing PDF documents using PrintController of Aspose.PDF for .NET

Aspose.PDF for .NET is an advance PDF files processing and parsing API to create, edit, protect and convert PDF documents. The latest release of PDF API offers PrintController class that helps saving a System.Drawing.Printing.PrintDocument as PDF format. Read more

Code Example: Convert Word document to HTML format in SharePoint Apps

Aspose.Words for SharePoint supports converting and combining word documents within Microsoft SharePoint applications. The entire codebase is optimized to improve the overall functionality. Using the latest version – users can convert Word document to HTML format now. Read more

Read dotted barcodes from TIFF images in JasperReports

Aspose.BarCode for JasperReports is a flexible JasperReports and JasperServer extension to generate and display high quality barcode labels in your applications. The latest version adds the ability to read dotted barcodes from Tiff images within JasperReports. Read more

Code Example: Rendering IGES and PLT drawings to PDF in .NET and Java applications

Aspose.CAD APIs allow developers to convert CAD files to PDF, XPS and raster images in .NET and Java applications. The latest version now supports exporting IGES and PLT files to PDF using CadRasterizationOption and PdfOptions

Updates about new Product Releases

Aspose.Total for Cloud – RTF compression implemented, and other enhancements.

Aspose.Total for Android – all the latest versions of Aspose Android APIs.

Aspose.Total for SharePoint – a compilation of Aspose latest SharePoint products.

Aspose.Total for Reporting Services– a compilation of Aspose latest Reporting Services products

Aspose.Total for JasperReports – The latest versions of Aspose JasperReports products.

Aspose.Total for C++ – The latest versions of our C++ products packaged into one product suite.

Aspose.Words for Reporting Services 18.12 – Upgraded Aspose.Words for Reporting Services to Aspose.Words for .NET 18.12.

Aspose.Slides for .NET 18.12 – Improved fonts and EMF images rendering.

Aspose.Diagram for .NET and Java 18.12 – Improved conversion of VISIO diagrams to PDF, PNG and GIF file formats.

Aspose.Words for JasperReports 18.12 – Upgraded Aspose.Words for JasperReports to Aspose.Words for Java 18.12 and fixed issue related to table cell height.

Aspose.Tasks for .NET 19.1 – Fixed reported issues and improved reading MS Project files.

Aspose.Slides for Java 18.12 – Improved PowerPoint file formats rendering issues.

Aspose.Note for .NET 19.1 – Improved refactor rendering for underline text and rich text while saving .ONE documents to PDF.

Aspose.Slides for C++ 18.12 – Improve EMF/WMF format processing.

Aspose.HTML for .NET 19.1 – Improved cascading style sheets (CSS) processing for high fidelity rendering.

Collect a copy of Aspose Newsletter, February 2018 edition

Collect the English version of this newsletter

[file-formats-programming]

Load any HTML with Self-Closing Tags & Convert It to Excel File inside Android Apps

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android via Java 18.12. Depiction of data through HTML page is very common, however this page can be opened in variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in “pt” which works in many cases. However there can be case where this fixed size may not be required. For example if container panel width is 600px where this HTML page is being displayed. In this case users may get horizontal scrollbar if the generated table width is bigger. This requirement is addressed by providing scalable units like em or percent for a better presentation. Empty tags are very common while working with HTML like we can face <td></td> or simply <td/>. Earlier self-closing tags were not supported however now this support is provided. Now users can load any HTML with self-closing tags and convert it to Excel file. Named regions can have English formulae and this file can be used in environments where systems are configured to German Locale. There is need to translate these English formulae completely to German language for correct usage in Excel configured for German language. This feature is fully functional and can be used without any extra coding. Excel provides custom filters like filter rows which begins with and ends with some specific string.  Aspose.Cells provides rich features to manage shapes in the spreadsheet. Sometimes there is needed to get the connection points of a shape for aligning or placing the shapes at appropriate place. For this purpose all the connection points are required. Pivot tables are very common reports which are present in the workbooks. These reports are updated time by time and it is important to know the last time when report was updated for better decision making. Aspose.Cells has provided this feature by introducing property RefreshDate. Similarly name of the person who updated the pivot table is also provided as property RefreshedByWho.  Smart art is used for better representation of information however earlier the text in the smart art shapes was fixed. This limitation is gone now as now smart art text can be updated. For this purpose shape.setText() function is introduced which sets new text in the smart art shape. Data validation is done in variety of ways to control the input in the Excel file. Like limit can be defined for a cell within which some number can be entered, otherwise error message is raised. Issues were faced for validation of large numbers like 12345678901 etc. in the past but now this much large numbers are supported by Aspose.Cells. Aspose.Cells has introduced rendering active worksheet in a workbook to SVG. For this purpose load an Excel file into workbook object and set the active sheet index like for Sheet2, set index to 1. Then save the Workbook as SVG which will render active worksheet to SVG. Workbook can have multiple sheets which are rendered as multiple tab pages when converted to HTML using Excel. Similarly if a workbook contains single sheet, it shows one tab page when converted to HTML using Excel. This conversion was working fine for multiple sheets while using Aspose.Cells. However for single sheet workbook, there was no tab page and only HTML file was created without creating the separate folder containing CSS. Now Aspose.Cells has enhanced its library to create similar output for single sheet workbooks as compared to output created by Excel. In complex Excel files (XLSM/XSLB) there can be large amount of macros which can be very very long. Many times there is a need to load the workbooks without loading these VBA projects like just extracting the sheet names from loaded workbook. In this case we need a filter which can load VBA projects in when they are actually required. This time Aspose.Cells has introduced a filter option LoadDataFilterOptions.VBA which can be used for this purpose. Textbox is very common control which can be used in a worksheet. This is not necessary that text in the textbox is fixed. It may have tags which can be replaced with some text at runtime. It helps users to configure the controls as per the data on the sheet or from some other source. Worksheet.replace can be used for this purpose and textbox can be set with the desired text. It can convert worksheet to HTML but rendering entire sheet at once may not be required always. Users may require just a selected area of the sheet to be rendered to HTML. Worksheets contain page setup where print area can be set. A worksheet can have different types of validations including dropdown. There can be a need where user may want to detect the type of validation and take some decision based on this information. This release includes plenty of improved features and bug fixes as listed below

Change returned value for getting Connection points

Provide ability to export range as HTML

Data bars are missing when XLSX is converted to HTML

Value still exists when XLSX is converted to HTML

Convert left right ribbon shape to image

Aspose.Cells for Java JavaDocs - missing package-list file

Font is not a valid HTML5 and self-closing tag and web browsers misrepresent its contents

Wrong count of validation values is read from XLSX

Issue while treating consecutive delimiters as distinct

Date format is incorrect for Japanese locale

LightCells API fails to load huge file

An exception(StackOverFlow) raises when saving to PDF output

Wrong value calculated by ROUNDUP()

Copy a range with PasteType.ALL (Paste options) not copying row heights properly

Hyperlink text formatting lost when new text is set

Invalid Russian date format output

Issue with SheetRender fonts

Exception "java.lang.OutOfMemoryError: Java heap space" when rendering MS Excel file to PDF

Quotes appear in formula when retrieving the cell formula via Aspose.Cells

Performance degradation when using conditional formatting

Chart line is missing in XLSX->PNG conversion

Problem with getActualChartSize method

SmartArt doesn't copy when workbook is copied

Text formatting is missing in HTML output of excel range

Icon Sets become misaligned when XLSX is converted to HTML

Exporting named range data is not correctly rendered to HTML (Java)

Named Range Issue

Validation always returns true for 'getInCellDropDown()' method

Wrong culture custom format gets returned for different locales (Germany, French, Italy and Spain)

Excel To PDF conversion - Gauge chart rendering issue

PDF rendition throws OutOfMemoryError exception

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

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Android documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Recognise self-closing tags

Get Connection points from shape

Overview: Aspose.Cells for Android

Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

More about Aspose.Cells for .NET

Homepage of Aspose.Cells for Android

Download Aspose.Cells for Android

Online documentation of Aspose.Cells for Android

[file-formats-programming]

Control Threshold for TIFF Binarization & Enhanced RTF to DOCX Conversion using Java

What's New in this Release?

Aspose development team is happy to announce the monthly release of Aspose.Words for Java 19.1. It has added new property ThresholdForFloydSteinbergDithering in ImageSaveOptions class to control threshold for TIFF binarization. There are 55 improvements and fixes in this regular monthly release, such as implemented the directed line caps rendering for Bezier curves in metafiles, implemented processing of the stroke properties while rendering custom line caps in metafiles, implemented support of Unicode font names while rendering to PDF, Fixed a bug that prevents rendering of horizontal lines with gradient fill in DrawingML, Fixed a bug when gradient fill is not rotated with DrawingML shapes by default, Fixed a bug that caused an incorrect rendering of DrawingML shapes inside groups when 3D rotation was applied, Fixed a bug with vertical alignment of Ruby objects while rendering, Fixed a bug that caused the creation of extra link tags in output PDF when rendering documents with footnotes, Supported dynamic table cell merging for LINQ Reporting Engine, Supported textual comments within LINQ Reporting Engine template syntax tags, Improved computation of wrap bounds of floating objects which affects position of text nearby, Improved positioning of line when it cannot fit next to floating object and has to be pushed below, Implemented navigation from footnote reference to footnote for PDF output, Fixed exception which may happen when spans are merged in paragraphs with different directionality and Fixed exception which may happen when span has null shading inside text box.  The list of most notable new and improved features added in this release are given below

Add feature to merge table's cell vertically depending upon data structure

Add name to foreach syntax of Linq Reporting

Expose the threshold control for Tiff binarization  

Arrow Heads truncate when converting DOCX to PDF

Make footnote endnote numbers hyperlinks leading to corresponding note entry in main story

Resolved Field code of hyperlink changed after conversion from RTF to DOCX

Footnotes and endnotes references need to be rendered as active links

GroupDocs: native method calls conflict.     

Porting new API examples to Java

Include only Required Java Modules

The text is missing in PDF rendition

Wrong Date Field in Java

DOCX to PDF conversion issue with text wrapping around the table

The scaling of the second vertical axis and the placement of the grey line are changed after converting to PDF

Images are rendering incorrectly/misplaced in Fixed Formats

DOCX to PDF conversion issue with charts' rendering

Extra left margin is added after conversion from HTML to MHT

DOCX to HTML conversion issue with table border

Word to HTML Paragraph Formatting Issue

MHTML to PDF conversion issue with text position

Copied styles don't match the source styles

Shape's contents are lost in output PDF

Border color not modified when changing Accent color

Arrow shapes do not render correctly in output PDF

Incorrect list markers in a RTF document

Font Name Not Properly Embedded in Converted PDF

Text wrapping problems when saving to PDF

Extra empty page is created after conversion from Docx to Pdf

Position of chart is changed in output PDF

Missing Text when converting RTF to PDF

Gradient fill has incorrect direction while rendering rotated DML shapes

How to merge table cells using the Linq engine

DOCX to PDF conversion issue with list label rendering

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Words for .NET documentation that may guide users briefly how to use Aspose.Words for performing different tasks like the followings.

Control Threshold for TIFF Binarization

Replace tag with text in a textbox inside the Worksheet

Overview: Aspose.Words

Aspose.Words is a word processing component that enables .NET, Java & Android applications to read, write and modify Word documents without using Microsoft Word. Other useful features include document creation, content and formatting manipulation, mail merge abilities, reporting features, TOC updated/rebuilt, Embedded OOXML, Footnotes rendering and support of DOCX, DOC, WordprocessingML, HTML, XHTML, TXT and PDF formats (requires Aspose.Pdf). It supports both 32-bit and 64-bit operating systems. You can even use Aspose.Words for .NET to build applications with Mono.

More about Aspose.Words

Homepage Java Word Library

Download Aspose.Words for Java

Online documentation of Aspose.Words

[file-formats-programming]

Update Smart Art Text & Rendering Active Worksheet in a Workbook to SVG using Java

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.11. It contains enhancements and bugs resolution for many of the issues. Smart art is addressed in this release such that text can be updated in the shapes. This feature will enable users to modify these objects at runtime rather than fixed text in the shapes. Last section on this page contains more details and links about this product. Pivot tables are very common reports which are present in the workbooks. These reports are updated time by time and it is important to know the last time when report was updated for better decision making. Aspose.Cells has provided this feature by introducing property RefreshDate. Similarly name of the person who updated the pivot table is also provided as property RefreshedByWho. Smart art is used for better representation of information however earlier the text in the smart art shapes was fixed. This limitation is gone now as now smart art text can be updated. For this purpose shape.setText() function is introduced which sets new text in the smart art shape. Data validation is done in variety of ways to control the input in the Excel file. Like limit can be defined for a cell within which some number can be entered, otherwise error message is raised. Issues were faced for validation of large numbers like 12345678901 etc. in the past but now this much large numbers are supported by Aspose.Cells. Aspose.Cells has introduced rendering active worksheet in a workbook to SVG. For this purpose load an Excel file into workbook object and set the active sheet index like for Sheet2, set index to 1. Then save the Workbook as SVG which will render active worksheet to SVG. There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements includes wrong count of validation values is read from XLSX, Issue while treating consecutive delimiters as distinct, Date format is incorrect for Japanese locale, Aspose.Cells.GridWeb (Java) crashes when using it concurrently in a multi user environment and Resolving issues in getting actual chart size. Below are some important new features, enhancement and bug fixes part of this release.

Wrong count of validation values is read from XLSX

Issue while treating consecutive delimiters as distinct

Aspose.Cells.GridWeb (Java) crashes when using it concurrently in a multi user environment

Chart line is missing in XLSX->PNG conversion

Problem with getActualChartSize method

SmartArt doesn't copy when workbook is copied     

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Render active worksheet in a workbook

Replace text in smart art

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

Homepage of Aspose.Cells for Java

Download Aspose.Cells for Java

Online documentation of Aspose.Cells for Java

[file-formats-programming]

Render HTML with Scalable Column Width & Get Connection Points from Shapes using .NET

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 18.10. MS Excel file formats API that provides the ability to create, manipulate, convert or render MS Excel spreadsheets, and more importantly – is fully documented. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository.It has added a few important features while keeping the product more stable and feature rich API. In this release, It has also added some useful enhancements and resolved a number of issues. Sometimes when some bug or issue is reported, that guides us to provide some new feature or enhancement thus making this product more user friendly and capable of solving complex problems in an easier way. Simple features which become quite handy while working with a complex product are added like providing last saved time property for keeping track of changes etc. Depiction of data through HTML page is very common, however this page can be opened in a variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in “pt” which works in many cases. However there can be case where this fixed size may not be required. For example, if container panel width is 600px where this HTML page is being displayed. In this case you may get horizontal scrollbar if the generated table width is bigger. This requirement is addressed by providing scalable units like em or percent for a better presentation. Empty tags are very common while working with HTML like we can face <td></td> or simply <td/>. Earlier self-closing tags were not supported however now this support is provided. Now you can load any HTML with self-closing tags and convert it to Excel file. Named regions can have English formulae and this file can be used in environments where  systems are configured to German locale. There is need to translate these English formulae completely to German language for correct usage in MS Excel configured for German language. This feature is fully functional and can be used without any extra coding. MS Excel provides custom filters like filter rows which begins with and ends with some specific string. This feature is available in Aspose.Cells and demonstrated by providing working examples.  Aspose.Cells provide rich features to manage shapes in the spreadsheet. Sometimes there is need to get the connection points of a shape for aligning or placing the shapes at appropriate place. For this purpose all the connection points are required. Following code can be used to get the list of connection points of a shape where Shape.GetConnectionPoints() function is used.  There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements , such as Using preferred parser and Handled an exception which occurred when loading an Excel file.  In Aspose.Cells 18.10, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, applying data filtering, manipulating OLE Objects, reading/writing HTML files, manipulating List Objects/Tables, applying auto-fit rows/columns, formatting cells, Smart Markers, manipulating document properties, rendering and manipulating charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release. This release includes several enhanced features and bug fixes as listed below

Get connection points from shapes

Change columns' fixed size width (i.e., pt/px) into scalable unit like "em" or "percent"

Issue with the image source when rendering Excel to HTML file format

Font size changed from 6.5 to 6 while converting XLSX to HTML 

Recognize empty tags like <td /> while converting HTML to MS Excel file format 

Sub-Total missing when rows collapsed after refresh

Issue in number fields while calling the Worksheet.AutoFitColumns()

XLSB file gets corrupt on opening and saving

CSV import creates incorrect formatting using PreferredParsers

"_xll" attached in front of formula name

Named range formula ("=GET.CELL") not properly created in German locale

Escape character is displayed as it is in PDF

PDF output page size(and margins) doesn't match MS Excel output

Height of image in header truncated along with broken layout during XLSM->PDF conversion

Image not repeating properly when print titles are set for rows and columns

Rendering image from a simple chart takes all resources and then raises exception

Accessing visibility properties changed the visibility of the chart in the re-saved output

SourceFullName property of OLE Object is empty while accessing in XLSB

Header picture/shape is not rendered correctly when re-saving an XLSX file

Difference in OLE Objects before and after saving the XLSB file

Phonetic guide missing after copy and save

Resizing tables changes format of cells

Wrong detection of cell foreground and background color

Autofit happens automatically to the hidden rows when rows are auto filtered

Custom scheme 'm-files://...' is converted in document save-operation

XLSB files cannot be opened using LoadDataFilterOption other than LoadDataFilterOption.All

Formula missing single quote

LoadDataFilterOptions.SheetSettings not working for XLSB files

View is changed to protected while converting XLS -> XLSM -> XLS

XLSX file is corrupt after converting from an XML (SpreadsheetML) file

Smart Marker does not evaluate ISBLANK properly

FilterOperatorType.Contains missing from API

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Recognize self-closing tags

Support for German Locale in Named Range Formulae

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

Homepage of Aspose.Cells for .NET C#

Download Aspose.Cells for .NET

Online documentation of Aspose.Cells for .NET

[file-formats-programming]

Disable Pivot Table Ribbon & Applying Text Alignment to Partial Text inside TextBox using Java

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.8. It includes new features, enhancements and bug fixes to supplement the usability of the product and support the developers community. New features are always part of every release to enrich the product. It is very common to apply different alignments to the partial texts in the text box. This feature was having some issues but now it is reviewed and bugs are removed to incorporate proper alignment.   This option allows screen reader software to utilize the text within the PDF file for reading.  You can disable it by applying a change permissions password and deselecting few options in Adobe Acrobat. Same functionality can be achieved using Aspose.Cells for Java now. Pivot table based reports are useful but prone to error if target users do not have detailed knowledge of Excel to configure these reports. In these circumstances organizations will want to restrict users from being able to change a pivot table based report. Common pivot table features like adding additional filters, slicers, fields, or changing the order of certain things in the report are mostly not recommended for every user. On the other hand, these users shall also be able to refresh the report and use existing filters or slicers. Aspose.Cells has provided this ability to developers for restricting users from changing these reports while creating them. For this purpose Excel provides feature to disable pivot table ribbon and same is provided by Aspose.Cells i.e. developer can disable the ribbon which contain controls to modify these reports. Reliability and efficiency is basic requirement by the users for any software product. If some conversion takes too long, sometimes it is required to interrupt this process to return control to the user. This feature is already present but got some performance issues, however we have further improved it and now can be used without any trouble. While working with Excel, pasting rows and columns is very common and this feature was introduced in the earliest versions of Aspose.Cells. However limited paste option was available in contrast to Excel where variety of options are available when we paste data somewhere in Excel. Now Aspose.Cells has provided this feature and you can paste data with multiple options. There are some other enhancements and exceptions part of this new release, such as Hyperlinks not working when referenced from other sheets, Incorrect alignment issue while rendering to PDF, Wrong placement of table data from HTML to Excel file, Depiction of slicer control while spreadsheet to HTML conversion, Improper gradient color rendering to PDF, Improper chart category title display in PDF and Wrong border style for merged cells. Below are some important new features, enhancement and bug fixes part of this release.

Disable Pivot Table Ribbon

Protect workbook and worksheet in ODS file

Interruption issue with saving XLSX file process

Hyperlink not working when referenced from other sheet

Incorrect alignment while rendering spreadsheet to PDF format

Table data shifted to wrong row and column while converting from HTML to MS Excel file format

Chart's image position is wrong in Chrome & FireFox while converting to HTML 

Slicer control is not rendered when converting Excel file to HTML file format

Vertical line at the center of the chart is not drawn properly in the rendered image

Gradient color for negative bubbles is not applying in the PDF output

Chart category title not shown properly in the image

Wrong border style returned for merged cell

Read watermark from Excel file

Property comment contains unnecessary text

Property "revision number" not checked correctly

Macros in the ODS file are not retained in the generated ODS file format

NegativeArraySizeException while converting XLSX to HTML

NumberFormatException raised while loading the HTML file into workbook

NullPointerException exception raised while calling the CalculateFormula

Exception when rendering worksheet to PNG file format

Error in Cell: E22-Invalid formula - exception on opening MS Excel file

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Applying text alignment to partial text inside the TextBox

Pasting Rows/Columns with Paste Options

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

Homepage of Aspose.Cells for Java

Download Aspose.Cells for Java

Online documentation of Aspose.Cells for Java

[file-formats-programming]

.NET Core Support, Setting Precision of Data in Chart Data Labels using .NET

What's New in this Release?

Aspose team is happy to share the announcement of Aspose.Slides for .NET 18.6. In this release we have improved the chart support by adding new features along with resolution of other issues. There are some important new features part of this release, such as .NET Standard/.NET Core support, Setting Precision of Data in chart Data Labels, Support for setting date format for Category Axis Value, Support for setting rotation angle for chart axis title, Switch Data over axis, Setting Chart Marker Options, support of setting Position Axis in Category or Value Axis, Support for showing Display Unit label on Chart value axis and Support for Bubble chart Size scaling. There are some important enhancements and bug fixes also part of this release, such as improvement in quality of generated PDF, The WMF image is corrupted in PDF output, Chart rendering issues in exported PDF, PPTX to PDF – space difference between text and line, When PPTX is converted to PDF, the vertical graphs lines are different, Circles in the output PDF don’t match the source presentation, The chart horizontal axis is corrupted in PDF output, Font styles change to italic when saving presentation as HTML, JpegQuality setting not works when saving PPTX with JPEG image as PDF, Setting chart data value in chart worksheet does not refresh chart and many more. This list of new, improved and bug fixes in this release are given below

.NET Standard/.NET Core support

Support for setting precision of data in chart data label         Featur

Support for setting the date format for Category Axis Value

Support for setting rotation angle for chart axis title

Support for switch Row/Column for chart data

Setting the chart marker options on data points level

Support of setting Position Axis in Category or Value Axis

Support for showing Display Unit label on Chart value axis

Support for setting markers and its properties for particular chart series point

Getting Series Data Point color from Theme

Support for Bubble chart Size scaling

Setting Series Overlap for Clustered Bar Chart

Support for managing visibility of data labels located outside of plot area

Improve slide graph quality

Low quality PDF generated

The WMF image is corrupted in PDF output

When PPTX is converted to PDF, vertical axis of the graph contains additional items.

PPTX to PDF  - space difference between text and line

When PPTX is converted to PDF, the vertical graphs lines are differen

Some spacing is lost in the output PDF

Circles in the output PDF don't match the source presentation

The chart horizontal axis is corrupted in PDF output

Font styles change to italic when saving presentation as HTML

JpegQuality setting not works when saving PPTX with JPEG image as PDF

Setting chart data value in chart worksheet does not refresh chart

Chart data not updating         

The animation synchronization is lost in the output presentation

NullReference exception is thrown on loading presentation

PPT to PPTX conversion result in corrupt presentation due to WordArt text present in slide

Custom Marker image failed to rendered in generated PDF

Shadow effects on text are lost when saving presentation using Aspose.Slides

Paragraph text is not splitted in portions on changing the shadow effect on portion text

WordArt is improperly rendered in generated PDF

Improper vertical axis rendering in generated PNG

Export to PPTX works but PPT fails

Exception on presentation load

XmlException on loading the presentation

Font size changes after saving

Background change color after saving

PPTX to PDF not properly converted

Charts are improperly rendered in generated PDF

Chart changes after cloning

Layout changed while converting PPTX to PDF

Language changed when converting PPTX to PDF

Low quality images generated from presentation

The axis major unit has been changed in generated PNG

Chart title differs from expected

PPTXReadException on loading presentation

Repair message in saved file

NullPointer Exception on loading presentation

PPTXReadException on loading presentation

System.Exception on loading presentation

ODP to PPTX not properly converted

Content moved in generated HTML

PPTX not properly converted to PPT

Saved PPT presentation requires repairing in PowerPoint

Application Hangs while saving PPTX

Conversion process never ends

Argument Exception is thrown in Box&Whisker chart has only 2 categories

etting RawFrame property has no effect for SmartArtShape

Overflow exception on saving if chart data point has blank value

No format validation for images resource

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Slides for Java documentation that may guide users briefly how to use Aspose.Slides for performing different tasks like the followings.

Setting Chart Marker Options

Setting Precision of Data in chart Data Labels

Overview: Aspose.Slides for .NET

Aspose.Slides is a .NET component to read, write and modify a PowerPoint document without using MS PowerPoint. PowerPoint versions from 97-2007 and all three PowerPoint formats: PPT, POT, PPS are also supported. Now users can create, access, copy, clone, edit and delete slides in their presentations. Other features include saving PowerPoint slides into PDF, adding & modifying audio & video frames, using shapes like rectangles or ellipses and saving presentations in SVG format, streams or images.

More about Aspose.Slides for .NET

Homepage of Aspose.Slides for .NET

Downlaod of Aspose.Slides for .NET

Online documentation of Aspose.Slides for .NET

[file-formats-programming]

Specify Individual or Private Set of Fonts for Excel Workbook Rendering inside Java Apps

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.5. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. We also recommend our clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Sometimes users want to display text in Far East language font e.g. Japanese, Chinese, Thai etc. Aspose.Cells provides TextOptions.FarEastName property that can be used to specify the font name of Far East language. Besides, users can also specify the Latin font name using TextOptions.LatinName property. Aspose.Cells allows developers to save the workbook in Strict Open XML Spreadsheet format. For that purpose, it provides the Workbook.Settings.Compliance property. If users set its value as OoxmlCompliance.ISO_29500_2008_STRICT, then the output Excel file will be saved in Strict Open XML Spreadsheet format. Generally, users specify the fonts directory or list of fonts for all the workbooks but sometime, users have to specify individual or private set of fonts for a desired workbooks. Aspose.Cells provides IndividualFontConfigs class that can be used to specify the individual or private set of fonts for users' workbook.  Below are some important new features, enhancement and bug fixes part of this release.

The concurrent conversion to PDF while each workbook has his own private (exclusive) set of fonts

Detect LoadFormat and FileFormatType of XLAM

Pivot Table's formatting and behavior changed after open/save the template file

Spreadsheet (XLS) becomes corrupted after simple load & save

Aspose.Cells breaks iterator interface when calling Iterator.hasnext() twice

Properties values garbled when extracting document properties

The workbook is corrupted after adding a watermarkhttps://goo.gl/chJgCb

Same code executes slower in new releases

Properties are not be extracted in the template file

NullPointerException when adding HTML to a cell

Lines disappeared from chart when XLSX file is re-saved

Exception "IndexOutOfBoundsException" when merging cells in light-weight mode

Exception "java.lang.IllegalStateException: Invalid encoding: null" when loading an XLS file

ArrayIndexOutOfBoundsException occurs on opening an Excel file

"java.lang.ArrayIndexOutOfBoundsException" occurs on opening an Excel file

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Save Workbook to Strict Open XML Spreadsheet Format

Specify Individual or Private Set of Fonts for Workbook Renderi

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

Homepage of Aspose.Cells for Java

Download Aspose.Cells for Java

Online documentation of Aspose.Cells for Java

[file-formats-programming]

Aspose.Newsletter May 2018: Enterprise Applications Development using Aspose Native APIs & Other News

Aspose Newsletter for May 2018 has now been published that highlights all the newly supported features offered in the recent releases. It includes information about business file format APIs for all Major platforms, launching Soon Aspose.3D for Java API to work with 3D formats, work with password-Protected ODT and OTT files in .NET, Java and Android applications, embed all fonts when converting presentation to HTML, add text and Image in AutoCAD DWG files within Java Applications & many more.

Business File Format APIs for all Major Platforms: Build the best applications using Aspose Native APIs

Manipulate Microsoft Word, Excel, PDF, PowerPoint, Outlook, Visio, Project, HTML, Images and 100+ other file formats using Aspose native APIs for .NET, Java, Android, C++, SharePoint, Reporting Services and JasperReports. Developers can easily create, edit, render, print and convert between popular document formats within their own application by adding just a few lines of code. Download Free Trial

Launching Soon: Aspose.3D for Java API to work with 3D Formats

Aspose.3D for .NET is already enabling to work with 3D formats within .NET applications. Now Aspose is ready to launch Aspose.3D for Java that will empower developers to import and export 3D models into the supported formats, access 3D elements for editing purposes and build a 3D model from scratch. They can also build GPU and CAD friendly geometries as well as skeletal animation and morphing. Read more details

Work with Password-Protected ODT and OTT Files in .NET, Java and Android Applications

Aspose.Words now supports working with encrypted OpenDocument Text (ODT) and document template files (OTT) in .NET, Java and Android applications. The OdtSaveOptions class can be used to specify additional options when saving a document into the ODT or OTT format. Also use OdtSaveOptions.Password property to get or set password to encrypt document:

Embed all Fonts when Converting Presentation to HTML

Aspose.Slides now supports exporting presentation to HTML by embedding all fonts used in presentation within .NET, Java, C++, SharePoint, SSR and JasperReports. A new HTML controller EmbedAllFontsHtmlController has been added that is used to embed all presentation fonts in HTML document. Using Aspose.Slides APIs – experience improved chart, text and shapes rendering support in API along with improvement in exported PDF outputs.

Support for Subscript, SmallCap PSD and exporting CMYK PSD to CMYK TIFF in .NET and Java

Using Aspose.Imaging APIs – developers can convert CMYK PSD file to CMYK tiff format within .NET and Java applications. Just load image of any format and then you can set various properties using TiffOptions class and save the image. The new version also supports working with Subscript and adds the SmallCap option parsing and rendering for PSD text layer.

How to: Find & refresh children Pivot Tables and Group Pivot Fields in the Pivot Table?

Aspose.Cells for Android via Java finds the children pivot tables of a parent pivot table using the PivotTable.getChildren() and then refreshes them one by one. You can also avoid exporting various types of Document, Workbook and Worksheet properties while exporting Microsoft Excel files to HTML. Try out fully functional code examples.

How to: Determine Line Break in PDF and Clone TextFragments with Identical Formatting?

Aspose.Pdf for .NET now supports logging (tracking) background processing (line breaking) of multi-line text fragments in text adding scenarios. You can use GetNotifications(), a new method of Page Class in order to achieve the functionality. You can also clone a TextFragment with segments formatting identical to the original fragment, use TextFragment.Clone() method to achieve this. Try out fully functional code examples here.

How to: Renumber WBS Codes of Tasks in a Java Project File?

Aspose.Tasks for Java provides support for renumbering WBS Codes of tasks in a project (associated with tasks like Microsoft Project’s “Renumber” function) and eliminate gaps between tasks list and page footer while rendering project data. Try out fully functional C# code examples.

How to: Control Image Quality Compression during OneNote Document Conversion to PDF?

Aspose.Note for Java adds the capability to control the compression ratio of images during conversion to PDF. It lets you select the image compression type and quality using the SaveOptions class of the API. Image quality can be set from 0 to 100 using the JpegQuality property of SaveOptions. Try out fully functional code examples

How to: Add Text and Image in AutoCAD DWG files within Java Applications?

Aspose.CAD for Java announces plenty of new features related to: adding text in DWG file, exporting DWG entity to image, saving DXF files and importing image to DWG file. Try out fully functional code examples.

How to: Display Geographic Data by Google Earth within .NET applications?

Aspose.GIS for .NET now support KML file format that is used to display geographic data by Google Earth. Developers can create or read KML files, add attributes as well as features to it using the API. Try out fully functional code examples

Updates about new Product Releases

Aspose.Total for .NET - a compilation of Aspose latest .NET products

Aspose.Total for Java – a compilation of Aspose latest Java products.

Aspose.Total for Android – all the latest versions of Aspose Android APIs.

Aspose.Total for SharePoint – a compilation of Aspose latest SharePoint products.

Aspose.Total for Reporting Services– a compilation of Aspose latest Reporting Services products

Aspose.Total for JasperReports – The latest versions of Aspose JasperReports products.

Aspose.Total for C++ – The latest versions of our C++ products packaged into one product suite.

Aspose.Words for SharePoint 18.3 – Improved reflection effect for 3D rotated WordArt objects and rendering of DML charts in Word documents.

Aspose.Pdf for .NET 18.3 – Improved Image Quality in PDF to HTML Conversion and Repeating Column in Table.

Aspose.BarCode for .NET 18.3 – Improved recognition of barcode from image and from PDF file.

Aspose.Pdf for Java 18.3 – Improved and Enhanced Java Library to Create and Manipulate PDF Documents.

Aspose.Words for Java 18.3 – Fixed issues related to incorrect page number in exported Word document.

Aspose.Email for .NET 18.3 – Introduced the capability of setting the participant status of a meeting that lets you add the same information to output ICS file in the form of PARTSTAT property.

Aspose.Diagram for .NET and Java 18.3 – Move page position in Visio drawing and enhanced export of Visio drawing to XPS.

Aspose.Tasks for .NET 18.4 – Improved project recalculations and extended Aspose.Tasks collections to support BCL collection interfaces.

Aspose.BarCode for Java 18.3 – Enhanced barcode generation process in this release.

Aspose.3D for .NET 18.3 – Enhanced texture-transparency and retrieval of entity bounding box among 3D file formats.

Aspose.BarCode for JasperReports 18.3 – Fixed issues related to evaluation message displayed when customer is using a free version of Aspose.BarCode API.

Aspose.HTML for .NET 18.4 – Enhanced support for rendering HTML files to image files in .NET

Supporting User Groups and Conferences

Aspose is sponsoring a number of user groups and upcoming events, including:

April 21: Brisbane Global Azure Bootcamp – Brisbane, Australia

April 21: Global Azure Bootcamp – Singapore

May 22 – 23: de:code Japan – Tokyo, Japan

Sponsor a user group? Get in contact: user.groups@aspose.com

Collect a copy of Aspose Newsletter, February 2018 edition

Collect the English version of this newsletter