[Libreoffice-bugs] [Bug 81350] FILEOPEN: XLSX file: boolean values imported wrongly, consecutive values hidden

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=81350

--- Comment #8 from IagoSRL <iagosrl at gmail.com> ---
Hi,

Sorry to don't answer to previous requests of re-testing.

As seen at the related bug #86456, 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 bug #86456 and this older seems the same.
But about the bug https://bugs.documentfoundation.org/show_bug.cgi?id=70565 ,
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170827/d92cc2f8/attachment.html>