Unable to read cell style while using OOCalc reader

[nexces]

I'm unable to read cell styles in .ods file.
I've created a simple .ods file with yellow cell background in cell A1
and strike through text in cell A2 and after reading styles with code:

$objReader = new PHPExcel_Reader_OOCalc();

$file = $objReader->load('/tmp/foo.ods');

$worksheet = $file->getActiveSheet();
echo 'Cell "A1": ' . PHP_EOL;
$cellStyle = $worksheet->getStyle('A1');
echo 'Fill type: ';
var_dump($cellStyle->getFill()->getFillType());
echo 'Start color: ';
var_dump($cellStyle->getFill()->getStartColor()->getRGB());
echo 'End color: ';
var_dump($cellStyle->getFill()->getEndColor()->getRGB());

echo 'Cell "A2": ' . PHP_EOL;
$cellStyle = $worksheet->getStyle('A2');
echo 'Font strike through: ';
var_dump($cellStyle->getFont()->getStrikethrough());

i'm getting:

Cell "A1": 
Fill type: string(4) "none"
Start color: string(6) "FFFFFF"
End color: string(6) "000000"
Cell "A2": 
Font strike through: bool(false)

but I would expect something like this:

Cell "A1": 
Fill type: string(5) "solid"
Start color: string(6) "FFFF00"
End color: string(6) "FFFF00"
Cell "A2": 
Font strike through: bool(true)

[laskolaskov]

Hello , I have the same issue. It is only when I read Open Office (.ods) files , and for ALL cells the background color is set like :
Start color: string(6) "FFFFFF"
End color: string(6) "000000"

When I convert the file to excel 97 / 2000 / xp format , the colors are OK.

But then some cells containing special and/or asian chars lose their value, and the cell value returned is not 'string' , but empty array. This however is maybe another issue , but still worth to mention I guess.

I would greatly appreciate if someone can share thoughts about these issues.
Thanks in advance.

[lushc]

+1

[nouphaltklm]

+1