Open Office 3.3
[email protected] Mon, 21 Nov 2011 19:46:17 -0500 (EST)
| Newsgroups | gmane.comp.openoffice.general |
|---|---|
| Message-ID | <[email protected]> |
--part1_6b6a7.247fbd3c.3bfc4ad9_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()) 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-- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help --part1_6b6a7.247fbd3c.3bfc4ad9_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.19154"></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>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>If I paste special so that the actual numeric value is present, the=20 calculations proceed OK.</DIV> <DIV> </DIV> <DIV>Calculations are carried out OK with OO 3.2. </DIV> <DIV> </DIV> <DIV>This situation with OO3.3 is unsatisfactory and is uselrss to me. Upon= =20 installing OO3.3, OO 3.2 is gone. Is there a remedy to the VLOOKUP problem = or is=20 OO3.2 available? The calculations are carried out daily, so I am in r= eal=20 trouble with this and urgently await a reply.</DIV> <DIV> </DIV> <DIV>s/G.G. Wire</DIV></FONT></BODY></HTML>= --part1_6b6a7.247fbd3c.3bfc4ad9_boundary--