spreadsheets: linking cells

[Hippocode]

I have a spreadsheet that shows some objects in a particular layer.

Is it possible to link parts of the database selection critera to cells ?

=DATABASE((INSYMBOL & INOBJECT & (L='niv +1 elektriciteit') & (T=SYMBOL) & (R IN ['TDE_00 algemeen']) & (NOT (R IN ['TDE_72 verlichting'])) & (NOT (R IN ['TDE_71 schakelaars'])) & (R IN ['TDE_70 elektriciteit'])))

Changing (L='niv +1 elektriciteit') to L=A1 or 'A1' with A1 containing the layer name does not work.

Any workaround for this ?

Edited June 21, 2012 by hippothamus

[Pat Stanford]

Try setting cell A1 to L='niv +1 elektriciteit'

Then set the criteria to =database ((Insymbol & INOBJECT & A1 & ...

If that works then see if you can use the concat function to put the layer name only is one cell and make the string you need in another.

[Hippocode]

Try setting cell A1 to L='niv +1 elektriciteit'

Then set the criteria to =database ((Insymbol & INOBJECT & A1 & ...

If that works then see if you can use the concat function to put the layer name only is one cell and make the string you need in another.

Won't work.

Making one cell with the whole databasestring in and pointing the db criteria to that cell won't work either.

[Assembly]

I am using a similar set up for componet areas like this:

=COMPONENTAREA(((WST=$A11)), $B11)

Where

A11=SIDE-WBRD_V/Cav/140/Ply-V

B11=1

Note there are no quote marks in A11

Please let us know if that makes the difference.

[Hippocode]

That seems to work.

L=$A2 for example works if I remove the '' in A2.

Adding L= to the string is what I did wrong

Thanks