Axolot Data

Axolot Data
https://axolot.se/phpBB3/

xvExcel97 (Unknown Name Error) and (name range not updating)

https://axolot.se/phpBB3/viewtopic.php?f=16&t=2367

Page 1 of 1

xvExcel97 (Unknown Name Error) and (name range not updating)

Posted: Tue Apr 21, 2015 1:24 pm
by Dmeade
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

Code: Select all

unit XLSTestRun4;

interface
uses Xc12Utils5, XLSReadWriteII5, XLSNames5, SysUtils, typinfo, Vcl.Dialogs, windows;

procedure XLSCreateTemplateAndLoadData( XLSVersion : TExcelVersion; TemplateFileName, ExportFileName : String ) ;
procedure XLSCreateTemplate( XLSVersion : TExcelVersion; TemplateFileName : String ) ;
procedure XLSPopulateTemplate( XLSVersion : TExcelVersion; TemplateFileName, ExportFileName : String ) ;

implementation

const SHEET1 = 'Summary';
      SHEET2 = 'Data1';
      SHEET3 = 'Data 2';
      SHEET4 = 'Data3';

      SHEET2NAME1 = 'S2NAME1';
      SHEET2NAME2 = 'S2NAME2';

      SHEET3NAME1 = 'S3NAME1';
      SHEET3NAME2 = 'S3NAME2';

      SHEET4NAME1 = 'S4NAME1';
      SHEET4NAME2 = 'S4NAME2';
      SHEET4NAME3 = 'S4NAME3'; //BLANK DATA

procedure XLSPopulateTemplate( XLSVersion : TExcelVersion; TemplateFileName, ExportFileName : String ) ;
var XLSReadWriteII52: TXLSReadWriteII5;
    i : Integer;
    sTemp : String;

  procedure CreateExportFile(iMethodType : Integer);
  begin
    case iMethodType of
      1 : begin
            CopyFile( PChar( TemplateFileName), PChar(ExportFileName), true);
            XLSReadWriteII52.Filename := ExportFileName;
          end
      else begin
        XLSReadWriteII52.Filename := TemplateFileName;
        XLSReadWriteII52.Read;
        XLSReadWriteII52.Filename := ExportFileName;
        XLSReadWriteII52.Write;
      end;
    end;
  end;

