Re: [libreoffice-users] Use of variables in a cell

I think you just introduced another set of questions.

Is the "&" used for macro substitution?  If so, how does that fit in?

I assume the lowercase n is a shorthand way of defining the variable 
type (n=number, s=string, etc.), and not part of the formula?

I went to Help with indirect(), not to much avail.  I think I am not 
grasping your solution.  Also, how do I assign the variable value, and, 
in terms of sequential execution, where do I put the assignment so it 
will be executed before the indirect() function?

Is it executed only once? Meaning, if I jump to a cell with my mouse 
(manual), is it possible that the indirect() function will fail because 
the assignment was not reread?  (I am thinking in terms of procedural 
code here (Basic, Pascal, xBase).

John



On 07/20/2016 09:35 AM, Brian Barker wrote:
> At 08:50 20/07/2016 -0700, John R. Sowden wrote:
> > If I have a cell with following formula, can I replace a cell 
> > coordinate, such as the 52 below, with a variable that I can assign 
> > at the top of my spreadsheet?
> > =sum(a1:a52)
>
> Yes:
> =SUM(INDIRECT("A1:A"&Xn))
>
> I trust this helps.
>
> Brian Barker



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted