Что нового?

Welcome to DUMPz.ws - старейший компьютерный форум (c) 2004-2021

Присоединяйтесь к нашему сообществу сейчас, чтобы получить доступ ко всем функциям форума. После регистрации Вы сможете создавать темы, публиковать ответы, общаться в чате с единомышленниками.
Blue
Red
Green
Orange
Voilet
Slate
Dark

Component TMS FlexCel

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,709
Реакции
1,031
Credits
852
Native language | Родной язык
Русский
TMS FlexCel
Powerful, extensive & flexible component suite for native Excel report & file generation & manipulation
  • FlexCel for VCL / FireMonkey is a suite of Delphi components allowing to manipulate Excel files. It includes an extensive API allowing to natively read/write Excel files. If you need to read or create complex spreadsheets, on Windows or macOS on machines without Excel installed, Flexcel can do the job.
  • Support for cross platform use: Win32, Win64, macOS, iOS, Android and Linux
  • 100% Native support for creating Excel .XLS, .XLSX, .XLSM file formats (Excel 97 - Excel 2019)
  • 100% Native support for reading Excel 2 - Excel 2019 files
  • 100% Native PDF report generation from .XLS/.XLSX files (PDF/A 1, 2 and 3 support)
  • 100% Native support for previewing and printing .XLS/.XLSX files
  • Fully standards compliant HTML 5 file generation from .XLS/.XLSX files
  • Export .XLS & .XLSX files to SVG
  • Report Engine that allows to create complex reports using Excel as your report designer, so your final users can modify them. You can use images/comments/conditional formats/merged cells/pivot tables/charts and almost anything you can think of on those reports
  • Support for formula recalculation supporting Как увидеть ссылки? | How to see hidden links?
  • ApiMate tool for automatically showing needed Delphi/C++ code for generating specific .XLS/.XLSX file cells with Flexcel
  • Templates can be embedded inside your exe. No additional files to distribute
  • Can write images/comments/conditional formats/merged cells/pivot tables/charts and almost the complete Excel feature set in native mode
  • Designed from start to make full use of modern Delphi features like records with methods or generics.
  • Also available as a fully managed Как увидеть ссылки? | How to see hidden links?
  • Fully documented. FlexCel has a Как увидеть ссылки? | How to see hidden links? with guides, tips, full reference for every method and more than 50 working examples to help you get started.
Copyright © Как увидеть ссылки? | How to see hidden links?
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,709
Реакции
1,031
Credits
852
Native language | Родной язык
Русский
TMS FlexCel 7.1 for Delphi XE-10.3.Rio Full Source (Retail)
Version: 7.1
  • Improved : Updated to the latest version of Skia for Linux
  • Improved : The HTML engine can now parse tags
  • Improved : Support for calculating BAHTTEXT function
  • Improved : Reports can now use nested properties in Aggregates, Filters, Sort and Master-details relationships
  • Improved : Removed overload method TExcelFile.GetImage(Integer, string, TXlsImgType, TStream)
  • Improved : Now you can use report expressions that call themselves recursively, as long as the recursion converges
  • Improved : Now for reports you can set semi-absolute references in the config sheet
  • Improved : Improved recalculation speed and decreased memory usage
  • Improved : Improved compatibility with invalid xlsx files
  • Improved : Improved chart rendering
  • Improved : Android64 Support
  • Fixed : FlexCel would nor correctly read or write left and right cell borders in strict xlsx files.
  • Fixed : FlexCel was failing to render images which had an image filled background.
  • Fixed : FlexCel might not preserve comment backgrounds in xlsx files if the background was an image or texture.
  • Fixed : FlexCel could fail to open some files which didn't completely implement the xlsx spec but which Excel could open.
Скрытое содержимое могут видеть только пользователь группы: Местный, Premium, Свои
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,709
Реакции
1,031
Credits
852
Native language | Родной язык
Русский
TMS FlexCel 7.1 for Delphi 10.4.1 Sydney Full Source
Version: 7.1
  • Improved : Updated to the latest version of Skia for Linux
  • Improved : The HTML engine can now parse tags
  • Improved : Support for calculating BAHTTEXT function
  • Improved : Reports can now use nested properties in Aggregates, Filters, Sort and Master-details relationships
  • Improved : Removed overload method TExcelFile.GetImage(Integer, string, TXlsImgType, TStream)
  • Improved : Now you can use report expressions that call themselves recursively, as long as the recursion converges
  • Improved : Now for reports you can set semi-absolute references in the config sheet
  • Improved : Improved recalculation speed and decreased memory usage
  • Improved : Improved compatibility with invalid xlsx files
  • Improved : Improved chart rendering
  • Improved : Android64 Support
  • Fixed : FlexCel would nor correctly read or write left and right cell borders in strict xlsx files.
  • Fixed : FlexCel was failing to render images which had an image filled background.
  • Fixed : FlexCel might not preserve comment backgrounds in xlsx files if the background was an image or texture.
  • Fixed : FlexCel could fail to open some files which didn't completely implement the xlsx spec but which Excel could open.
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,709
Реакции
1,031
Credits
852
Native language | Родной язык
Русский
TMS FlexCel v7.8 for Delphi XE-10.4 Sydney [full source]

v7.8​

  • New : Support for reading fonts from the disk even if the graphics library returns that information
  • Improved : Improved compatibility with invalid xls files

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]:)//Как увидеть ссылки? | How to see hidden links?/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.
  • Improved : Improved handling of unknown parts inside xlsx files and improved Google sheets compatibility

