Version History

v7.22.1

v7.22

• New : Suspended Lazarus support

v7.21

• New : Support for exporting Persian to PDF

v7.20

• New : Support for creating your own cultures when rendering Excel files
• New : Support for Delphi 12
• New : Improved Lazarus support

v7.19.1

v7.19

• New : New property FlexCelSVGExport.Encoding allows you to change the encoding when generating SVG files

v7.18

• New : Support for the new Excel2023 default format including the default aptos font
• New : New property TExcelFile.PrintErrors allows to directly manipulate how to print the errors in formulas inside the sheet
• New : New property TExcelFile.PrintComments allows to directly manipulate how to print the comments
• New : New properties TExcelFile.PrintOptionsInitializedFromPrinter, TExcelFile.PrintOverThenDown and TExcelFile.PrintDraftQuality
• New : FlexCel can now render error in formulas according to the printer settings
• New : FlexCel can now render comments "As displayed"
• New : Added new units FlexCel.VCLSupport, FlexCel.FMXSupport, FlexCel.LCLSupport and FlexCel.SKIASupport to replace VCL.FlexCel.Core, FMX.FlexCel.Core, LCL.FlexCel.Core and SKIA.FlexCel.Core respectively

v7.17

• New : Now FlexCel preserves digital signatures in macros
• New : New property DeleteEmptyBandsFixed in FlexCelReport controls what to do with empty fixed bands
• New : Improved the experimental Lazarus support
• New : Improved API for defining columns in tables

v7.16

• New : Support iOSSimulator Arm64

v7.15

• New : You can now run reports on TList like TList
• New : Support for functions TEXTBEFORE, TEXTAFTER, TEXTSPLIT, HSTACK, VSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, and EXPAND
• New : Support for functions MAP, REDUCE, SCAN, MAKEARRAY, BYROW, and BYCOL
• New : Support for functions FILTER, SORT, SORTBY, and UNIQUE
• New : New SHEET VISIBLE tag that allows to change the visibility of a sheet in a report
• New : Experimental Lazarus support
• New : Ability to change the newline separator when exporting to CSV or Fixed-lenght text files

v7.14

• New : Support for optional lambda parameters
• New : Support for bubble charts
• New : New CustomizeChart event for reports
• New : New <#Swap Series> tag for reports
• New : IsOmitted function support

v7.13

• New : Support for the "Black and white" printing option in Excel
• New : Support for office 2021
• New : Support for Radar charts
• New : New convenience method LoopOverUsedRange that can be used to loop over a range of cells
• New : Ability to set the bottom row when specifying an autofilter

v7.12

v7.11

• New : You can now read and write the links of a camera object
• New : Support for RAD Studio 11
• New : New overloads of methods for getting image information that take objectIndexes instead of imageIndexes
• New : New methods to convert between imageindexes and objectindexes with support for grouped shapes

v7.10

• New : Support for recalculation of function NUMBERVALUE
• New : Support for SVG images embedded in xlsx files
• New : Now when exporting to HTML and SVG, the SVG images stored inside the file will be embedded as SVG
• New : Includes in reports can now be FIXED
• New : Full Window management via API
• New : Ability to set shape effects like glow or shadow with the API
• New : Ability to link shape text to cells via the API
• New : Ability to add chart sheets with the API

v7.9

• New : The property LabelValues in IDataLabel changed from TArray to TArray
• New : TXls3DRange now supports an external filename
• New : Support for using an expression like <#joinedtable.tablejoined.\*> to make a generic report in only one of the joined tables
• New : Support for rendering multi-level labels in category axis
• New : Support for legend keys in chart labels
• New : Support for functions SINGLE, VALUETOTEXT and VALUETOARRAY
• New : Support for functions LAMBDA and LET
• New : Support for "Label contains Value from range" option in charts
• New : Hyperlink Base support

v7.8

• New : Support for reading fonts from the disk even if the graphics library returns that information

v7.7

