OpenOffice 3.3 VLOOKUP anomolie
[email protected] Sun, 18 Dec 2011 15:02:22 -0500 (EST)
| Newsgroups | gmane.comp.openoffice.questions |
|---|---|
| Message-ID | <[email protected]> |
--part1_2786.44e23b5d.3c1fa0ce_boundary Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 --part1_2786.44e23b5d.3c1fa0ce_boundary Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3DUS-ASCII" http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.6001.19170"></HEAD> <BODY style=3D"FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" id=3Dro= le_body=20 bottomMargin=3D7 leftMargin=3D7 rightMargin=3D7 topMargin=3D7><FONT id=3Dro= le_document=20 color=3D#000000 size=3D2 face=3DArial> <DIV> =20 <DIV>I have been using OO 3.2 with good success. But upon installing and us= ing=20 OO 3.3 I am encountering serious problems. That which I know so far is=20 that OO3.3 Spreadsheet will not carry out calculations=20 wherin one or more values are obtained via a VLOOKUP.function=20 Specifically I have several spreadsheets that obtain values from another=20 spreadsheet. E.g. a specific code is:</DIV> <DIV> </DIV> <DIV>=3DVLOOKUP($A16;'file:///C:/Documents and Settings/jreyr/My=20 Documents/ATTACHE-FINANCE/GJJT last.xls'#$Sheet1.$A$2:$M$27;2;FALSE())</DIV> <DIV> </DIV> <DIV>Numeric values are returned as text, e.g. '245, and calculations are n= ot=20 carried out; Paste Special Numbers returns a blank cell. Calculations are=20 carried out OK with OO 3.2. </DIV> <DIV> </DIV> <DIV>This situation with OO3.3 is unsatisfactory and is useless to me. Upon= =20 installing OO3.3, OO 3.2 is gone. <STRONG>Is there a remedy to the VLOOKUP= =20 problem or is OO3.2 available?</STRONG> The calculations are carried out da= ily,=20 so I am in real trouble with this and urgently await a reply.</DIV> <DIV> </DIV> <DIV>s/G.G. Wire</DIV></DIV></FONT></BODY></HTML>= --part1_2786.44e23b5d.3c1fa0ce_boundary--