begin
  assert( FileExists( TemplateFileName ) , 'File not Created. "'+ XLSReadWriteII52.Filename +'"');



  XLSReadWriteII52 := TXLSReadWriteII5.Create(nil);
  XLSReadWriteII52.Version := XLSVersion;

  CreateExportFile(1);

  try
    assert( FileExists( XLSReadWriteII52.Filename ) , 'File not Created. "'+ XLSReadWriteII52.Filename +'"');
    XLSReadWriteII52.Read;

    for i := 1 to 1 do begin
      if i > 0 then
        XLSReadWriteII52.SheetByName( SHEET2 ).InsertRows(2,1);
      XLSReadWriteII52.SheetByName( SHEET2 ).AsFloat[0, 1+i] := i;
      XLSReadWriteII52.SheetByName( SHEET2 ).AsFloat[1, 1+i] := i mod 2;
      XLSReadWriteII52.SheetByName( SHEET2 ).AsFormula[2, 1+i] := 'SUMIF('+ SHEET2NAME2 + ','+ inttostr( i mod 2 ) +','+ SHEET2NAME1 +')';
      XLSReadWriteII52.Write;  //Try Writing After each insert
    end;

    //Try populating the data in a different cell
    XLSReadWriteII52.SheetByName( SHEET3 ).InsertRows(2,10);
    for i := 10 downto 1 do begin
      XLSReadWriteII52.SheetByName( SHEET3 ).AsFloat[0, 1+i] := i;
      XLSReadWriteII52.SheetByName( SHEET3 ).AsFloat[1, 1+i] := i mod 2;
      XLSReadWriteII52.SheetByName( SHEET3 ).AsFormula[2, 1+i] := 'SUMIF('+  SHEET3NAME2 + ','+ inttostr( i mod 2 ) +','+ SHEET3NAME1 +')';
      if i in [5,6] then
        XLSReadWriteII52.SheetByName( SHEET3 ).AsFormula[3, 1+i] :='SUMIF(' +SHEET3NAME2+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-2))), '+SHEET3NAME1+')' ;
    end;
    XLSReadWriteII52.Write;

    //Try populating the data in middle of a range
    XLSReadWriteII52.SheetByName( SHEET4 ).InsertRows(2,15);
    for i := 15 downto 1 do begin
      XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[0, 1+i] := i;
      if (i mod 2) = 0 then
        sTemp := 'A'
      else
        sTemp := 'B';
      XLSReadWriteII52.SheetByName( SHEET4 ).AsString[1, 1+i] := sTemp;
      //XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[1, 1+i] := i mod 2;

      if i in [5,6] then
        XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[3, 1+i] :='SUMIF(' +SHEET4NAME2+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-2))), '+SHEET4NAME1+')';
      XLSReadWriteII52.Write;
    end;

    XLSReadWriteII52.SheetByName( SHEET4 ).InsertRows(6,3);
    for i := 3 downto 1 do begin
      XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[0, 5+i] := i;
      if (i mod 2) = 0 then
        sTemp := 'A'
      else
        sTemp := 'B';
      XLSReadWriteII52.SheetByName( SHEET4 ).AsString[1, 5+i] := sTemp;
     // XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[2, 5+i] := 'SUMIF('+ SHEET4NAME2 + ','+ sTemp +','+ SHEET4NAME1 +')';

      if i in [5,6] then
        XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[3, 5+i] :='SUMIF(' +SHEET4NAME2+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-2))), '+SHEET4NAME1+')';
      XLSReadWriteII52.Write;
    end;

    XLSReadWriteII52.SheetByName( SHEET4 ).InsertRows(0,5);
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[1, 3] := 'SUM('+#39+SHEET4+#39+'!B1:B3)';

    //XLSReadWriteII52.calculate;
    //XLSReadWriteII52.Write;

    XLSReadWriteII52.SheetByName( SHEET4 ).InsertRows(1,2);
   // XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[1, 0] := 'SUMIF('+ SHEET4NAME2 + ',A,'+ SHEET4NAME1 +')';
   // XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[1, 1] := 'SUMIF('+ SHEET4NAME2 + ',B,'+ SHEET4NAME1 +')';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsString[0, 2] := 'A';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsString[0, 3] := 'B';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[1, 2] :='SUMIF(' +SHEET4NAME2+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-1))), '+SHEET4NAME1+')';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[1, 3] :='SUMIF(' +SHEET4NAME2+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-1))), '+SHEET4NAME1+')';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[2, 2] :='SUMIF(' +SHEET4NAME2+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-2))), '+SHEET4NAME3+')';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[2, 3] :='SUMIF(' +SHEET4NAME2+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-2))), '+SHEET4NAME3+')';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[3, 2] :='SUMIF(' +SHEET4NAME3+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-3))), '+SHEET4NAME1+')';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[3, 3] :='SUMIF(' +SHEET4NAME3+ ',INDIRECT( ADDRESS( ROW(),(COLUMN()-3))), '+SHEET4NAME1+')';
    XLSReadWriteII52.Write;
    XLSReadWriteII52.calculate;
    XLSReadWriteII52.Write;

  finally
    XLSReadWriteII52.Free;
  end;
end;

procedure XLSCreateTemplate( XLSVersion : TExcelVersion; TemplateFileName : String ) ;
var XLSReadWriteII52: TXLSReadWriteII5;
    i : integer;
