Eike Rathke schrieb:
Hi Cor,
On Thursday, 2008-04-17 10:10:19 +0200, Cor Nouws wrote:
Easy to fix as you suggested. Only saving as xls and re-opening, again
shows #NA ...
Saving as ods does save the results.
It seems that interim results of external references aren't saved to
Excel file format. Daniel?
They are saved as long as the referenced range does not exceed a size of
1024 cells. This has been done to prevent memory problems with files
that reference an entire sheet in an external document, see
http://www.openoffice.org/issues/show_bug.cgi?id=70418. AFAIK, Excel
does only save the results of non-empty external cells, that would be an
option for the export filter too.
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]