<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:gerard.fargeot@orange.fr" title="GerardF <gerard.fargeot@orange.fr>"> <span class="fn">GerardF</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED NOTABUG - Third argument to MID() should be optional for better Basic compatibility"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=135934">bug 135934</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;">CC</td>
           <td>
                
           </td>
           <td>gerard.fargeot@orange.fr
           </td>
         </tr>

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

         <tr>
           <td style="text-align:right;">Resolution</td>
           <td>---
           </td>
           <td>NOTABUG
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED NOTABUG - Third argument to MID() should be optional for better Basic compatibility"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=135934#c1">Comment # 1</a>
              on <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED NOTABUG - Third argument to MID() should be optional for better Basic compatibility"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=135934">bug 135934</a>
              from <span class="vcard"><a class="email" href="mailto:gerard.fargeot@orange.fr" title="GerardF <gerard.fargeot@orange.fr>"> <span class="fn">GerardF</span></a>
</span></b>
        <pre>You confuse spreadsheet function with macro function.

The lenght argument fot MID function is not optional in both Calc and Excel.
The basic function Mid in Calc and the vba function Mid in Excel have an
optional lenght argument.</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>