v7.6.4​

  • New : New syntax for ALIAS DataSets
  • New : New "COUNT" parameter in <#Aggregate> tag
  • Fixed : When inserting cell ranges with multiple rows used as data by pivot tables, the pivot table might not adapt correctly.
  • Fixed : When exporting to HTML both headers and footers would be ignored if you specified THidePrintObjects.Header, and THidePrintObjects.Footer was ignored. Now footers will work with THidePrintObjects.Footer and THidePrintObjects.Header will only hide the headers.
  • Fixed : Sometimes when copying only format from cells, and the cells had only a column or row format, the format wouldn't be copied.
  • Fixed : Some invalid third party xls files could fail to load.
  • Fixed : Now nested <#aggregate> and <#list> tags will be put in master-detail if they are related.
  • Fixed : Fixed issues with <#evaluate> tag when it evaluates recursively

v7.6.2​

  • Fixed : When adding a chart to a file via the API and immediately rendering it to PDF without saving it, the chart might not be rendered in the PDF file.
  • Fixed : Previously the last row in "X" Bands in reports was deleted before the detail bands were inserted. This could cause unwanted behavior if the details shared the same rows as the master. Now last rows in X Bands will be removed after the details are inserted.
  • Fixed : DbValue could raise Exceptions in some cases.
  • Fixed : A fixed band inside a master-detail bidirectional report would behave as non fixed.

v7.6.1​

  • New : Support for Rad Studio 10.4 Sydney
  • Improved : Improved conversion from strings to numbers
  • Fixed : Deeply nested array formulas could return N/A results in some corner cases

v7.6​

  • New : Support for rendering logarithmic charts
  • New : Support for Rad Studio 10.4 Beta
  • Improved : When rendering pages to PDF and PNG, if an image or chart goes over the columns or rows in a page, now it won't overflow
  • Improved : Now FlexCel won't throw an Exception if a Font folder in the PDF FontFolder path doesn't exist
  • Improved : Now FlexCel will search in c:\Windows\Fonts and %localappdata%\Microsoft\Windows\Fonts for fonts when exporting to PDF
  • Improved : Improved handling of chart gaps when there are null values
  • Fixed : Xlsm files containing macros and with sheet names starting with a number and bigger than 24 characters, could generate invalid files when saved in FlexCel.
  • Fixed : When manually installing FlexCel in Delphi XE, Delphi XE would raise an exception. Note that this is a fix only for manual installation: automatic installation worked fine.
  • Fixed : Sometimes when calling RenderObjects the border of a chart would not be exported to PDF or PNG.
  • Fixed : Now FlexCel will validate when manually setting a sheet codename, that the name is ASCII and starts with a letter.
  • Fixed : Now FlexCel will draw a maximum of 10000 ticks per axis in charts, to avoid taking too long drawing too many ticks that aren't visible anyway.
  • Fixed : Manually positioned labels in stacked bar charts were a little offset from their manual position.
  • Fixed : Leader lines in stacked bar charts were wrong when the axis was reversed
  • Fixed : FlexCel would consider a protected range title containing a "?" invalid. This would prevent it from loading files that used "?" in protected ranges.
  • Fixed : Bidirectional reports could fail to delete rows or columns in complex reports.

v7.5.1​

  • Fixed : With some combinations of Delphi versions and platforms, you could get Access Violations when opening files in FlexCel 7.5. This was caused by a bug in the way Delphi handles method inlining, and it didn't happen in previous FlexCel versions. **If you installed FlexCel 7.5, please update.**

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
  • Improved : Improved compatibility with invalid third party files
  • Improved : Better chart rendering when there are date axis
  • Fixed : When rendering charts you could get an index out of bounds in some corner cases.
  • Fixed : FlexCel will ignore invalid themes when reading xls files
  • Fixed : FlexCel wasn't calculating conditional formats if the formulas defining the conditions were array formulas.
  • Fixed : FlexCel could fail to process some files where a shape had an ending coordinate smaller than the starting coordinate.

v7.1.1​

  • New : New __ALIAS postfix in named ranges allows multiple ranges to the same database
  • Fixed : When using a not standard row height for the whole sheet, FlexCel would create new rows to have automatic height, instead of having the standard row height for the sheet. This could confuse Excel.
  • Fixed : Sometimes in Android 32 or 64 bits you could get a BUS (10) error.
  • Fixed : In some corner cases charts saved by FlexCel inside xlsx files would fail to load.
  • Fixed : FlexCel will now check that font sizes saved are between 1 and 409 points. Before it would let you save any font size, and invalid font sizes would crash Excel when opening the file.
  • Fixed : Effects for an image in the background of an image could be incorrectly saved. In some cases, this could cause Excel to crash.
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 
  • Like
Реакции: difo

Vi_t

Местный
Регистрация
21 Май 2012
Сообщения
3
Реакции
0
Credits
16
Native language | Родной язык
Русский
почему при установке у меня ругается ,что уже тот же самый набор в AdvStringGrid Import and Export Filters?
Они перенесли эти копроненты вдругую библиотеку?
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,709
Реакции
1,031
Credits
852
Native language | Родной язык
Русский
почему при установке у меня ругается ,что уже тот же самый набор в AdvStringGrid Import and Export Filters?
Они перенесли эти копроненты вдругую библиотеку?
Библиотеки TMS тесно переплетены между собой. AdvStringGrid имеет экспорт в Excel, поэтому в нем есть урезанная версия FlexCel
 

Vi_t

Местный
Регистрация
21 Май 2012
Сообщения
3
Реакции
0
Credits
16
Native language | Родной язык
Русский
Просто старую отключил библиотеку и подключил эту.
Ситуация напомнила TeeChart - одно имя модуля и разные реализации.
Спасибо