Open Office 3.3 Problems

[J***@aol.com]

Further to the subject, I continue to encounter anomolies and
misfunctions: Re. the "VLOOKUP(), the references are to *.cvx, i.e. comma (,)
delimited spreadsheets. Each time the objective file is opened (i.e. referring
file), OO 3.3 brings up "Text Import" to convert to an *.xls.format. I save all
files in .xls format to maintain compatability. With OO 3.2 upon first
time import I would convert to *.xls format; thereafter with each opening of
the objective file, upon clicking "Update), the file would open updated from
all imported files.

The previously mentioned problem, that "Paste Special"-numbers & formats
only from a VLOOKUP cell, pastes an empty cell. This rendere OO 3.3 useless
to me.

Is OO 3.3 the latest version?, If there is a more recent version I would
try it. Otherwise, I either need OO 3.2 or must go to another office program.
I can't imagine the problems are unique to my applications. What say you?





____________________________________
From: ***@aol.com
To: ***@openoffice.org, ***@Sun.COM
Sent: 11/21/2011 5:01:05 P.M. Pacific Standard Time
Subj: Fwd: Open Office 3.3


Further to the subject email, below, also "Paste Special", numbers &
formats will not paste any value; it is blank; "Paste Special"-text, numbers &
formats pastes the numeric value as text, and so calculation still will not
occur. Attempt to Paste Special again eliminating "text" yields blank
cells. Right now I am out of business with OO 3.3!



____________________________________
From: ***@aol.com
To: ***@openoffice.org, ***@Sun.COM
Sent: 11/21/2011 4:46:17 P.M. Pacific Standard Time
Subj: Open Office 3.3


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())

If I paste special so that the actual numeric value is present, the
calculations proceed OK.

Calculations are carried out OK with OO 3.2.

This situation with OO3.3 is unsatisfactory and is uselrss 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