title: How do I make libreoffice calc update the referenced content from dropdown menus automatically?
body: <p>I assume this is only possible with macros, so any help with this would be appreciated because I never wrote a macro.</p>
  <p>Here's an explanation of what I'm trying to do:
  Let's say I have a table named <strong>categories</strong> with 2 entries:</p>
  <ol>
  <li>fruits</li>
  <li>vegetables</li>
  </ol>
  <p>In a second table I have a list of things with a dropdown menu next to them that uses the first table as a source for the selections, so it's easy pick their <strong>category</strong>:</p>
  <ol start="3">
  <li>apples -&gt; <strong>fruits</strong></li>
  <li>oranges -&gt; <strong>fruits</strong></li>
  <li>carrots -&gt; <strong>vegetables</strong></li>
  </ol>
  <p>If I change any field in my <strong>categories</strong> table (let's say I rename '<strong>fruits</strong>' to '<strong>sweet fruits</strong>'), the contents selected using the dropdowns won't update (it will still remain 'fruits') because after you select an element in a dropdown menu it uses the text value itself instead of a reference to a field in categories table, so I'm trying to figure out a way to change this to use references somehow, or update every dropdown when I change a category.</p>
  <p>Could someone please help me write a macro for doing this? What are your recommendations?</p>