Bug 86456

Summary:	Libre Office corrupts boolean columns importing xlsx file
Product:	LibreOffice	Reporter:	John Mount <jmount>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	iplaw67, smruti.patil
Version:	4.3.4.1 release
Hardware:	x86 (IA32)
OS:	Mac OS X (All)
See Also:	https://www.libreoffice.org/bugzilla/show_bug.cgi?id=81350
Whiteboard:
i915 platform:		i915 features:
Attachments:	test xlsx file XLSX file showing the problem

Description John Mount 2014-11-19 06:08:05 UTC

On importing an Excel .xlsx file that has columns which are TRUE/FALSE (which is encoded is 0/1 by Excel) eventually Libre Office starts mis-interpreting arbitrary cells as being empty.  See: http://www.win-vector.com/blog/2014/11/excel-spreadsheets-are-hard-to-get-right/

Comment 1 Smruti 2014-11-19 06:09:47 UTC

*** Bug 86455 has been marked as a duplicate of this bug. ***

Comment 2 Alex Thurgood 2014-11-19 10:26:45 UTC

Confirming

Version: 4.4.0.0.alpha2+
Build ID: 60d34e1c840d2c317bb7d0a5b14f4602c22b3fcc
Locale: fr_

Comment 3 Alex Thurgood 2014-11-19 10:29:12 UTC

Created attachment 109721 [details]
test xlsx file

Comment 4 John Mount 2014-11-19 16:09:31 UTC

It may be a presentation problem as examining individual cells shows “=TRUE()” and “=FALSE()” as the contents of the affected cells (and apparently in the correct positions independent of what is being displayed).

Comment 5 John Mount 2014-11-19 16:10:45 UTC

Created attachment 109739 [details]
XLSX file showing the problem

Comment 6 John Mount 2014-11-19 16:18:59 UTC

If examine the cells you see int the formula bar that the TRUE/FALSE cells have been changed to =TRUE()/=FALSE(), and you get an “inconsistent formulas” warning. So the sheet has been damaged, but is likely in a regular patten that is repairable. So it looks like a combination of a bad transformation on load plus a presentation layer bug.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.