Have you tried ooo 3.4? On Nov 23, 2011 5:47 AM, <[email protected]> wrote:
> Table of contents: > > 1. [discuss] Open Office 3.3 - [email protected] > > > > ---------- Forwarded message ---------- > From: [email protected] > To: [email protected], [email protected] > Date: Mon, 21 Nov 2011 19:46:17 -0500 (EST) > Subject: [discuss] 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 > > End of digest for list [email protected] - Wed, 23 Nov 2011 > > -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
