Re: Digest for list [email protected]

--f46d044472bbac025104b2645e53
Content-Type: text/plain; charset=ISO-8859-1

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

--f46d044472bbac025104b2645e53
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<p>Have you tried ooo 3.4?<br>
</p>
<div class=3D"gmail_quote">On Nov 23, 2011 5:47 AM,  &lt;<a href=3D"mailto:=
[email protected]">[email protected]</a>&gt; wrot=
e:<br type=3D"attribution"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Table of contents:<br>
<br>
1. [discuss] Open Office 3.3 - <a href=3D"mailto:[email protected]">[email protected]=
om</a><br>
<br>
<br><br>---------- Forwarded message ----------<br>From:=A0<a href=3D"mailt=
o:[email protected]">[email protected]</a><br>To:=A0<a href=3D"mailto:discuss@openo=
ffice.org">[email protected]</a>, [email protected]<br>Date:=A0=
Mon, 21 Nov 2011 19:46:17 -0500 (EST)<br>
Subject:=A0[discuss] Open Office 3.3<br><u></u>



<div style=3D"FONT-FAMILY:Arial;COLOR:#000000;FONT-SIZE:10pt"><font color=
=3D"#000000" size=3D"2" face=3D"Arial">
<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=A0OO3.3 Spreadsheet =A0will not carry out calculations=20
wherin=A0one or more=A0values are obtained via a VLOOKUP.function=20
Specifically I have several spreadsheets that obtain values from another=20
spreadsheet. E.g.=A0a specific code is:</div>
<div>=A0</div>
<div>=3DVLOOKUP($A16;&#39;file:///C:/Documents and Settings/jreyr/My=20
Documents/ATTACHE-FINANCE/GJJT last.xls&#39;#$Sheet1.$A$2:$M$27;2;FALSE())<=
/div>
<div>=A0</div>
<div>If I paste special so that the actual numeric value is present, the=20
calculations proceed OK.</div>
<div>=A0</div>
<div>Calculations are carried out OK with OO 3.2. </div>
<div>=A0</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=A0 in real=
=20
trouble with this and urgently await a reply.</div>
<div>=A0</div>
<div>s/G.G. Wire</div></font></div><br>End of digest for list <a href=3D"ma=
ilto:[email protected]">[email protected]</a> - Wed, 23 Nov 2011<=
br>
<br></blockquote></div>

--f46d044472bbac025104b2645e53--