hiasmann

Problem solved. I forgott to remove the page size attributes when creating the sheet (copy / paste from pdf generation/tools/fckeditor/editor/images/smiley/msn/teeth_smile.gif ). These instructions are not needed: Code:

Hello. I have following problem with jasper and php export: I export some lines (4000 - 20000) into an excel sheet with jasper reports. In some lines it breaks up the text into a new line. The length of the text is between 30 and 200 chars. There is no \r\n or <br/> in it. This also happens when i only export this line. I attached an example how it looks like. System configuration: OS: Debian PHP 5.3.x Java 6 Code:Jasper Report configuration:Export configuration:$JRExporterParameter = new \JavaClass("net.sf.jasperreports.engine.JRExporterParameter");$JRXlsExporterParameter = new \JavaClass("net.sf.jasperreports.engine.export.JRXlsAbstractExporterParameter");$xlsExporter = new \Java("net.sf.jasperreports.engine.export.JExcelApiExporter");$xlsExporter->setParameter($JRExporterParameter->JASPER_PRINT, $this->_jasperPrint);$xlsExporter->setParameter($JRExporterParameter->OUTPUT_FILE_NAME, $this->_outputfile);$xlsExporter->setParameter($JRXlsExporterParameter->IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, new \Java("java.lang.Boolean", true));$xlsExporter->setParameter($JRXlsExporterParameter->IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, new \Java("java.lang.Boolean", true));$xlsExporter->setParameter($JRXlsExporterParameter->IS_WHITE_PAGE_BACKGROUND, new \Java("java.lang.Boolean", false));$xlsExporter->setParameter($JRXlsExporterParameter->IS_DETECT_CELL_TYPE, new \Java("java.lang.Boolean", true));$xlsExporter->exportReport();XLS sheet configuration:$mainElement = $doc->createElement('jasperReport');$mainElement->setAttribute('xmlns', 'http://jasperreports.sourceforge.net/jasperreports');$mainElement->setAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');$mainElement->setAttribute('xsi:schemaLocation', 'http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd');$mainElement->setAttribute('name', 'Sheet 1');$mainElement->setAttribute('columnCount', '1');$mainElement->setAttribute('printOrder', 'Vertical');$mainElement->setAttribute('orientation', 'Portrait');$mainElement->setAttribute('columnWidth', $width);$mainElement->setAttribute('columnSpacing', '0');$mainElement->setAttribute('leftMargin', '30');$mainElement->setAttribute('rightMargin', '30');$mainElement->setAttribute('topMargin', '20');$mainElement->setAttribute('bottomMargin', '20');$mainElement->setAttribute('pageWidth', $width + 60);$mainElement->setAttribute('pageHeight', 842);$mainElement->setAttribute('isTitleNewPage', 'false');$mainElement->setAttribute('isSummaryNewPage', 'false');Column configuration:$titleElement = $doc->createElement('title');$titleBandElement = $doc->createElement('band');$titleBandElement->setAttribute('height', 30);$titleElement->appendChild($titleBandElement);$mainElement->appendChild($titleElement);$detailElement = $doc->createElement('detail');$detailBandElement = $doc->createElement('band');$detailBandElement->setAttribute('height', 25);$detailElement->appendChild($detailBandElement);$mainElement->appendChild($detailElement);$elementX = 0;foreach ($dataDefinitionSelected as $selectedColumn) { $rowWidth = $this->_getXLSRowWidth($selectedColumn['dataIndex'],$selectedColumn['exportWidth']); $staticTextElement = $doc->createElement('staticText'); $reportElement = $doc->createElement('reportElement'); $reportElement->setAttribute('positionType', 'Float'); $reportElement->setAttribute('stretchType', 'RelativeToTallestObject'); $reportElement->setAttribute('style', 'columnHeaderStyle'); $reportElement->setAttribute('x', $elementX); $reportElement->setAttribute('y', 0); $reportElement->setAttribute('width', $rowWidth); $reportElement->setAttribute('height', 25); $staticTextElement->appendChild($reportElement); $textElementElement = $doc->createElement('textElement'); $fontElement = $doc->createElement('font'); $fontElement->setAttribute('size', '12'); $textElementElement->appendChild($fontElement); $staticTextElement->appendChild($reportElement); $textElement = $doc->createElement('text'); $textElement->appendChild($doc->createCDATASection($selectedColumn['header'])); $staticTextElement->appendChild($textElement); $titleBandElement->appendChild($staticTextElement); $textFieldElement = $doc->createElement('textField'); $textFieldElement->setAttribute('isBlankWhenNull', 'true'); $textFieldElement->setAttribute('isStretchWithOverflow', 'true'); $reportElement = $doc->createElement('reportElement'); $reportElement->setAttribute('positionType', 'Float'); $reportElement->setAttribute('stretchType', 'RelativeToTallestObject'); $reportElement->setAttribute('x', $elementX); $reportElement->setAttribute('y', 0); $reportElement->setAttribute('width', $rowWidth); $reportElement->setAttribute('height', 25); $textFieldElement->appendChild($reportElement); $textElementElement = $doc->createElement('textElement'); $fontElement = $doc->createElement('font'); $fontElement->setAttribute('size', '12'); $textElementElement->appendChild($fontElement); $textFieldElement->appendChild($textElementElement); $textFieldExpressionElement = $doc->createElement('textFieldExpression'); $textFieldExpressionElement->setAttribute('class', 'java.lang.String'); $textFieldExpressionElement->appendChild($doc->createCDATASection('$F{'.$selectedColumn['dataIndex'].'}')); $textFieldElement->appendChild($textFieldExpressionElement); $detailBandElement->appendChild($textFieldElement); $elementX += $rowWidth;}