[discuss] Open Office 3.3

[Jr...@aol.com]

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