Hi, <div><br></div><div>I just downloaded LibreOffice Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)</div><div>The problem is still there but with ERR.502 instead of #value</div><div><br></div><div>Please have a look on the attached screenshot</div>

<div>On the left it is the document opened with Apache OpenOffice 3.4 (last stable vesion but document is opening ok since at least OpenOffice 3.0)  and on the right the same document opened with the last LibreOffice stable version (4.0.0.3)</div>

<div>The good version of course is the one on the left</div><div><br></div><div>Just in case, i precise the shown document is the one attached to the bug report<br><br>Thank you for your help !</div><div><br></div><div><br>

</div><div>Best regards</div><div>-</div><div>-</div><div>Nassim Bennouna</div><div><br><div class="gmail_quote">On Sun, Jan 27, 2013 at 9:42 PM,  <span dir="ltr">&lt;<a href="mailto:bugzilla-daemon@freedesktop.org" target="_blank">bugzilla-daemon@freedesktop.org</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
    
      
    
    <div><span><a href="mailto:joren.libreoffice@telenet.be" title="Jorendc &lt;joren.libreoffice@telenet.be&gt;" target="_blank"> <span>Jorendc</span></a>
</span> changed
              <a title="NEEDINFO --- - ods document displays #values" href="https://bugs.freedesktop.org/show_bug.cgi?id=57447" target="_blank">bug 57447</a>
        <br>
             <table border="1" cellspacing="0" cellpadding="8">
          <tbody><tr>
            <th>What</th>
            <th>Removed</th>
            <th>Added</th>
          </tr>

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

         <tr>
           <td style="text-align:right">QA Contact</td>
           <td>
                
           </td>
           <td><a href="mailto:joren.libreoffice@telenet.be" target="_blank">joren.libreoffice@telenet.be</a>
           </td>
         </tr>

         <tr>
           <td style="text-align:right">Ever confirmed</td>
           <td>
                
           </td>
           <td>1
           </td>
         </tr></tbody></table>
      <p>
        </p><div>
            <b><a title="NEEDINFO --- - ods document displays #values" href="https://bugs.freedesktop.org/show_bug.cgi?id=57447#c2" target="_blank">Comment # 2</a>
              on <a title="NEEDINFO --- - ods document displays #values" href="https://bugs.freedesktop.org/show_bug.cgi?id=57447" target="_blank">bug 57447</a>
              from <span><a href="mailto:joren.libreoffice@telenet.be" title="Jorendc &lt;joren.libreoffice@telenet.be&gt;" target="_blank"> <span>Jorendc</span></a>
</span></b>
        <pre>I can&#39;t confirm this behavior; But in some cells I can confirm there are some
ERROR:508 in it. (see <a title="UNCONFIRMED --- - FILEOPEN: Importing a spreadsheet with AVERAGE() result in many ERROR:508" href="https://bugs.freedesktop.org/show_bug.cgi?id=59916" target="_blank">Bug 59916</a>). Can you please confirm you still have
&#39;#value&#39; or &#39;ERROR:508&#39; otherwise with LibreOffice 4.0.0.2 rc2 if possible?

Therefore I mark this bug as NEEDINFO</pre>
        </div>
      <p></p>
      <hr>
      <span>You are receiving this mail because:</span>
      
      <ul>
          <li>You reported the bug.</li>
      </ul>
    </div>

</blockquote></div><br><br clear="all"><div><br></div>-- <br>Cordialement<div>--<div>--</div><div>Nassim Bennouna</div></div><div><br></div>
</div>