<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 - PDF export of spreadsheet forms change fields positions in page"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=124021">124021</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>PDF export of spreadsheet forms change fields positions in page
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>6.1.5.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>Printing and PDF export
          </td>
        </tr>

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

        <tr>
          <th>Reporter</th>
          <td>olivier.hallot@documentfoundation.org
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=149910" name="attach_149910" title="Source file with fields in right position">attachment 149910</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=149910&action=edit" title="Source file with fields in right position">[details]</a></span>
Source file with fields in right position

The attached spreadsheet form display fields correctly positioned and *all*
fields (text box, radio buttons, list box) are anchored in cell and their size
were set "adjust size to cell size" (or the like in English), using context
menu on selected fields.

Symptom: On exporting to PDF form, the fields are shifted to wrong position,
often overlapped and makes PDF form unusable. 

Some hints:
* The effect seems random. Sometimes it works, sometimes it produces a messy
PDF.
* it seems to depend on saving and reopening the file
* on adding or removing lines/columns/cells, 
* perhaps on cell position recalculation in page, with effect on anchoring. 
* On cell rendering, the field anchoring changes, seems to shift to a neighbor
cell
* field size does not follow cell size.
* suspicion on rounding number for cell position and field position
calculation.
* suspicion on memory leak or uninitialized variable.

Affects LibreOffice 6.1.5 and later, not tested with earlier versions.

Tested on Linux (6.2.1 and okular) and Windows (LO 6.1.5, with display in
Acrobat Reader DC)</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>