I have been using OO 3.2 with good success. But upon installing and using
OO 3.3 I am encountering serious problems. That which I know so far is that
OO3.3 Spreadsheet will not carry out calculations wherin one or more
values are obtained via a VLOOKUP.function Specifically I have several
spreadsheets that obtain values from another spreadsheet. E.g. a specific code
is:
=VLOOKUP($A16;'file:///C:/Documents and Settings/jreyr/My
Documents/ATTACHE-FINANCE/GJJT last.xls'#$Sheet1.$A$2:$M$27;2;FALSE())
Numeric values are returned as text, e.g. '245, and calculations are not
carried out; Paste Special Numbers returns a blank cell. Calculations are
carried out OK with OO 3.2.
This situation with OO3.3 is unsatisfactory and is useless to me. Upon
installing OO3.3, OO 3.2 is gone. Is there a remedy to the VLOOKUP problem or
is OO3.2 available? The calculations are carried out daily, so I am in
real trouble with this and urgently await a reply.
s/G.G. Wire
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
