<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - Pivot table: page field filtering is not imported correctly from XLS"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=112348">112348</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Pivot table: page field filtering is not imported correctly from XLS
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>6.0.0.0.alpha0+ Master
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>normal
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Calc
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>zolnaitamas2000@gmail.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
Page field filtering is a bit different compared to other fields (row, column).
When only one item is selected the page field combobox cell shows this selected
entry. It seems LO's XLS import does not handle this kind of filtering well.
When I open such a document with LO Calc, all item are selected of the page
field, not the one which was selected in Excel.

Steps to Reproduce:
1. Open attached XLS in LO
2. Compare the page field selected items to MSO Excel

Actual Results:  
All items are selected.

Expected Results:
Only one item should be selected ("Banana")


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/60.0.3112.113 Safari/537.36</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>