<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 - FORMATTING Wrap text automatically not working when value inserted using vlookup() function"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=131944">131944</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>FORMATTING Wrap text automatically not working when value inserted using vlookup() function
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>6.4.2.2 release
          </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>ovari123@zoho.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
FORMATTING Wrap text automatically not working when value inserted using
vlookup() function

Steps to Reproduce:
For cells B6 and E2, Format Cells, Alignment have:
* Horizontal: Left
* Vertical: Top
* Wrap text automatically: Enabled 

In cell A6, change the values between: 0, 1 and 2.

It is understood that the B6 and E2 cell sizes should change when more or less
space in required.

Are you able to reproduce and fix?

Thank you

Actual Results:
Cell sizes don't change to fix the data.

Expected Results:
Cell sizes should change (expand or reduce) to fill the data


Reproducible: Always


User Profile Reset: No



Additional Info:
Attachment will be added in the next entry as unfortunately there is no option
to add it now.

LibreOffice
Version: 6.4.2.2
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3; 
Calc: threaded

Linux Mint 19.3 Cinnamon 64-bit</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>