conversion issue with Sheets[0].asError

[wellyworld]

I'm not finding any documentation that explains the changes betweek XLSReadWriteII_4 and XLSReadWriteII_5. I'm in the process of converting our source code over to the new version and am finding many issues. Is there a document that explains the differences?

If not, let me start by asking how to modify this:

Code: Select all

XLS.Sheets[0].AsError[1,1] := errError

...since TXc12CellError doesn't have an errError element?

[larsa]

Hello

There is no such doc but there are few changes in the interface.

The value errError was for internal use and is removed. You can't assign it to a cell as Excel don't recognize it.

[wellyworld]

The value errError was for internal use and is removed. You can't assign it to a cell as Excel don't recognize it.

So what do I use then? errUnknown?

[larsa]

Hello

Any of the values:
errNull, //* Empty intersection.
errDiv0, //* Division by null.
errValue, //* Illegal value.
errRef, //* Illegal reference. Possibly to a deleted worksheet.
errName, //* Unknown name.
errNum, //* Illegal number.
errNA, //* Not available error.