• New : When copying a sheet to a different file, ImageCount in the target file would return 0 even if there were images.
• New : Improved support for camera objects. A new property [MaxNestedCameraObjects](://@api/FlexCel.Core/TFlxConsts/MaxNestedCameraObjects.html) allows to specify how many times a camera object can recursively draw itself.
• New : FlexCel wouldn't allow some unicode characters in 3d formulas, while Excel would allow them.
• New : FlexCel could not read some files with deleted what-if tables.

v7.6.4

• New : New syntax for ALIAS DataSets
• New : New "COUNT" parameter in <#Aggregate> tag

v7.6.2

v7.6.1

• New : Support for Rad Studio 10.4 Sydney

v7.6

• New : Support for rendering logarithmic charts
• New : Support for Rad Studio 10.4 Beta

v7.5.1

v7.5

• New : Support for importing bullet lists when importing html
• New : Support for calculating the upcoming XLookup, XMatch, RandArray and Sequence functions
• New : Support for adding charts to a sheet with the API (xlsx files only)
• New : Preserving and adapting single cell mappings in XML Maps in xlsx files
• New : Now SetSeries and AddSeries, DeleteSeries work also in xlsx charts
• New : New set method in the properties PlotArea, Background in ExcelChart
• New : New methods SetTitle, SetOptions, SetChartLegend, SubchartCount, GetSeriesInSubchart, SetSeriesInSubchart and AddSubchart in ExcelChart

v7.1.1

• New : New __ALIAS postfix in named ranges allows multiple ranges to the same database

v7.1

v7.0

• New : The <#evaluate> tag in reports can now evaluate a string multiple times
• New : Support for semantic theme colors
• New : Support for rendering charts inside xlsx files
• New : Support for creating or reading xlsx files with uncompressed size bigger than 4 Gb
• New : Support for Delphi Rio 10.3.2 including the new macOS 64 platform
• New : New overloads for DeleteSheet allow to delete a sheet by its name or index
• New : Most properties in TDrawingRichString are now nullable
• New : Improved compatibility with "Autosave" in Excel 2019
• New : GetHtmlFromCell now can add the cell formatting to the resulting string
• New : FlexCel will now generate "faux" bold and italics when exporting to PDF
• New : Ability to specify different fallback fonts for italic, bold or bold-italic variants when exporting to PDF

v6.26

• New : In Reports now you can reference tables which include dots by writing <#[db.something].field>

v6.25

• New : New parameter in ATLEAST tag in reports allows for the number of rows of a dataset to be multiple of a number

v6.24

• New : TFlexCelDocExport now uses a different way to share files in Android
• New : New methods SetRange3DRef and TrySetRange3DRef in TXls3DRange
• New : Cell indent is now printed and rendered to pdf/images proportional to the print scale

v6.23

• New : Support for Delphi 10.3 Rio added
• New : Now you can find see the call stack in circular formula references when you call RecalcAndVerify
• New : Now there is support for calculating function RANK.AVG
• New : New methods UnshareWorkbook and IsSharedWorkbook in ExcelFile
• New : New method PivotTableCountInSheet in ExcelFile

v6.22

• New : Support for Excel 2019
• New : Reports now can use tables as datasources
• New : New method to rename tables
• New : New Debug mode for Intelligent Page Breaks

v6.21.6

v6.21.5

v6.21

v6.20

• New : New overloads for methods SetCellFromString and GetStringFromCell now accept cell references
• New : New overload for method TPartialExportStart.SaveCss which allows to save the css without the tags
• New : Full support for reading and writing Data Connections in xlsx files

v6.19.5

• New : The XlsChart object now returns the 3D properties for xls charts
• New : Now functions CUMIPMT and CUMPRINC are supported when recalculating
• New : New methods GetTokens and SetTokens in ExcelFile allow you to parse arbitrary text

v6.19.0

• New : Support for Khmer language when exporting to pdf

v6.18.5.0

• New : New convenience methods SetCellValue(cellRef, value) and GetCellValue(cellRef)

v6.18.1.0

v6.18.0.0

• New : Support for default CryptoAPI xls encrypted files
• New : Support for Rad Studio 10.2.2
• New : Full support for manipulating XML Mappings in xlsx files

v6.17.5.0

v6.17.4.0

• New : New SubtotalDefaultEnglishString command

v6.17.3.0

• New : New TFlxNumberFormat.PercentCount method

v6.17.2.0

v6.17.1.0

v6.17.0.0

• New : Support for reading and writing Strict Open Xml files
• New : Full Support for Excel tables in xlsx files
• New : Ability to add autoshapes to charts

v6.16.0.0

• New : User defined formats in reports
• New : New methods TUIFont.CreateFromMemory and TUIFont.CreateFromFile
• New : Added recalculation support for new functions

v6.15.0.0

• New : Ability to check and evaluate data validations

v6.14.0.0

• New : Support for Web Addins, either of Content or Task pane types
• New : Support for Table Slicers
• New : Support for RAD Studio 10.2 Tokyo including full Linux support
• New : Now you can specify multiple folders with fonts when exporting to pdf
• New : New static method `CreateKeepingAspectRatio` in `TClientAndhor` allows you to fit an image inside a range of cells maintaining the aspect ratio of the image
• New : New method SetTable allows to modify existing Tables
• New : New DrawBorders method in TExcelFile allows to quickly draw a border around a range of cells

v6.13.2.0

• New : Support for losslessly rotated JPEG images
• New : Support for drawing mirrored images when rendering
• New : New method TCellAddress.DecodeColumn

v6.13.1.0

• New : New method TXlsFile.AddAutoShape to add autoshapes with the API

v6.13.0.0

• New : Support for rendering Right-To-Left sheets
• New : New static property FlexCelConfig.DpiForReadingImages

v6.12.0.0

v6.11.0.0

• New : While it is invalid to write a file with conditional formats or data validations with formulas that refer to other sheets, Excel can load them (but you won't be able to modify them). Now FlexCel can read those too without reporting an error.
• New : Support for Excel tables in xlsx files
• New : Support for Delphi Starter
• New : New properties `FullRecalcOnLoad` and `FullRecalcOnLoadMode` in TXlsFile
• New : FlexCel could raise an exception when deleting ranges with conditional formats.

v6.10.0.0

• New : Support for converting conditional formats between xls and xlsx files

v6.9.0.0

• New : Conditional Format support for xlsx files

v6.8.6.0

• New : User Customization parts preserved in xlsx/m files

v6.8.5.0

v6.8.4.0

• New : Support for rendering linked images (camera tool) to pdf/html/etc
• New : New TXlsFile.RenderCells overload which allows to render objects and borders

v6.8.2.0

• New : Support for preserving ActiveX controls in xlsx files
• New : Support for camera tool (linked images) in xlsx files
• New : New global variables TSmoothingMode_FlexCelDefault and TInterpolationMode_FlexCelDefault
• New : Form controls are now read from and written to the Excel 2010 stream besides the Excel 2007 stream
• New : Files created with NewFile will now not have printer settings, and the locale of them all will be English

v6.8.1.0

v6.8.0.0

• New : Support for adding horizontal scrollbars with the API
• New : Support for ShrinkToFit attribute in cells when exporting to pdf/html/svg/images/printing/previewing
• New : Support for Rad Studio 10.1 Berlin
• New : New parameter `recalcBeforeConverting` added to ConvertFormulasToValues and ConvertExternalNamesToRefErrors
• New : New parameter `convertFormulasToValues` added to PasteFromXlsClipboardFormat
• New : New overload of TFlexCelPdfExport.ExportAllVisibleSheets taking a filename
• New : New <#Switch> and <#IFS> tags in FlexCel reports
• New : Full support of Hyperlinks in autoshapes in xlsx files
• New : Full support for "Allow users to Edit ranges" in the API
• New : Autosize of chart axis when rendering charts
• New : <#IF> tag in reports can now omit the false section

v6.7.16.0

• New : Support for the new functions introduced in the Excel 2016 January Update
• New : New value in TRecalcVersion: "TRecalcVersion.LatestKnownExcelVersion" will identify the file saved by FlexCel as the latest Excel version that FlexCel knows about
• New : New property UsedZoom in TOneImgExportInfo

v6.7.12.0

• New : New properties TExcelFile.HeadingRowHeight and TExcelFile.HeadingColWidth

v6.7.9.0

• New : New static events TUIFont.FontCreating and TUIFont.FontCreated

v6.7.8.0

• New : Support for quoted column names in reports
• New : New methods OffsetRelativeFormula and RecalcRelativeFormula in [[vcl T]]ExcelFile

v6.7.3.0

• New : New JOIN and UNION commands for reports

v6.7.2.0

• New : New property XlsFile.DocumentProperties.PreserveModifiedDate
• New : Improved support for C++ builder FMX
• New : Improved setup
• New : Improved Getting Started document
• New : Copy to the clipboard now supports html
• New : Changed default fallback fonts in pdf
• New : Bidirectional Reports

v6.7.1.0

• New : Support for new Excel 2016 features
• New : New methods XlsFile.SheetID and XlsFile.GetSheetIndexFromID
• New : Center across selection cells are now exported to html

v6.7.0.0

• New : Two new modes for PDF files PageLayout
• New : Support for opening xls versions from 2 to 4
• New : Rad Studio 10 Seattle support
• New : Property Resolution in FlexCelPreview has been removed
• New : New property for PDF files: PageLayoutDisplay
• New : New property for PDF files: InitialZoomAndView
• New : New property ScreenScaling in XlsFile
• New : Full support for manipulating Custom XML parts with XlsFile
• New : Full support for background images in a sheet
• New : C++ builder support for Android and iOS
• New : Ability to <#insert> empty names in reports

v6.6.23.0

v6.6.22.0

• New : iOS 64 bit support
• New : XlsFile.AddImage(row, col, TUIImage) now takes in account the declared image dpi
• New : TXlsNamedRange.GetRanges is now public and documented
• New : Rendering of error bars in xls charts
• New : Rad Studio XE8 support
• New : New property SheetView in XlsFile allows you to set the page view mode and zoom for each mode
• New : New property LinksInNewWindow for FlexCelHtmlExport and FlexCelSVGExport

v6.6.21.0

• New : Now FlexCelDocExport is compatible with C++ builder
• New : New parameters in FlexCelPdfExport.AfterGeneratePage and BeforeGeneratePage events
• New : New method XlsFile.RemoveUserDefinedFunction
• New : New UsePrintScale property in FlexCelHtmlExport
• New : New "Features" demo for reports
• New : Improved RecoveryMode
• New : Fixed memory leak in FlexCelReports that happened when some Exceptions were raised
• New : Fixed linking in C++ builder 32bits when using FlexCelReport and not runtime packages

v6.6.11.0

• New : XlsFile.RecalcForced and FlexCelReport.RecalcForced properties have been removed
• New : Support for recalculating 31 new functions introduced in Excel 2013
• New : Subtotal command in XlsFile
• New : New property ExcelFile.AllowEnteringUnknownFunctionsAndNames
• New : New properties XlsFile.RecalcVersion and FlexCelReport.RecalcVersion
• New : New properties TFlxConsts.MaxRowCount and TFlxConsts.MaxColCount
• New : New overloads of XlsFile.GetObjectProperties and XlsFile.GetObjectAnchor that take an object path
• New : New option "ExcelLike" in XlsFile.Sort
• New : New methods IsRowMarkedForAutofit and IsColMarkedForAutofit in XlsFile
• New : New convenience constructor for XlsFile which takes a Stream

v6.6.2.0

• New : FlexCelPrintDocument now suports FireMonkey in Windows

v6.6.1.0

v6.6.0.0

• New : Reports
• New : New MigratingFromFlexCel3.pdf document

v6.5.0.0

• New : TFlxApplyFont as a new StyleEx property that allows for fine control of which styles are applied
• New : Rad Studio XE7 Support
• New : PDF/A support
• New : PDF properties are now saved in XMP format
• New : Now if you don't specify properties for pdf files in FlexCelPdfExport (like Author, Title, etc.), those will be read from the Excel file being exported
• New : New structure StandardMimeType returns the mime types for xls, xlsx, xlsm, pdf, etc
• New : New enumeration TExcelFieFormat.v2013
• New : New constructor for XlsFile allows to specify the Excel version in one step
• New : Generated PDF files now embed the fonts by default
• New : Generated PDF files are now tagged by default
• New : Generated PDF files are now compatible with Acrobat 7 or newer
• New : FlexCel will throw an Exception when trying to embed a font that doesn't have a license allowing embedding
• New : Ability to set the language of the PDF files
• New : Ability to preserve modification date in xlsx files
• New : Ability to embed files inside the PDF
• New : Ability to embed a Color Profile inside the generated pdf files

v6.3.0.0

• New : TExcelChart.RemoveLegend method
• New : SVG images in HTML files
• New : SVG Exporting
• New : Rad Studio XE6 Support
• New : HTML 5 Exporting
• New : Embed images in HTML files

v6.2.0.0

• New : Support for running in machines with FIPS 140 enabled
• New : Support for preserving PowerPivot tables in xlsx
• New : Support for displaying numbers in Engineering notation

v6.1.1

• New : Support for writing codepages

v6.1.0.0

• New : XE5 support
• New : Support for forcing codepage in Excel95
• New : Support for Android platform for FireMonkey applications
• New : Static events in TPDFWriter: GetFontDataGlobal, GetFontFolderGlobal, OnFontEmbedGlobal

v6.0.6

• New : Ability to autofit part of a column or a row

v6.0

• New : XE4 and iOS Support

v5.6.5

• New : XE3 Update 1 support
• New : Support for recalculating XIRR and XNPV functions

v5.6

• New : Excel file previewer added for FireMonkey

v5.5

• New : Support for reading and writing encrypted .XLS and .XLSX files
• New : Support for Office 2013 .XLSX
• New : Support for FireMonkey 2.0
• New : Support for Delphi XE3 & C++Builder XE3 added
• New : Native previewing of .XLS and .XLSX files (in VCL)
• New : Native exporting of .XLS / .XLSX files to a fully standards compliant HTML file
• New : Native exporting of .XLS / .XLSX files to PDF. Export is 100% native, not third party dlls, Excel or Acrobat are needed.
• New : Native built-in printing support of .XLS / .XLSX files (in VCL)
• New : Intelligent page breaks (to keep relevant parts together when printing)
• New : Autofitting suport. Flexcel can autofit rows and columns in any .XLS and .XLSX file

v5.1.2

v5.1

• New : ApiMate tool for Delphi/C++ Builder that can open any existing .XLS/.XLSX file and show Delphi or C++ code needed to create that file with FlexCel.

v5.0.5

• New : Now FlexCel can natively recalculate the files, with support of over 200 functions.
• New : Added support for TXlsxAdapter component for using FlexCel 5 from FlexCel 3. TXlsxAdapter allows you to use a v3 FlexCelGrid with recalculation and xlsx support.

v5.0.2

• New : Support for C++Builder XE2 added

v5.0.0.0

• New : Support for Excel 2007/2010 colors,checkboxes, comboboxes, array formulas, HTML, extended range of rows & columns, ...
• New : Support for 1048576 rows and 16384 columns.
• New : Support for .XLS, .XLSX, .XLSM file formats
• New : Completely rewritten codebase that will over coming releases have full feature parity with Flexcel .NET

v3.5.1

v3.5

• New : New: RAD Studio XE2 support

v3.4

v3.3

• New : RAD Studio XE support

v3.2.2

• New : Property "CenterredPreview" in FlexCelPreview to center the document in the win

v3.2.1

v3.2

• New : Support to make Flexcel generated XLS files compatible with Excel 2010 protected mode view

v3.1.1

v3.1

• New : Support for Delphi 2010 & C++Builder 2010

v3.0.3

v3.0.0

• New : RAD Studio 2009 support. Optimized for Delphi 2009 to use generics and UnicodeString
• New : Online documentation
• New : Native XLS filesystem. The XLS filesystem has been fully rewriten in native pascal code, making it faster and also usable from any operating systems without any third party dlls
• New : Lazarus/FPC support. FlexCel now can be installed in Lazarus, and run on Linux, Mac OSX or be compiled for Win32, Win64
• New : FlexCel Designer. The new FlexCelDesigner doesn't embed Excel as the previous version did making it much more robust
• New : Easier fully automatic setup
• New : Completely rewritten Documentation and Demos to provide an easier learning curve

v2.6.26

v2.6.24

• New : Support for displaying Addin functions in cells