begin
  XLSReadWriteII52 := TXLSReadWriteII5.Create(nil);
  XLSReadWriteII52.Version := XLSVersion;
  XLSReadWriteII52.Filename := TemplateFileName;

  try
    XLSReadWriteII52.Write;
    assert( FileExists( XLSReadWriteII52.Filename ) , 'File not Created. "'+ XLSReadWriteII52.Filename +'"');

    XLSReadWriteII52.Sheets[0].Name := SHEET1;
    XLSReadWriteII52.Write;
    XLSReadWriteII52.Add;
    XLSReadWriteII52.Sheets[1].Name := SHEET2;
    XLSReadWriteII52.Write;
    XLSReadWriteII52.Add;
    XLSReadWriteII52.Sheets[2].Name := SHEET3;
    XLSReadWriteII52.Write;
    XLSReadWriteII52.Add;
    XLSReadWriteII52.Sheets[3].Name := SHEET4;
    XLSReadWriteII52.Write;

    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[0,0] := SHEET2 + ' Totals';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[3,0] := 'Should Be';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[1,1] := 'DATA1';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFloat[3,1] := 1.3;
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[1,2] := 'DATA2';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFloat[3,2] := 1.3;
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[0,5] := SHEET3 + ' Totals';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[1,6] := 'DATA3';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFloat[3,6] := 55.3;
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[1,7] := 'DATA4';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFloat[3,7] := 5.3;
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[0,10] := SHEET4 + ' Totals';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFloat[3,11] := 126.6;
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[1,11] := 'DATA5';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsString[1,12] := 'DATA6';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFloat[3,12] := 0.6;
    XLSReadWriteII52.Write;

    XLSReadWriteII52.SheetByName( SHEET2 ).AsString[0,0] := 'DATA1';
    XLSReadWriteII52.SheetByName( SHEET2 ).AsString[1,0] := 'DATA2';
    XLSReadWriteII52.names.Add( SHEET2NAME1, ''''+SHEET2+ ''''+'!$A$2:$A$3' );
    XLSReadWriteII52.names.Add( SHEET2NAME2, ''''+SHEET2+ ''''+'!$B$2:$B$3' );
    XLSReadWriteII52.SheetByName( SHEET2 ).AsFloat[0,1] := 0.1;
    XLSReadWriteII52.SheetByName( SHEET2 ).AsFloat[1,1] := 0.1;
    XLSReadWriteII52.SheetByName( SHEET2 ).AsFloat[0,2] := 0.2;
    XLSReadWriteII52.SheetByName( SHEET2 ).AsFloat[1,2] := 0.2;
    XLSReadWriteII52.Write;
    XLSReadWriteII52.SheetByName( SHEET2 ).AsFormula[0,3] := 'sum('+ SHEET2NAME1 +')';
    XLSReadWriteII52.SheetByName( SHEET2 ).AsFormula[1,3] := 'sum('+ SHEET2NAME2 +')';
    XLSReadWriteII52.SheetByName( SHEET2 ).AsFormula[0,4] := 'SUM('+#39+SHEET2+#39+'!A2:A3)';
    XLSReadWriteII52.SheetByName( SHEET2 ).AsFormula[1,4] := 'SUM('+#39+SHEET2+#39+'!B2:B3)';
    XLSReadWriteII52.SheetByName( SHEET2 ).AsString[2,3] := 'Name Sums';
    XLSReadWriteII52.SheetByName( SHEET2 ).AsString[2,4] := 'Sum Sums';

    XLSReadWriteII52.SheetByName( SHEET2 ).Cell[0,3].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET2 ).Cell[1,3].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET2 ).Cell[0,4].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET2 ).Cell[1,4].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.Write;

    XLSReadWriteII52.SheetByName( SHEET3 ).AsString[0,0] := 'DATA3';
    XLSReadWriteII52.SheetByName( SHEET3 ).AsString[1,0] := 'DATA4';
    XLSReadWriteII52.names.Add( SHEET3NAME1, ''''+SHEET3+ ''''+'!$A$2:$A$3' );
    XLSReadWriteII52.names.Add( SHEET3NAME2, ''''+SHEET3+ ''''+'!$B$2:$B$3' );
    XLSReadWriteII52.SheetByName( SHEET3 ).AsFloat[0,1] := 0.1;
    XLSReadWriteII52.SheetByName( SHEET3 ).AsFloat[1,1] := 0.1;
    XLSReadWriteII52.SheetByName( SHEET3 ).AsFloat[0,2] := 0.2;
    XLSReadWriteII52.SheetByName( SHEET3 ).AsFloat[1,2] := 0.2;
    XLSReadWriteII52.Write;
    XLSReadWriteII52.SheetByName( SHEET3 ).AsFormula[0,3] := 'sum('+ SHEET3NAME1 +')';
    XLSReadWriteII52.SheetByName( SHEET3 ).AsFormula[1,3] := 'sum('+ SHEET3NAME2 +')';
    XLSReadWriteII52.SheetByName( SHEET3 ).AsFormula[0,4] := 'SUM('+#39+SHEET3+#39+'!A2:A3)';
    XLSReadWriteII52.SheetByName( SHEET3 ).AsFormula[1,4] := 'SUM('+#39+SHEET3+#39+'!B2:B3)';
    XLSReadWriteII52.SheetByName( SHEET3 ).AsString[2,3] := 'Name Sums';
    XLSReadWriteII52.SheetByName( SHEET3 ).AsString[2,4] := 'Sum Sums';

    XLSReadWriteII52.SheetByName( SHEET3 ).Cell[0,3].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET3 ).Cell[1,3].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET3 ).Cell[0,4].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET3 ).Cell[1,4].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.Write;

    XLSReadWriteII52.SheetByName( SHEET4 ).AsString[0,0] := 'DATA3';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsString[1,0] := 'DATA4';
    XLSReadWriteII52.names.Add( SHEET4NAME1, ''''+SHEET4+ ''''+'!$A$2:$A$4' );
    XLSReadWriteII52.names.Add( SHEET4NAME2, ''''+SHEET4+ ''''+'!$B$2:$B$4' );
    XLSReadWriteII52.names.Add( SHEET4NAME3, ''''+SHEET4+ ''''+'!$F$2:$F$4' );

    XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[0,1] := 0.1;
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[1,1] := 0.1;
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[0,2] := 0.2;
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[1,2] := 0.2;
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[0,3] := 0.3;
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFloat[1,3] := 0.3;
    XLSReadWriteII52.Write;
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[0,4] := 'sum('+ SHEET4NAME1 +')';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[1,4] := 'sum('+ SHEET4NAME2 +')';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[0,5] := 'SUM('+#39+SHEET4+#39+'!A2:A4)';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsFormula[1,5] := 'SUM('+#39+SHEET4+#39+'!B2:B4)';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsString[2,4] := 'Name Sums';
    XLSReadWriteII52.SheetByName( SHEET4 ).AsString[2,5] := 'Sum Sums';
    XLSReadWriteII52.Write;

    XLSReadWriteII52.SheetByName( SHEET4 ).Cell[0,4].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET4 ).Cell[1,4].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET4 ).Cell[0,5].FillPatternForeColor := xcYellow;
    XLSReadWriteII52.SheetByName( SHEET4 ).Cell[1,5].FillPatternForeColor := xcYellow;

    XLSReadWriteII52.Write;

    XLSReadWriteII52.SheetByName( SHEET1 ).AsFormula[2,1] := 'sum('+ SHEET2NAME1 +')';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFormula[2,2] := 'sum('+ SHEET2NAME2 +')';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFormula[2,6] := 'sum('+ SHEET3NAME1 +')';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFormula[2,7] := 'sum('+ SHEET3NAME2 +')';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFormula[2,11] := 'sum('+ SHEET4NAME1 +')';
    XLSReadWriteII52.SheetByName( SHEET1 ).AsFormula[2,12] := 'sum('+ SHEET4NAME2 +')';
    XLSReadWriteII52.Write;
  finally
    XLSReadWriteII52.Free;
  end;
end;

procedure XLSCreateTemplateAndLoadData( XLSVersion : TExcelVersion; TemplateFileName, ExportFileName : String ) ;
begin
  try
    XLSCreateTemplate( XLSVersion, TemplateFileName );
  except
    on E:Exception do begin
      e.Message := 'Error with XLSCreateTemplate fn[XLSTestRun4.XLSCreateTemplateAndLoadData]' + #13#10 +  e.Message;
      raise;
    end;
  end;
  try
    XLSPopulateTemplate( XLSVersion, TemplateFileName, ExportFileName );
  except
    on E:Exception do begin
      e.Message := 'Error with XLSPopulateTemplate fn[XLSTestRun4.XLSCreateTemplateAndLoadData]' + #13#10 +  e.Message;
      raise;
    end;
  end;
end;

end.
Code to use this

Code: Select all

procedure TForm7.btn6Click(Sender: TObject);
var sTemplateLocation,
    sExportlocation,
    sDateTimeStamp : String;
begin
  sDateTimeStamp := FormatDateTime('yymmdd_hhnnss_zzz', now);
  try
    sTemplateLocation := IncludeTrailingPathDelimiter( ExtractFilePath(Application.exename) ) +
                                            'XLSTestV97TEMP' + sDateTimeStamp + '.XLS';
    sExportLocation   := IncludeTrailingPathDelimiter( ExtractFilePath(Application.exename) ) +
                                            'XLSTestV97EXP' + sDateTimeStamp + '.XLS';
    XLSCreateTemplateAndLoadData(xvExcel97,sTemplateLocation, sExportLocation );

    ShellExecute(self.Handle, 'Open', PChar(sExportLocation), PChar(''), nil, 1);
  except
    on E:Exception Do begin
      e.Message := 'Error when exporting XLS Verion xvExcel97' + #13#10 + e.Message;
      //raise;
      messagedlg(e.Message, mtError, [mbOk], 0);
    end;
  end;

  try
    sTemplateLocation := IncludeTrailingPathDelimiter( ExtractFilePath(Application.exename) ) +
                                            'XLSTestV2007TEMP' + sDateTimeStamp + '.XLSX' ;
    sExportLocation := IncludeTrailingPathDelimiter( ExtractFilePath(Application.exename) ) +
                                            'XLSTestV2007EXP' + sDateTimeStamp + '.XLSX' ;
    XLSCreateTemplateAndLoadData(xvExcel2007, sTemplateLocation, sExportLocation );

    ShellExecute(self.Handle, 'Open', PChar(sExportLocation), PChar(''), nil, 1);
  except
    on E:Exception Do begin
      e.Message := 'Error when exporting XLS Verion xvExcel2007' + #13#10 + e.Message;
      //raise;
      messagedlg(e.Message, mtError, [mbOk], 0);
    end;
  end;
end;

Re: Unknown Name xvExcel97

Posted: Thu Apr 23, 2015 12:29 pm
by larsa
Hello

This is fixed in update 5.20.48

Re: Unknown Name xvExcel97

Posted: Fri Apr 24, 2015 6:20 am
by Dmeade
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

Re: Unknown Name xvExcel97

Posted: Mon May 18, 2015 11:55 pm
by Dmeade
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

Re: Unknown Name xvExcel97

Posted: Tue Jun 16, 2015 2:10 am
by Dmeade
version 5.20.50
not updating the name range for xvExcel97 when inserting lines

Re: Unknown Name xvExcel97

Posted: Tue Jun 16, 2015 3:13 pm
by larsa
Hello

Will be fixed in the next update.

Re: Unknown Name xvExcel97

Posted: Wed Jul 15, 2015 11:43 pm
by Dmeade
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 by 4 not 3

Also the start position is changing from A2 to A9 - in the Data1 Tab

Ive put the Source code to reproduce this issue on GIT - ill remove it when its fixed
https://github.com/dangas56/Delphi-XLS- ... geTest.git

if you don't have git you can get the source files from here
https://github.com/dangas56/Delphi-XLS- ... /1.0.0.zip

Re: xvExcel97 (Unknown Name Error) and (name range not updating)

Posted: Tue Jul 28, 2015 2:19 am
by Dmeade
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?

Re: xvExcel97 (Unknown Name Error) and (name range not updating)

Posted: Tue Aug 04, 2015 1:00 am
by Dmeade
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

Re: xvExcel97 (Unknown Name Error) and (name range not updating)

Posted: Thu Sep 10, 2015 3:44 am
by Dmeade
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- ... eRangeTest

Zip file of Source here
https://github.com/dangas56/Delphi-XLS- ... t/releases

if you need more info or cant reproduce the issue let me know
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited