title: How to define dynamic ranges on Calc (or Excel)?
body: <p>Let's say I have a Libreoffice.org Calc (maybe this goes for MS Excel too) object defined as the range <code>$Sheet1.$A$1:$A$4</code>.</p>
  
  <p>I also have declared a constant with value 1. For this mockup purpose, let's call it <code>startingLine</code>.</p>
  
  <p>Both objects are properly defined in the Define Names dialog (shortcut: Ctrl+F3).</p>
  
  <p>What I would like to do is to turn the <em>lines</em> of the defined range into variables. In my mind, all it'd take would be to define it like this: <code>$Sheet1.$A$startingLine:$A$4</code>, but this doesn't work. :-/</p>
  
  <p>I'm looking for a simple spreadsheet solution, unfortunately macros won't do it for me this time. A solution using R1C1 reference would be good enough, though. :)</p>
  
  <p>Any help will be <em>greatly</em> appreciated!</p>