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 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 ...

  5. 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 ...

  6. About Aspose.Cells for .NET

    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. ...

  7. 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 ...

  8. 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 ...

  9. 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 ...

  10. 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 ...

  11. 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. ...

  12. 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. ...

  13. Aspose.Cells for .NET 17.6.0

    Release Notes: Adds support for new Office 365 functions. Enquote all attribute values in HTML. Support for new Office 365 functions. Support a table as the data source of a chart. Copy PageSetup settings from ... are not shown or removed in the output file. Generated chart's image is incorrect. Custom sorting is lost when saved to XLS by Aspose.Cells APIs. Data sorting is not working on DataSet (having formulas) ... in the worksheet. Cell border issue in Range.ApplyStyle() method. An embedded object in Sheet2 missing and scaling is wrong. Data validations end up strange after inserting new columns. Data validation issue - Value1 ...

  14. Aspose.Cells for .NET V17.5.0

    Release Notes: for worksheets. Support for exporting HTML cell data to DataTable. OutOfMemory error during image rendering. Converting XLS to SpreadsheetML having filters corrupts the output file. Saving Excel to PDF rotates ... on loading an HTML file. Pivot table data is not refreshed correctly. Workbook calculation method is unable to calculate XIRR formula. Values in cell M114 and N114 are not correct after Workbook formula ... rendering an Excel file to PDF. Converted from ODS to XML (SpreadsheetML) file is not opened by MS Excel. Cell.HtmlString does not highlight the nested font color properly. Data validations end up strange ...

  15. Aspose.Cells for .NET V17.4.0 released

    Release Notes: 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 ...

  16. Aspose.Cells for .NET V17.2.0 released

    Release Notes: Added undo/redo feature to SortRange. Added Split Panes feature to Aspose.Cells.GridDesktop. Auto-rename duplicate column names while exporting data to a DataTable. New utility method to retrieve all ... from Excel and Aspose.Cells. ToTiff function Issues - Extra column is displayed. ToTiff function Issues - Loss of Data. Chart loses formatting of labels after Workbook.Copy. Graph value is different ...

  17. Aspose.Cells for .NET V17.1.0 released

    Release Notes: Improves data binding and performance. Bind Worksheets to a Customized Collection object. Bind Worksheets to a DataSet object at Run Time. Improved performance of PivotTable.RefreshData. Improved ... as outline only rather than filled characters while converting spreadsheet to PDF. Resizing the ListObject in XLSM with external data range makes the result corrupted. This WordArt watermark is not printed ...

  18. Aspose.Cells for .NET V8.8.0 released

    Release Notes: Updates in V8.8.0 Prohibit the conversion of long numeric values to exponential notation while importing from HTML. Detect leading single quote marks in a cell. Get target or output cell address ...

  19. Aspose.Cells for .NET V16.10.0 released

    Release Notes: the same list. Resultant spreadsheet cannot be loaded in MS Excel. Load from HTML ignores bold style from style block. Calculated value of cell D5 is wrong. Excel To PDF Conversion - Number of pages ...

  20. Aspose.Cells for .NET V8.9.0 released

    Release Notes: converting spreadsheet to HTML. Pivot Field's dropdown is missing after re-saving XLSX as XLSB. Spreadsheet becomes corrupted after re-saving XLSX as XLSB. Refreshing and Calculating Data on existing ...