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

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 the help for the function. So they break the own
rules.

The problem can be solved either by sorting the search
vector or setting 
the parameter (zero or false) for unsorted search vectors in
the vlookup 
formula.

Frank

Cor Nouws wrote:
> 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)
> 

-- 
Sun Microsystems GmbH, Frank Stecher
Quality Assurance StarOffice Calc
Nagelsweg 55
Hamburg 20097 DE
Phone x66636 / +49 40 23 646 636
Email Frank.StecherSun.COM
http://www.sun.de/starof
fice

Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee
1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering

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

Hi Frank,

Frank Stecher wrote (18-10-2007 10:03)

> 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 the help for the function. So they break the
own rules.
> 
> The problem can be solved either by sorting the search
vector or setting 
> the parameter (zero or false) for unsorted search
vectors in the vlookup 
> formula.


Thanks! See that I get it working,


-- 

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