Axolot Data

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

Hello

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

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

Hello

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