Re: OpenOffice calc question

From: Fielder George Dowding <fgdowding@iceworm-enterprises.net>
Date: Tue Jun 27 2006 - 14:32:05 AKDT

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

bob@estimations wrote:
> I'm trying to migrate some spreadsheet templates from Excel over to
> OpenOffice, but am running into some snags. Here's one that has me stumped.
> Lets say I have a number of different lookup tables in a spreadsheet,
> and I want to put a value in a cell to tell a vlookup command which
> table to use. For example, the formula:
>
> =VLOOKUP(B18;lookuptablename;2;0) works ok in both programs.
>
> As does
>
> =INDIRECT(B12) (Lets say that I have the text string
> "lookuptablename" in B12. The INDIRECT formula pointing to it above
> returns that string. (One difference I note between the two programs
> is that in OO, the cell reference needs to be quoted.)
>
> But when I try to combine them into =VLOOKUP(B19;INDIRECT(B12);2;0),
> it works ok in excel, but not in OO Calc. (even when I put "B12" in quotes.)
>
> Attached is a sample spreadsheet that shows what I'm talking about.
> It works in excel. Note cell C18. It evaluates correctly in excel,
> but not in OO.
>
> Any suggestions will be appreciated.
>
> Thanks,
>
> Bob Crosby
>
>
> -- Binary/unsupported file stripped by Ecartis --
> -- Type: application/octet-stream
> -- File: IndirectLookupTest.xls
>
>
> ---------
Hi Bob, the list server strips attachments so can you put the file up on
a web site?

- --
Fielder George Dowding, Chief Iceworm .^. Debian/GNU Linux
dba Iceworm Enterprises, Anchorage, Alaska /v\ "etch" Testing
Since 1976 - Over 30 Years of Service. /( )\ User Number 269482
                                            ^^-^^ "irad" 301256
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEobHk2kl99FX0AIkRAvyKAKCjPnNEDb5ku3cWrMG0TU7XDKwl5wCdHYOQ
FKO1EWtgxpgo9dpjqNqOKEs=
=OumF
-----END PGP SIGNATURE-----
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Tue Jun 27 14:30:32 2006

This archive was generated by hypermail 2.1.8 : Tue Jun 27 2006 - 14:30:32 AKDT