Fwd: Open Office 3.3 Problems
[email protected] Tue, 22 Nov 2011 15:45:07 -0500 (EST)
| Newsgroups | gmane.comp.openoffice.general |
|---|---|
| Message-ID | <[email protected]> |
--part1_1c68.112b43de.3bfd63d3_boundary Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Further to the subject, I continue to encounter anomolies and misfunctions: Re. the "VLOOKUP(), the references are to *.cvx, i.e. comma (,) delimited spreadsheets. Each time the objective file is opened (i.e. referring file), OO 3.3 brings up "Text Import" to convert to an *.xls.format. I save all files in .xls format to maintain compatability. With OO 3.2 upon first time import I would convert to *.xls format; thereafter with each opening of the objective file, upon clicking "Update), the file would open updated from all imported files. The previously mentioned problem, that "Paste Special"-numbers & formats only from a VLOOKUP cell, pastes an empty cell. This rendere OO 3.3 useless to me. Is OO 3.3 the latest version?, If there is a more recent version I would try it. Otherwise, I either need OO 3.2 or must go to another office program. I can't imagine the problems are unique to my applications. What say you? ____________________________________ From: [email protected] To: [email protected], [email protected] Sent: 11/21/2011 5:01:05 P.M. Pacific Standard Time Subj: Fwd: Open Office 3.3 Further to the subject email, below, also "Paste Special", numbers & formats will not paste any value; it is blank; "Paste Special"-text, numbers & formats pastes the numeric value as text, and so calculation still will not occur. Attempt to Paste Special again eliminating "text" yields blank cells. Right now I am out of business with OO 3.3! ____________________________________ From: [email protected] To: [email protected], [email protected] Sent: 11/21/2011 4:46:17 P.M. Pacific Standard Time Subj: 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 -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help --part1_1c68.112b43de.3bfd63d3_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>Further to the subject, I continue to encounter anomolies and=20 misfunctions: Re. the "VLOOKUP(), the references are to *.cvx, i= .e.=20 comma (,) delimited spreadsheets. Each time the objective file is opened (i= .e.=20 referring file), OO 3.3 brings up "Text Import" to convert to an *.xls.form= at. I=20 save all files in .xls format to maintain compatability. With OO 3.2 upon f= irst=20 time import I would convert to *.xls format; thereafter with each open= ing=20 of the objective file, upon clicking "Update), the file would open updated = from=20 all imported files. </DIV> <DIV> </DIV> <DIV>The previously mentioned problem, that "Paste Special"-numbers &=20 formats only from a VLOOKUP cell, pastes an empty cell. This rendere OO 3.3= =20 useless to me.</DIV> <DIV> </DIV> <DIV>Is OO 3.3 the latest version?, If there is a more recent version I wou= ld=20 try it. Otherwise, I either need OO 3.2 or must go to another office progra= m. I=20 can't imagine the problems are unique to my applications. What say you?</DI= V> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: blue 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px"> <DIV style=3D"FONT-FAMILY: 'Arial'; FONT-SIZE: 10pt"> <HR> From: [email protected]<BR>To: [email protected],=20 [email protected]<BR>Sent: 11/21/2011 5:01:05 P.M. Pacific Standar= d=20 Time<BR>Subj: Fwd: Open Office 3.3<BR></DIV> <DIV> </DIV><FONT style=3D"BACKGROUND-COLOR: transparent" color=3D#0= 00000=20 size=3D2 face=3DArial><FONT color=3D#000000 size=3D2 face=3DArial> <DIV>Further to the subject email, below, also "Paste Special", numbers &= amp;=20 formats will not paste any value; it is blank; "Paste Special"-text, numb= ers=20 & formats pastes the numeric value as text, and so calculation still = will=20 not occur. Attempt to Paste Special again eliminating "text" yields blank= =20 cells. Right now I am out of business with OO 3.3!</DIV> <DIV> </DIV> <DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: blue 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px= "> <DIV style=3D"FONT-FAMILY: 'Arial'; FONT-SIZE: 10pt"> <HR> From: [email protected]<BR>To: [email protected],=20 [email protected]<BR>Sent: 11/21/2011 4:46:17 P.M. Pacific Stand= ard=20 Time<BR>Subj: Open Office 3.3<BR></DIV> <DIV> </DIV><FONT style=3D"BACKGROUND-COLOR: transparent" color=3D= #000000=20 size=3D2 face=3DArial><FONT color=3D#000000 size=3D2 face=3DArial> <DIV>I have been using OO 3.2 with good success. But upon installing an= d=20 using OO 3.3 I am encountering serious problems. That which I know so f= ar 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 anothe= r=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, th= e=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 prob= lem=20 or is OO3.2 available? The calculations are carried out daily, so I am&= nbsp;=20 in real trouble with this and urgently await a reply.</DIV> <DIV> </DIV> <DIV>s/G.G.=20 Wire</DIV></FONT></FONT></BLOCKQUOTE></DIV></FONT></FONT></BLOCKQUOTE></DIV= ></FONT></BODY></HTML>= --part1_1c68.112b43de.3bfd63d3_boundary--