Page 1 of 1
conversion issue with Sheets[0].asError
Posted: Tue Oct 15, 2013 8:26 pm
by 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?
Re: conversion issue with Sheets[0].asError
Posted: Wed Oct 16, 2013 6:51 am
by 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.
Re: conversion issue with Sheets[0].asError
Posted: Wed Oct 16, 2013 9:24 pm
by wellyworld
larsa wrote: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?
Re: conversion issue with Sheets[0].asError
Posted: Thu Oct 17, 2013 3:47 pm
by 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.