<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - [FILEOPEN] Importing a xlsx file with AutoFilter leaves ghost range definition"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=138704">bug 138704</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>NEW
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">CC</td>
           <td>
                
           </td>
           <td>libreoffice@nisz.hu
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Ever confirmed</td>
           <td>
                
           </td>
           <td>1
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - [FILEOPEN] Importing a xlsx file with AutoFilter leaves ghost range definition"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=138704#c4">Comment # 4</a>
              on <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - [FILEOPEN] Importing a xlsx file with AutoFilter leaves ghost range definition"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=138704">bug 138704</a>
              from <span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span></b>
        <pre>Confirming with the XLSX file in:

Version: 7.2.0.0.alpha0+ (x64)
Build ID: 796c7f612603490dda9277ced0f6ab3cce3bc116
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL

When row 1 is selected or the cursor is placed in a cell in the A-C columns
(and even D too - strange), the problem is reproducible. 
Works fine of the cursor is in a cell of E-F (etc...) columns.

When columns A-F are selected, all of them gets the new autofilter. But then
selecting row 1 and turning autofilter off and on makes it appear only in the
newly added D-F column - buggy behavior is inverted.

Also happens in older versions: 6.0, 5.0, 4.0, 3.5 - not a new regression.</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>