Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.4

Bug #13752 mergeCells and setTextWrap and text with new lines issue
Submitted: 2008-04-23 14:40 UTC
From: hoze Assigned:
Status: Open Package: Spreadsheet_Excel_Writer (version 0.9.1)
PHP Version: 5.1.6 OS: Linux
Roadmaps: (Not assigned)    
Subscription  


 [2008-04-23 14:40 UTC] hoze (Josif Noname)
Description: ------------ mergeCells doesnt expand rows with new line chars. if there is no mergeCells the first cell is expanding in height and the whole text is visible if setTextWrap is used. viewing with ms excel 2003. Test script: --------------- $workbook = new Spreadsheet_Excel_Writer('subscriber_agreement_v2.xls'); $worksheet =& $workbook->addWorksheet('My worksheet'); $format_input_fields =& $workbook->addFormat(); $format_input_fields->setAlign('left'); $format_input_fields->setVAlign('vcenter'); $format_input_fields->setBorder(3); $format_input_fields->setTextWrap(); $worksheet->setColumn(0,0,25); $worksheet->setColumn(0,1,30); $worksheet->setColumn(0,2,30); $worksheet->write(0, 0, "some long text with \n new line \n another new line. well not so long text \n but has new lines", $format_input_fields); $worksheet->write(0, 1, "", $format_input_fields); $worksheet->write(0, 2, "some text", $format_input_fields); $worksheet->mergeCells($row_number,0,$row_number,1); $workbook->close(); Expected result: ---------------- expected to see the row expanding so the whole text to be visible. Actual result: -------------- only the text before the new line character is visible, the height of the row is not changing, the text is shown when clicking on the cell

Comments