I am working with a very simple test app I have built in XE7. I am filling cells in a new sheet from a dataset. First I fill a row with header captions, then fill subsequent rows with data. Finally, I call:
XLS.Save(FileName);
I get exception $C0000005. I have traced into code and found that in _UXlsAdapterFile.XlsFile, in the TXlsFile.Recalc routine, it fails in this code:
if forced or PendingRecalc then
begin
FWorkbook.CleanFlags;
FWorkbook.Recalc(Self, nil); <--- failse on this call
end;
If I do not write any rows of data, but do write the headers, it does not fail. If need be, I can send a project which is relatively small. But I really am challenged to understand how I can get through the writing of a row of data -- I reduced it to a single row for testing -- without an exception, but it throws the exception in the call to save.
I am writing only three kinds of data to the cells: Integer, Float, or String.
What can I possibly do in those operations which would result in a memory error affecting the save?
Thanks,
Bill Meyer