<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:jmadero.dev@gmail.com" title="Joel Madero <jmadero.dev@gmail.com>"> <span class="fn">Joel Madero</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED INVALID - Enhancement to Calc functions MATCH, HLOOKUP and VLOOKUP"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=107371">bug 107371</a>
          <br>
             <table border="1" cellspacing="0" cellpadding="8">
          <tr>
            <th>What</th>
            <th>Removed</th>
            <th>Added</th>
          </tr>

         <tr>
           <td style="text-align:right;">Status</td>
           <td>UNCONFIRMED
           </td>
           <td>RESOLVED
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">CC</td>
           <td>
                
           </td>
           <td>jmadero.dev@gmail.com
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Resolution</td>
           <td>---
           </td>
           <td>INVALID
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED INVALID - Enhancement to Calc functions MATCH, HLOOKUP and VLOOKUP"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=107371#c1">Comment # 1</a>
              on <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED INVALID - Enhancement to Calc functions MATCH, HLOOKUP and VLOOKUP"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=107371">bug 107371</a>
              from <span class="vcard"><a class="email" href="mailto:jmadero.dev@gmail.com" title="Joel Madero <jmadero.dev@gmail.com>"> <span class="fn">Joel Madero</span></a>
</span></b>
        <pre>Hi David,

Please don't report multiple requests in a single report. Closing this as
INVALID. Enhancement reports just like bug reports need to be 1 issue per bug
report.

As for the specific requests, they seem VERY unlikely to be implemented for
various reasons:

1) This would cause some interop issues that we try to avoid when possible
because people will then start yelling and screaming when they take a
spreadsheet to work (or send it to a colleague) and see different results in
Excel;

2)Can you provide an example of where this one would be useful? Is this how
Excel handles it?

3)Again, example and is this how Excel does it.

I know it's not ideal to be limited by Excel but it is the general standard. If
we want to avoid hundreds of interop bug reports and angry users who see
differences between the applications, we aim for interop over features that
likely would only help 1 or 2 people.

Please take these things into consideration as you decide whether to create new
tickets. Thanks.</pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>