https://bugs.freedesktop.org/show_bug.cgi?id=81350
Priority: medium
Bug ID: 81350
Assignee: [email protected]
Summary: XLSX file: boolean values imported wrongly,
consecutive values hidden
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: filters and storage
Product: LibreOffice
Created attachment 102774
--> https://bugs.freedesktop.org/attachment.cgi?id=102774&action=edit
Boolean values created on Excel 2007
An XLSX file with well formatted boolean values is showed as numbers 1 or 0
rather than special words TRUE or FALSE and boolean formatting, and any
consecutive values (sibling rows) are not showed except when the value is
different from previous row.
Example (extra padding added for readability):
one column and several rows with values:
[ TRUE , TRUE , FALSE , FALSE , FALSE , FALSE , TRUE , TRUE ,
TRUE , TRUE ]
are showed by LibreOffice as:
[ 1 , , 0 , , , , 1 , ,
, ]
and clicking on every cell, they shows values:
[ =TRUE(), =TRUE(), =FALSE(), =FALSE(), =FALSE(), =FALSE(), =TRUE(), =TRUE(),
=TRUE(), =TRUE() ]
In the given attachments, click on every cell, specially the empty one, to see
that there is a value but nothing showed on cells when previous showed value is
the same.
I upload several attachments as examples:
- File created from scratch with Excel 2007
- File created from by a third party app that exports a datatable as XLSX,
basic type formatting only; I changed the column name with Excel2007, but using
the source files gives the same results and the same internal XML (I check it
the unzipped content before and after the column name).
- File created with LibreOffice 4.2.5.2 and saved as ODS, everything fine in
this case even reopening the file.
- File created with LibreOffice 4.2.5.2 and saved as XLSX; when you close and
open the file with LibreOffice, the problem appear.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
