AsVariant and null hangs on error

[zvasku]

Hello,

If I set null to AsVariant(col,row), application raises exception and excel file is corrupted. AsVariant function should handle null state properly.

Thanks
Zdenek

[larsa]

Hello

The component is handling it properly. You get an exception. You can't assign a null value to a cell.

[zvasku]

I think it's not good behaviour. If I set Null to cell using AsVariant, cell should be cleared. Thats's why we use variants with nulls.

This should work directly like this:

XLS[].AsVariant[]:=Dataset.Fields[].AsVariant

[larsa]

Hello

AsVariant has worked this way since it was introduced several years ago, It's expected to work this way.