|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2003-07-04 03:59 UTC] xnoguer@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Dec 16 07:00:01 2025 UTC |
Description: ------------ Creating a spreadsheet with a simple formula like =A1*10 fails unless the formula contains a trailing space #php configuration './configure' \ '--enable-xml' \ '--enable-ftp' \ '--with-mysql=/usr' \ '--with-apache=../apache' \ '--with-zlib-dir=/usr/local' \ '--with-curl=/usr/local' \ '--with-jpeg-dir=/usr/local' \ '--with-png-dir=/usr/local' \ '--enable-track-vars' \ '--with-pspell=/usr/local' \ '--with-dom=/usr/local' \ '--enable-track-vars' \ '--with-msession' \ '--enable-pcntl' Reproduce code: --------------- <?php require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); $workbook->send('test.xls'); $worksheet =& $workbook->addWorksheet('bug'); //data cell $worksheet->write(0, 0, 2); //simple formula, no trailing space - FAILURE $worksheet->write(1, 1, "this fails"); $worksheet->write(1, 2, "=A1*10"); //simple formula, with trailing space - SUCCESS $worksheet->write(2, 1, "this works"); $worksheet->write(2, 2, "=A1*10 "); //close and send sheet $workbook->close(); ?> Expected result: ---------------- expect formula =A1*10 in cell C2 of returned spreadsheet Actual result: -------------- cell C2 contains following text Sintactic error: *, lookahead: , current char: 3