Quattro Pro for windows: QUESTION

Thread View: comp.apps.spreadsheets

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Richard van der Veen Mon, 25 Jan 1993 10:28

#303

Author: Richard van der Veen
Date: Mon, 25 Jan 1993 10:28

35 lines
1666 bytes

Hi there,

I have the following problem and I hope that someone can help me:

When I use macros to print a spreadsheet, I want to enter the number of
copies dynamically. So I put the following statement in my macro:

    {GetLabel Number of Copies, _Copies}

where _Copies is a named cell. Now I want to use the _Copies name in one
of the following statements, which should be like:

    {Print.Copies _Copies}

The result is

    Invalid number {Print.Copies}
    (Cell Address)

How can you use named cells in such macros ??

Thanks in advance,

Richard.

===============================================================================
 ______              _      __       / Richard v.d. Veen                     /
|  __  \          _ | |    / /      / Voice: +31-(0)79-531624               /
| |__| | _   _   | || |   / /  ____/ E-mail: .....sun4nl!ktibv!rvdv    ____/
|  _  _/| | / /__| || |  / /  /                                       /
| | \ \ | |/ /| __ || |_/ /  /  Me, I'm just a lawnmower,            /
|_|  \_\|___/ |____||____/  /  You can tell me by the way I walk.   /
--------------------------------------------------------------------
KTI BV, P.O. Box 86, 2700 AB  Zoetermeer, The Netherlands         /
------------------------------------------------------------------

Re: Quattro Pro for windows: QUESTION

#306

Author: Wailer at the Gates of Dawn
Date: Mon, 25 Jan 1993 22:56

21 lines
1397 bytes

rvdv@ktibv.uucp (Richard van der Veen) writes:
>When I use macros to print a spreadsheet, I want to enter the number of
>copies dynamically. So I put the following statement in my macro:
>    {GetLabel Number of Copies, _Copies}
>where _Copies is a named cell. Now I want to use the _Copies name in one
>of the following statements, which should be like:
>    {Print.Copies _Copies}

>How can you use named cells in such macros ??

{SetObjectProperty "Print.Copies", +_Copies}

{Print.Copies +A1} _should_ work, but doesn't appear to.  I will submit this
as a bug.

-- 
The Wailer at the Gates of Dawn              | banshee@cats.UCSC.EDU       |
Just who ARE you calling a FROOFROO Head?    |                             |
DoD#0667  "Just a friend of the beast."      | banshee@ucscb.UCSC.EDU      |
2,3,5,7,13,17,19,31,61,89,107,127,521,607....| banshee@ucscb.BITNET        |

Re: Quattro Pro for windows: QUESTION

#309

Author: Tom J Parry
Date: Tue, 26 Jan 1993 05:49

22 lines
1288 bytes

Richard van der Veen (rvdv@ktibv.uucp) wrote:
>     {GetLabel Number of Copies, _Copies}

> where _Copies is a named cell. Now I want to use the _Copies name in one
> of the following statements, which should be like:

>     {Print.Copies _Copies}

> The result is

>     Invalid number {Print.Copies}
>     (Cell Address)

> How can you use named cells in such macros ??

You could use a self-modifying macro that creates the {Print.Copies line
with the string equivalent of _Copies in it, just before executing it. I've
used similar tactics before to get around some macro inadequacies.

-- 
Tom J Parry.
Your reality is a figment of my imagination.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads