data conversion - Aspose.Cells for .NET

Release Notes: Adds support for For CSV to JSON conversion. Added support for CSV to JSON conversion. Added new PivotTable.ExternalConnectionDataSource property which returns an external connection referred ...

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

Release Notes: the data connections details got deleted. XLS to XLSM conversion- MS Excel could not open the output XLSM file. Dynamic array formula does not populate spilled cells. Some formulas are not calculated ... properties lost. Input document stream is prematurely disposed after creating Workbook for particular file. XLS worksheet has no data while you can see filled rows in Excel. XLSB to XLSM conversion- the output ... Adds support for discrete grouping of data in XLS files. Added support for discrete grouping of data in XLS files. Added support for preset settings for gradient fill. Added support for setting ...

Release Notes: PDF if object covers more than one page. XLS to PDF: Chart EMF image not rendered. HTML to XLSX: Some styles are not shown properly. Excel to HTML conversion- some data columns are shifted ... Adds 'CalculationOptions.LinkedDataSources' property which allows the user to set linked data sources in calculation formulas. Text shadow effect disappears when saving file to PDF. The text ... SessionModes not work. Incorrect margins for XLSX to PDF conversions. Text box is not visible when converting XLSX to PDF. Merged area missing border when saving file to PDF. Zorder was not respected when saving ...

Release Notes: to Cells class. Various formatting and other shapes rendering issues in PDF and HTML of Excel file. Some shapes are not rendered properly in Excel to PDF conversion. Invalid value for external reference ... in DataSource field of Pivot Table. Regression: CSV to PDF conversion not working. Empty CellsArea array returned for CSV/TSV files. Finnish language- Numbers formatted as Percentage are missing the space before ... the percent symbol. Aspose.cell failed to collect workbook revision logs. Missing page after conversion of an Excel file to PDF. Cell type is wrong after exporting to html and reloading the exported html. ...

Release Notes: then viewing in Excel. Links in named ranges are getting deleted in XLS to XLSM conversion. Files got corrupted and external Link changed to DDE link when converting XLS files to XLSM. Converting XLS files ... with xlAlternateStartup type link to XLSM is outputting corrupted files. Duplicate data of smart marker. A textbox having two columns in it is rendered with one column only when re-saving an XLSX file. An external link ... of type xlPathMissing is changed to normal externalLinkPath type in XLS to XLSM conversion. Very long names for image type resources while saving as Html. Specific XLSM file cannot be loaded. RibbonXml does ...

Release Notes: conversion. XLSX to PDF rendering issue. Data labels on Scatter chart are not rendered correctly in the output image. Excel to PDF conversion is creating different chart in Windows 10, Windows Server 2008 ... via PivotField in row area, column area and data area. GridWeb- You can now run formulas similar to GridDesktop feature. Added GridWeb rows and columns grouping feature. Added the ability to preserve ... while converting from HTML to XLSX. Smart Art pictures in XLS are incorrectly displayed after converting to HTML. Issue of rendering shapes in Excel to PDF conversion. Callout position is changed while ...

Release Notes: Workbook.ExportXml returns only first row of Table data. Xml Import unhides previously hidden columns in template. Content is not rendered properly in Excel to PDF conversion. Wrapped Texts do not work on Charts when ... generating PDF. Horizontal axis labels of chart are not rendered properly in the output PDF. Issue with Collapse and Expand multi level groups. ODS to PDF conversion incorrect. Custom “Text” formatting ... number cannot be zero when importing JSON data as table. ArgumentOutOfRangeException while trying to get Formula of a cell. ...

Release Notes: 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 corrupted ... 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 spreadsheet ... 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 and percentage showing ...

