title: How to get correct Row with FilterView?
body: <p>How can I get the correct cell that is selected in a <code>FilterView</code>?</p>
  <p>if a <code>FilterView</code> is used, the Script can't get the real cell selected. Only the main data cell.</p>
  <p>the code:</p>
  <pre><code>function myFunction() {
    var Value = SpreadsheetApp.getActive().getCurrentCell().getValue()
    Logger.log(Value)
  }
  </code></pre>
  <p>Without the filter view and selecting B4 it should show Clare, and with the filter view it should show Arne but it still show Clare.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1TZEh2MAOpaZFAGOodWv5-J57xX_N5mN0Ws8v_PwqXbI/edit?usp=drive_web" rel="nofollow noreferrer">This is the FilterView problem</a></p>
  <p><em>(Filterview is sorted on the first column in an onther way then without filterview)</em></p>