Axolot Data

using version 5.20.56 has issues with xvExcel97 where name ranges are not updating correctly after inserting rows example here https://github.com/dangas56/Delphi-XLS-WR-v5_NameRangeTest Zip file of Source here https://github.com/dangas56/Delphi-XLS-WR-v5_NameRangeTest/releases if you need more info ...

Using Version 5.20.56 default build gets Integer overflow with xlsx files that have image or chart I have added an example project to Github Git link https://github.com/dangas56/XLSWR_IntegerOverflow.git zip files are here https://github.com/dangas56/XLSWR_IntegerOverflow/releases/tag/1.0.1 Adding d...

version 5.20.53

has issues with xvExcel97 where name ranges are not updating correctly after inserting rows

example here
https://github.com/dangas56/Delphi-XLS- ... eRangeTest

if you need more info or cant reproduce the issue let me know

version 5.20.53
getting the integer overflow error - in the default build

after adding d3nton's suggested solution - i'm no longer getting the error

version 5.20.52
getting the integer overflow error

version 5.20.52

still has issues with xvExcel97 and names

can you reproduce the issues from this example?
https://github.com/dangas56/Delphi-XLS- ... eRangeTest

or do you need more info?

version 5.20.51 Seems to have changed but not working correctly looks like when you update multiple names across different sheets - the range is being updated across all sheets e.g. Sheet 1 inserts 1 row Sheet 2 inserts 3 rows the range for sheet 1 is added by 4 not 1 the range for sheet 2 is added ...

Version 5.20.51
still gets the integer overflow error

version 5.20.50
not updating the name range for xvExcel97 when inserting lines

Version 5.20.50
still gets the integer overflow error

Im using Xls Read Write version 5.20.49 if i create a new Excel sheet using microsoft Excel 2013 and add a Line Chart and save that file create a new Delphi project and in the project Options - compiling - Runtime Errors if the Overflow checking and range checking are checked and you try and read th...

version 5_5.20.49

when running xvExcel97 the name range and the sum range are not updating after inserting lines
run the code in the first post to reproduce

Hi

Version 5.20.48 fixes the Unknown name S2NAME2 issue

but if you have a look at the Data Tabs from the export in the code example for the
xvExcel97 version the name range and the sum range have not been changed by the inserting of lines

version xvExcel2007 seems to be working

Im running 5.20.46 getting this error when running xvExcel97 version files Error in formula SUMIF(S2NAME2,1,S2NAME1) Unknown name S2NAME2 here is the code to reproduce unit XLSTestRun4; interface uses Xc12Utils5, XLSReadWriteII5, XLSNames5, SysUtils, typinfo, Vcl.Dialogs, windows; procedure XLSCreat...

i was running 5.20.45

5.20.47 works

Thanks