[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 #10 from IagoSRL <iagosrl at gmail.com> ---
Hi,

I can confirm this still happens as of today latest version in same way as last
update at Comment #8.

Versión: 6.1.0.3 (x64)
Id. de compilación: efb621ed25068d70781dc026f7e9c5187a4decd1
Subprocs. CPU: 4; SO: Windows 10.0; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: CL
Changelog:
https://gerrit.libreoffice.org/gitweb?p=core.git&a=log&h=efb621ed25068d70781dc026f7e9c5187a4decd1


In addition, I just verified that the values showed at the formula bar are the
same in the XLSX file created with Excel 2007 (first attachment) and
LibreOffice (fourth attachment), but the formatting is different:
- For the one created with Excel: Libreoffice displays "1, 1, 0, 0, 0..."
- For the one created with LO: Libreoffice displays "TRUE, TRUE, TRUE, FALSE,
FALSE,..."

I reviewed the cell formatting options, and they have:
- For the one created with Excel: Standard number formatting
- For the one created with LO: User defined formatting, with format
"TRUE";"TRUE";"FALSE"

It seems weird that no file have chosen the 'boolean formatting' option. If I
apply that manually to both file, the display is the correct one, identical on
both.

What I cannot confirm now is if the XLSX format, or that Excel 2007 version,
supports the 'boolean bormatting', in case that happens and is the issue (and
the reason why LO chose to save the file with a custom formatting). If that's
the case, maybe have changed in recent format/program versions, someone knows?

-- 
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/20180828/8711d9a5/attachment.html>