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
