Axolot Data

Hello,

I need to perform a simple task: remove all formulas on sheet but keeping values. The simplest way to do this in Excel is Select All, copy, copy special and only values. I think this could work just fine in XLSReadWrite but I'm facing a problem: TCopyCellOptions is not defined.

XLS.CopyCells(0,0,0,10,100,0,0,0,[ccoCopyValues]);

and "ccoCopyValues" is undeclared identifier. I've done content search of all component files without results. Usually this kind of problem is resolved by adding files to USES clause.

Thanks,

Axel.

BTW: any other options to do the job?

Ok. It was XLSUtils4.dcu.

Got it to work...