Formatting trouble (again?)

Topics: Developer Forum, User Forum
Jun 26, 2011 at 9:42 PM
Edited Jun 26, 2011 at 10:38 PM

Hi all,

I know similar topics have been discussed in this forum. But please note that I have worked through all other post and still have no solution to my problem:

In my database I have values stored like 4.1 (basically an expression for a software version) as a varchar. When I now output it to excel i get 4,1 - with a comma. I tried everything from setting the format code to text (@) or even various conversion attempts like settype or quoting the variabe.

I also tried:

incomingloader="4.1";

$objPHPExcel->getActiveSheet()->setCellValueExplicitByColumnAndRow(23, $row, $incomingloader, PHPExcel_Cell_DataType::TYPE_STRING);

In this case the cell is empty!

The explicit set of the locale variable also has no effect.

When I enter the value 4.1 manually in Excel it works fine.  I am really despaired. Has anybody a hint for me?

Thanks in advance

Michael