Bug 56976

Summary: true/false values are not displayed on Mac OS X 10.4
Product: POI Reporter: stanescu florentina <stanescuflorentina>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.11-dev   
Target Milestone: ---   
Hardware: Macintosh   
OS: Mac OS X 10.4   
Attachments: the excel is created with apache poi. It contains a column with boolean values (TRUE/FALSE). The values are not visible on MAC OS X 10.4)
excel created through Office Excel 2007, that has the same problem

Description stanescu florentina 2014-09-12 11:54:14 UTC
Created attachment 32011 [details]
the excel is created with apache poi. It contains a column with boolean values (TRUE/FALSE). The values are not visible on MAC OS X 10.4)

I am using the apache poi 3.11 beta version to build excel files. 
I put boolean values in a cell, and format it as General. 
The boolean value is not displayed on Mac OS X 10.4.
Comment 1 stanescu florentina 2014-09-12 12:28:04 UTC
The issues reproduces both with inline strings or shared strings table.
Comment 2 Nick Burch 2014-09-12 12:43:56 UTC
Can you recreate the same spreadsheet in Excel? Does the Excel version display correctly? And if it does, when you unzip the two files (.xlsx is a zip of xml files), how does the XML differ for the POI and Excel generated cell?
Comment 3 stanescu florentina 2014-09-12 13:01:35 UTC
Yes, i recreated the same spreadsheet in Excel, and the defect is still reproducible. 
I will attach an excel created manually through Office Excel(not with apache poi library) and still has the issue.
Comment 4 stanescu florentina 2014-09-12 13:17:37 UTC
Created attachment 32012 [details]
excel created through Office Excel 2007, that has the same problem
Comment 5 Nick Burch 2014-09-12 13:28:16 UTC
If a POI generated file has the same behaviour as an Excel generated file, then the fault is with Apple and not with POI...
Comment 6 stanescu florentina 2014-09-12 13:36:27 UTC
Right :)
I'll add a defect for Mac. 

Thank you for your quick response.