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
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?
Eike
Hi Cor,
the problem is not the missing linked file, at least not with OOo2.3.
The problem is the unsorted search vector used with the VLOOKUP
functions in column H. Excel requires a sorted search vector for the
vlookup as used in the column as well as Calc do. At least they require
this in
Hi Cor,
On Thursday, 2007-10-18 11:38:21 +0200, Cor Nouws wrote:
Frank Stecher wrote (18-10-2007 10:03)
The problem is the unsorted search vector used with the VLOOKUP
functions in column H. Excel requires a sorted search vector for the
vlookup as used in the column as well as Calc do.