Home » File Formats » Spreadsheet_Excel_Writer » Bug #4395
Capitalization of formulas is required
Details
| Request #4395 | Capitalization of formulas is required |
|---|---|
| Submitted | 2005-05-20 19:32 UTC |
| From | adam at aers dot ca |
| Assigned | xnoguer |
| Status | Closed |
| Package | Spreadsheet_Excel_Writer |
| PHP Version | 4.3.10 |
| OS | Linux |
| Roadmaps | (Not assigned) |
Comments
[2005-05-20 19:32 UTC] adam at aers dot ca
Description:
------------
For Spreadsheet_Excel_Writer, formulas are required to be capitalized. The module does not fail nicely with uncapitalized versions of formulas are used, instead returning with an error code and writing to the spreadsheet ("Incorrect number of arguments for formula sum()") or whatever the relevant formula may be. As Excel lets me use uncapitalized formulas, I would have expected similar behaviour. The simplest fix is to document the behaviour, although I would hope later versions might address support for that.
[2005-11-12 04:33 UTC] xnoguer at php dot net
This bug has been fixed in CVS.
If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET).
If this was a problem with the pear.php.net website, the change should be live shortly.
Otherwise, the fix will appear in the package's next release.
Thank you for the report and for helping us make PEAR better.
It supports function names in lower case now, and gives a more clear message whenever it doesn't recognize a function (instead of the current one about an incorrect number of arguments).