Re: [sc-dev] Values depending on linked and not available spreadsheet - xls-viewer OOO

2008-04-25 Thread Daniel Rentz
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

Re: [sc-dev] Values depending on linked and not available spreadsheet - xls-viewer OOO

2008-04-23 Thread Eike Rathke
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

Re: [sc-dev] Values depending on linked and not available spreadsheet - xls-viewer OOO

2007-10-18 Thread Frank Stecher - Sun Germany QA Engineer - ham02 - Hamburg
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

Re: [sc-dev] Values depending on linked and not available spreadsheet - xls-viewer OOO

2007-10-18 Thread Eike Rathke
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.