Bug 56976 - true/false values are not displayed on Mac OS X 10.4
Summary: true/false values are not displayed on Mac OS X 10.4
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.11-dev
Hardware: Macintosh Mac OS X 10.4
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-12 11:54 UTC by stanescu florentina
Modified: 2014-09-12 13:36 UTC (History)
0 users


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) (3.77 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-09-12 11:54 UTC, stanescu florentina 		Details
excel created through Office Excel 2007, that has the same problem (8.05 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-09-12 13:17 UTC, stanescu florentina 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.