Release Notes: and linked data). Incorrect rendering of rotated shapes in Shape to image conversion. Pivot Table breaks when deleting rows and columns. Pivot table filters are cleared after load and save. Issues in embedded ... Adds new method to give richer data including external references and linked data. Added Name.GetReferredAreas (Boolean recalculate) method to give richer data (including external references ...

Release Notes: by System.Windows.Xps.Packaging.XpsDocument. Cannot generate SVG with superscript and subscript from Excel file. Text is lost in the converted XPS document. Data loss in saving a pivot table chart. Difference in character/text position when ... rendering the selected worksheet to HTML. Conversion to DOCX produce one extra blank page. Problem to open PowerQuery after change. Converting Numbers to PPTX produce broken result. HTML to Excel conversion ...

Release Notes: the data source range of the chart. SmartArt shapes are not rendered fine in Excel to PDF conversion. Shapes are not positioned correctly in Excel to PDF conversions. Arrow graph is incomplete. Diagram ... Adds support for Microsoft.NET 5.0. Added support for Microsoft.NET 5.0. Added the ability to switch row/column data series. Added OleObject.SetEmbeddedObject() method. Added the ability to get ... as data source of chart. Wrap Text not working for ODS files. Pivot Table Group By day is increasing when refreshed. Error while converting XLSX to PDF on Azure. Issues while inserting attachments in Excel ...

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

Release Notes: Remove method SetDataSource(string variable, object[] dataArray) method. Issue with retrieving Linked OLE attachments in ODS file. Excel to Tiff conversion issue. Issue of exporting JSON string to Excel. ... document properties after being saved to ODS. Disable keyboard copy/paste in GridDesktop. Font becomes bold during Excel to PDF conversion. Cell background lost after converting to html. Converting Excel ... height wise. Chart to Image- not rendered correctly. XLS to XLSX conversion changes the two-color gradient of conditional formats. The width of auto-fitted columns is not correct if cells are merged. ...

Release Notes: file. Aspose.Cells.GridWeb SessionMode not working. Excel to XPS conversion: link is not clickable after conversion done.NET. Lines became dotted on data bars in Emf/OfficeCompatibleEmf. Fonts difference ... Improves performance when writing ODS files. Added support for rendering Microsoft Excel 2016 Box and Whisker charts to an image. Added the ability to delete pivot tables while preserving data ... spacing when converting from XLSX workbook to EMF. Chart sometimes does not appear based on legend position. Miss Legend entry in the output SVG of Excel chart. Error in modifying data label color. Chart ...

Release Notes: data from right to left and bottom to up. Show the active sheet background in the bottom tab bar. Support for reading and writhing the min and max value of a pivot field in XLSX. SetDynamicArrayFormula ... with large content generates corrupted XLSX. Image orientation is different after Excel to PDF conversion. Fails in converting SVG to image. Comment text color is missing when saving file to PDF. ... Aspose.Cells.Drawing.TextBox AutoSize issue. DataSorter sorting not working when sorting from right to left. The SEQUENCE formula cannot obtain the correct values after copying the range. Some Excel functionality (data ...

Release Notes: not render text in docker enviroment. Borders are missing in Aspose EMF/OfficeCompatibleEMF converted from XLSX. Wrong conversion of double underline accounting formatted cell when saving to PDF. Data Labels ... Adds support for updating display icons in embedded JPG, ZIP and MSG objects. Added support for column percentage display to PivotTable. You can now use LightCells API with XLSB files. Updated data ... not displaying properly when saving. Data Labels Not Correct. Strange behavior (and differences) with Treemap chart (and other advanced charts). Threaded Comments are not transferred with the Enclosing shape. File ...

Release Notes: Cell.HtmlString. New worksheet is missing mc:Ignorable="x14ac xr xr2 xr3”. Conversion complex XLSM to HTML takes a lot of time. Invalid markup with unopened closing SPAN tag is produced while converting Cells ... rendering. Conversion of HTML to XLSX does not respect styling of the HTML table. Images are aligned incorrectly when importing file to HTML. Images are over lapping the text when importing HTML to Excel. ... Unencoded quotes in values of HTML attributes. Differences while converting Excel to HTML. Series’s value is not correct after refreshing pivot data. Incorrect PPMT formula execution result. Inserting column ...

Release Notes: overflow content is not always rendered in GridJs. Arrow Shapes placed incorrectly after conversion to HTML. Arrow Shapes placed incorrectly after conversion to PDF. Text is upside down in some shapes- Excel ... to PDF conversion. Letters in the shapes become upside down in Excel to PDF conversion. RadioButtons are not displayed correctly in PDF and HTML. Tildes in a CONCATENATE function are turned into commas. ... references not shifting when rows are imported. XML Import does not preserve column widths. Excel TIFF generation takes too much time. PDF conversion is making a few extra empty pages. The header and formats ...

Release Notes: Optimizes memory performance. Tab name now available when single sheet workbook is converted to HTML. Control the loading of VBA data using LoadDataFilterOptions. Optimized memory performance: ... release original stream after loading Workbook. Tracked Changes lost during conversion from XLSB to XLSM and XLS to XLSM. Text moved after ungrouping a shape when saving an XLS to XLSX. Gridlines ... not displayed in some sheets while converting XLSX to HTML to XLSX. Formattings lost in HTML to XLS rendering. MHT to XLSX conversion- cell content problem. MS Excel prompts an error when opening the output file. ...