Axolot Data

Hello, I copy the old sheet before delete. Adjust the name reference sheet to new sheetname. ( name : d_one reference : Sheet1!$D$1 --> name : d_one reference : Sheet3!$D$1 ) I send my test excel file: https://dl.dropboxusercontent.com/u/28537921/temp1_hidden_c_column.rar Test code is same before Pl...

Hello,
I send excel test file.
https://dl.dropboxusercontent.com/u/285 ... column.rar

Hello,
You are right if i delete the sheet, the name is gone. But, CopySheet was do adjusting that names before in version TXlsReadWriteII with xls files.
Sample code with TXlsReadWriteII component works correct but not worked with TXlsReadWriteII5 component as i expected.

Hello,
I instatlled lastest version 5.20.66.
It can be reproduce with xls files. No problem with xlsx, soryy for this detail

Hello,
I want to copy one sheet to new sheet with charts. CopySheet does not cary charts.
How to copy charts from old sheet to new sheet.

Hello, I want to copy one sheet to new one with existing hidden columns, but in the new sheet all columns are visible. procedure TForm.Button1Click(Sender: TObject); var fn1, fn2: string; Excel: TXlsReadWriteII5; begin fn1 := 'D:\Tests\Excel\temp1.xls'; fn2 := 'D:\Tests\Excel\temp2.xls'; Excel := TX...

Hello, I want copy one sheet including defined a cell name to new sheet and when i delete the first sheet defined cell name is being invalid, not refereced the new sheet. CopySheet do not adjust the new defined name Defined simple cell Name like this name: c_one reference: =Sheet1!$C$1 Same code wit...

It works, thank you for update

Hello, Thank you for the update. But unfortunately my problem still unsolved case. In my debug sesssion notice that Workbook movecells method calls copycells with copyoptions and than it calls sheets copycells method with copyoptions but in this method ccoLockStartRow option still not implemented. M...

Hello, is there any improvement in this subject, it's some urgent.

Hello, I want to copy images from one sheet to antoher sheet, there are two problems: 1. Sheet.Drawing.InsertImage method not worked with stream) 2. Image Scale. I used InsertImage with filename, this worked but previous image scale not preserved although I set new size. Component version 5.20.61 te...

Hi, when the next update will be ready

XLSReadWriteII 5, in MoveCells method option ccoLockStartRow is not working as expected. Moving a cell from B3 to B15 with a formula something like that =SUM(B3:B3), new formula must be =SUM(B3, B15) with ccoLockStartRow option but formula changes to = SUM(B15:B15) ccoLockStartRow option has no affe...