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).
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?
I trust this helps.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy