<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN: XLSX file: boolean values imported wrongly, consecutive values hidden" href="https://bugs.documentfoundation.org/show_bug.cgi?id=81350#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN: XLSX file: boolean values imported wrongly, consecutive values hidden" href="https://bugs.documentfoundation.org/show_bug.cgi?id=81350">bug 81350</a> from <a class="email" href="mailto:iagosrl@gmail.com" title="IagoSRL <iagosrl@gmail.com>"> IagoSRL</a> <pre>Hi, Sorry to don't answer to previous requests of re-testing. As seen at the related <a class="bz_bug_link bz_status_NEW " title="NEW - Libre Office corrupts boolean columns importing xlsx file" href="show_bug.cgi?id=86456">bug #86456</a>, the problem of 'hidden values' at consecutive rows with same value seems solved at version 5.4.0.3 (x64) Windows 7 SP1. From about me dialog: Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c CPU threads: 4; SO: Windows 6.1; UI render: default; Locale: es-ES (es_ES); Calc: group. I tested both the files I originally attached and the two files attached at #86456, and just like eisa01 commented there 'shows 0/1 with =FALSE()/TRUE(), so this may just be a presentation issue now?' Current fix is a good step forward, though. And yes, the <a class="bz_bug_link bz_status_NEW " title="NEW - Libre Office corrupts boolean columns importing xlsx file" href="show_bug.cgi?id=86456">bug #86456</a> and this older seems the same. But about the bug <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - FORMATTING: User Defined Custom Formatting is not applied during importing XLSX documents" href="show_bug.cgi?id=70565">https://bugs.documentfoundation.org/show_bug.cgi?id=70565</a> , don't know exactly what has fixed, but it seems a formatting bug still exist here. Steps to reproduce: - At Excel 2007 - New document, at different rows type values 'TRUE' and 'FALSE'. - Save as XLSX - Open In LibreOffice - It displays 1, 0 - Note: the formula bar at LibreOffice says =TRUE() , =FALSE() while at Excel still says TRUE , FALSE. - Additionally: if at Excel we type '=TRUE' and '=FALSE' (adding the equals sign), it displays the same both at Excel and LibreOffice, but LibreOffice shows at the formula bar =1 , =0 on this case.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>