Re: Re: PEAR Spreadsheet_Excel_Writer

On Tue, 13 Jul 2004 22:52:54 +0200 (MEST), Sabine Seipel <s.seipel@gmx.de> wrote: > Hi Justin, > > > If you're really trying to read the value from the formulas into PHP > > to then use elsewhere, that can't be done. There is no (AFAIK) PHP app > > which will actually parse and run Excel formulas. > > > > If you want this value to write back into the Excel file, use an excel > > formula to copy the values. Use the sheet!cell format I gave you > > earlier. > > well I try it with the following code: > > $sheet4->writeFormula(18, 9, "sheet1!J19", $profit); > You always have to start formulas with =: $sheet4->writeFormula(18, 9, "=sheet1!J19", $profit); > $sheet4 is valid worksheet handle from the fourth worksheet doc, there i > want to write the data from cell J19 from worksheet "sheet1". > > but it doesn't work "Unrecognised character for formula" > what have I made wrong? > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin--