data conversion - Aspose.Cells for .NET

  1. Aspose.Cells for .NET V8.9.1 released

    Release Notes: fonts in the PDF. Result of CalculateTextSize is always the default height if text in a TextBox contains new lines. Chart is not correct in the sample2.xlsx (Excel to PDF conversion). Data Tables ... are not correct in the sample2.xlsx (Excel to PDF conversion). Data Tables are not correct in the sample1.xlsx (Excel to PDF conversion). Modified radar chart marker does not convert to PDF properly. Horizontal ... Numbers formatting (DateTime) lost when importing data from DataGrid (.NET). Chart copied with CopyRows still reference the source worksheet in Chart Data Range. Colspan as 2 increases the HTML loading ...

  2. Aspose.Cells for .NET V16.12.0 released

    Release Notes: refreshing Pivot Table. Column is missing in Pivot Table after refreshing and conversion to PDF. Data is missing in Pivot Table after refreshing and conversion to PDF. Spreadsheet containing slicers gets ... is used on Workbook. Unable to save source Excel file into HTML and it gets time out. Pivot Table formatting is lost while converting spreadsheet to PDF file format. Row data is misplaced while rendering ... to convert XLS to XLSX is high. PDF export displays 0 on stack charts. Issue with chart's data series in Excel to PDF rendering. Image of the chart with title Life is not correct. Series DataLabel value ...

  3. Aspose.Cells for .NET V9.0.0 released

    Release Notes: with Spreadsheet to HTML conversion: STYLE tag between BODY and HTML tags. ICustomFunction doesn't work with [columnName]. Wrong SUM displayed when calculating formulas. API incorrectly calculates the formula ... value as compared to MS Excel. Wrong calculation of the cell value. Wrong value from cell when calculating formulas. PDF result does not match with Excel for printing title rows. The data is hidden ... in the conversion result of PDF. Rendering to image file fails for a worksheet. Spreadsheet to XPS: Process never completes and takes too much memory. Sparklines are not rendered right while rendering spreadsheet ...

  4. Aspose.Cells for .NET V18.2

    Release Notes: Microsoft Excel when wrap text is enabled. Image properties (Title and Subject) are lost in Shape to image conversion. Inverted characters in labels when converting Excel to PDF. Some column data is not fully ... WorkbookSetting.StreamProvider to control external resources. Unsupported external stylesheet during round trip conversion. DDE link is not present inside Worksheets.ExternalLinks. Aspose.Cells.GridWeb does not enter text like ... of an external link is changed after open/save. Unable to read Excel data connection when its type is CSV. PrintTitleRows property value disappears after open and save by Aspose.Cells. Special characters used ...

  5. Aspose.Cells for .NET V17.9

    Release Notes: lines (single, double underlines) in Excel to PDF conversion. When ImageOrPrintOptions.OnlyArea = true, the data gets corrupted. Partially missing characters when converting to image. Default grey cell ... ZipOutputStream.Enable Zip64" on merging file(s). Lost Track Changes after conversion of XLS to XLSM. When RecommendReadOnly is true, IsWriteProtected is also true. GridDesktop should not scroll past last column ...

  6. Aspose.Cells for .NET V17.8.0

    Release Notes: fields are not correctly opened from SpreadsheetML. Data Validation in the output Excel file is not working. Embedded objects/images are not rendered in Excel to PDF conversion. Some shapes are displaced ... the output file. Position of shape text is wrong in the output PDF - Excel to PDF conversion. Diagrams not rendered correctly in Output Pdf. Issues with rendering shapes in Sheet to image conversion. Text ... Alignment issues when saving an XLS file as HTML by Aspose.Cells APIs. Text being cut when rendering Excel sheet to Image. Redundant line appeared while rendering shapes in Sheet to image conversion. Cells ...

  7. Aspose.Cells for .NET V18.3

    Release Notes: Group pivot fields in a Pivot Table. Group pivot fields in a Pivot Table. Exception during backward HTML-to-Cells conversion. Add property to the StyleFlag to not override the QuotePrefix value. ... ActiveX control becomes a picture when copying a sheet from one workbook to another. Data validation - GridWeb should display a dialog with an error message. Workbook.CalculateFormula hangs infinitely when ... is different in converted image. Conditional formatting not applied while converting Excel file to PDF. Unwanted borders appear around the image when Excel file is saved to PDF. The cell reference for the data ...

  8. About Aspose.Cells for .NET

    Description: spreadsheet files from within their own applications. A combination of APIs and GUI controls - Aspose.Cells for .NET speeds up Microsoft Excel programming and conversion. The Excel spreadsheet API gives ... developers powerful tools for performing simple file conversions or more complex tasks. Developers have control over page layout, formatting, charts and formulas. They can read and write spreadsheet files ... to a client browser. Import and export data from a DataTable, DataView or Array. Import images and charts. Create images and charts through the product API. Import formulae from a designer spreadsheet. ...

  9. Aspose.Cells for .NET V18.4

    Release Notes: Added FilterMode property. Added support for additional cell modification in cellModifiedOnAjax. Process standard LINK elements during backward conversion. Excel to PDF rendering - header/footer problem. ... in output PDF. Incorrect formatting when saving XLSX as HTML. Missing values in chart. Cannot remove PivotTables (whose data source is external) from XLS file format. Excel file becomes corrupt after ... with custom data filtering. During save OriginalDataSource with slash changed to backslash. Images and diagrams are missing when saving OTS file. ListFillRange in ActiveX ComboBox not updating. Page header rows ...

  10. Aspose.Cells for .NET V8.8.3 released

    Release Notes: spreadsheets with Protected View. Change character spacing in Excel Textboxes. Support for "WithoutChart" loading option. Supports grid-lines for Excel to HTML conversion. Add Comment Property ... to ListObject/Table. Use Array Formulas in Smart Markers. Apply table styles to rich text settings. Performance problem in Cells.CopyRows() method. Problem with PivotItem.IsHidden when refreshing data. Export Html ... to HTML. Cannot export all HTML content to Excel when the HTML has nested 'div' elements. Issue with Custom time format. Issue regarding unsupported chars indices in CHAR formula. Conversion to PDF ...

  11. Aspose.Cells for .NET V17.10

    Release Notes: Set the number format for cells in a Chart's data table. Set the number format for cells in a Chart's data table. Read Excel worksheet Sheet IDs. Read and write XLSB file via an external ... 2016 - Add-in pane removed from file after open/save. Worksheet is not protected in SpreadsheetML to XLSX conversion. Document is corrupted when re-saving. Styles seem to be carried over wrongly for some ... cells in SpreadsheetML to XLSX conversion. Date column is not sorted correctly. Worksheets protection properties are not carried from SpreadsheetML. SpreadsheetML AllowSort element doesn't work ...

  12. Aspose.Cells for .NET V17.3.0 released

    Release Notes: cells only and ignore validation of other cells. Change in pivot data source adds additional LinkSource. The shape is skewed/tilted with its text "1" position changed. Text in a shape ... format. Font style and size is changed after importing HTML as XLSX. Refreshing the pivot table after adding some data generates corrupt Excel file. Error in Refresh of Pivot Table grouped by Date column. ... Pivot Table's merge labels feature does not work. Alignment doesn't work and text go out of the cell in Excel to HTML conversion. Conversion of HTML to XLSX is not correct. Some pivot field ...

  13. Aspose.Cells for .NET V16.11.0 released

    Release Notes: is losing filters after RefreshData call. PivotTable fails to refresh after changing data source to a Named Range. Calling PivotTable.CalculateData() causes a crash when there is 1 data column. Excel file ... Long values in cell renders as '#' string while converting worksheet to image. Issue with the size of the converted file (Excel to PDF Conversion). Considerable increase in the output PDF file ... with updating External Link's data source and AbsPath. Font of Chart Data labels and Legend is changed on opening and re-saving source Excel file. Unable to update address of a GridHyperlink. Set alternative ...

  14. Aspose.Cells improves Data Filters support

    Release Notes: properties added. Cell background colors with conditional formatting. Pivot Table data filters supported. Advanced data validation. Support for reading and writing MHT files. Support for XML maps. ...

  15. Aspose.Cells for .NET V18.7

    Release Notes: or List<ExpandoObject> as DataSource for importing data into worksheet. Added WorkbookSettings.MaxRow and WorkbookSettings.MaxColumn properties. Added WriteProtection.Author property. Round images become square images ...

  16. Aspose.Cells for .NET V18.6

    Release Notes: are dispersed. Displaced image when converting XLSM to PDF. Unable to extract smart art images correctly. Shape is displaced to cover data in Excel to HTML rendering. All previous column and row data remains ... disappear from the formula when opening file. Formulas (containing linked data source in other workbooks) are not calculated. Print from Aspose.Cells differs from Excel. PDF output ignores all page breaks ... in MS Excel file but it renders in PDF. Chart horizontal axis label is corrupted. Saving XLT file as XLS after clearing chart's data series causes red "Protected View" warning. Watermark ...

  17. Aspose.Cells for .NET V18.5

    Release Notes: drawing objects are too narrow in the output file when re-saving an XLSX file. Returns blank PDF when saving a SpreadsheetML file as PDF. Data loss occurs while converting ODS to XLSX file format. Named ... formattings. Unable to open XLS file as it throws exception while loading. Exception "Invalid formula:"'New' Name'!G11:G15"." when refreshing pivot chart data. Exception when ...

  18. Aspose.Cells for .NET V17.12

    Release Notes: Issue with displaying worksheet data right to left. Error when clicking scroll bar on Aspose.Cells.GridDesktop. Shape to Image error occurs while converting Excel file to PDF. Exception on opening ... an Excel (Strict Open XML Spreadsheet) file. Index was outside the bounds of the array - Exception while rendering Excel file. You must enter data for validation criteria - exception occurs while saving ...

  19. Aspose.Cells for .NET V17.11

    Release Notes: Added support for PasteType during Copy/Paste actions.   Scale becomes smaller - fonts issue. Unable to read Smart Art shape text. Pivot table is taking too long to refresh data. Direction of shape ... to the right. Position of line objects changed while rendering spreadsheet to PDF. Missing total values for the calculated fields when refreshing/calculating PivotTable data. Error expanding data to proper ...

  20. Aspose.Cells for .NET 17.7.0

    Release Notes: Render Pivot Tables in the GridDesktop component. Added support for errors and Boolean values in Russian locale in Excel to PDF rendering. Read cell data, formulas and styles from a numbers file. ... of GridDesktop on runtime. Application gets stuck while trying to get picture's property. Arrow shape is not rendered fine in Sheet to Image (.jpg) renderings. Chart data is unable to refresh data from Pivot ... Table. Excel file corrupted when adding PivotTable after importing source data. Formatting error when Excel file is converted to HTML. Cell.DisplayStringValue does not match with the original values. ...