Axolot Data

Hello Lars,

It must be obvious, but I am just not seeing what I have to do.

If I use syntax like:

XLS.Sheets[0].SelectedAreas.Add(1,1,5,10);

then can you tell me what I have to do to make that area the current selection?

Many thanks,

Ian.

I would like to set a specific cell or range of cells on a worksheet to be selected when then the user opens a workbook. Can anyone give me some example code?

I am using version 3.01.02 to open a workbook, add data and cell formulae, and then to save it under a different file name. Despite the indication in the version history area that the problem has been fixed, I am still getting the "File Error, some data may have been lost" message when I t...

I would like to create a scatter plot where both the X and Y coordinates can range from about -4 to 4. The axes would need to be placed along the bottom and left hand side of the plot and so I need to set a real valued negative crossing point. Why does XLSReadWriteII limit CrossingPoints to integers...

Thank you Lars.

I have tested the with the new version and no more exceptions.

Ian.

I am trying to use the ABS function in a cell formula that looks like: IF(ABS(0.005+OFFSET(A1,1,15+B9))>OFFSET(C20,B9,0),OFFSET(A1,1,11),NA()) However, I am getting an exception from EncodeFormulaII2 that tells me "wrong number of arguments for function ABS". Any thoughts on a work around?...