Values depending on linked and not available spreadsheet - xls-viewer <> OOO

Hi *,

I've been asked my opinion about a nasty problem, described
here [1].
An Excel file does not show all correct values in OOo.

The final analyses (on the forum):
- the xls file contains reference to another spreadsheet;
- the another spreadsheet is not available;
- Excel viewer is able to show the right values;
- OOo is not.

So it looks as if the Excel viewer uses some data in the
file, that OOo
does not.

I cannot find anything about that in IssueTracker. Also at
usersOOo no 
reply.

Does anyone know this problem?
Is there an issue describing it?

Thanks,
Cor

1] http://www.oooforum.org/forum/viewtopic
.phtml?t=59180&highlight=excel
(includes screen prints and test file)

-- 

Cor Nouws
Arnhem - Netherlands
nl.OpenOffice.org - marketing contact


------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

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.
At least they require 
> >this in the help for the function. So they break
the own rules.

They probably don't break the rule, but for unsorted data
the so-called
sorted range lookup may deliver any result that fits for a
less-or-equal
query. The actual result delivered depends on the algorithm
used. It is
coincidence that Calc for that data constellation delivers
#N/A.

So whoever used the data for vital tasks in Excel or some
viewer should
carefully check the results it delivered with reality 

  Eike

-- 
 OOo/SO Calc core developer. Number formatter stricken i18n
transpositionizer.
 SunSign   0x87F8D412 : 2F58 5236 DB02 F335 8304  7D6C 65C9
F9B5 87F8 D412
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/Gu
llFOSS
 Please don't send personal mail to this erlsun.com
account, which I use for
 mailing lists only and don't read from outside Sun. Use
eracksun.com Thanks.