| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #9814 | writeFormula problem with HYPERLINK | ||
|---|---|---|---|
| Submitted: | 2007-01-12 16:55 UTC | ||
| From: | guillaume dot lebigot at gmail dot com | Assigned: | |
| Status: | Analyzed | Package: | Spreadsheet_Excel_Writer |
| PHP Version: | 5.1.6 | OS: | WINDOWS |
| Roadmaps: | (Not assigned) | ||
[2007-01-12 16:55 UTC] guillaume dot lebigot at gmail dot com
(Guillaume)
Description:
------------
Impossible to execute writeFormula to create an HYPERLINK through worksheets. (see my script)
Test script:
---------------
$Sai->writeFormula(0, 4, "=HYPERLINK('sheet!A1','link')");
Expected result:
----------------
I expect to have my XLS generated with formulas in cells but when i call the generator script, my navigator crash with the use of this line. I have try a lot of possibilities.
help!
Actual result:
--------------
navigator crash
Comments
[2007-01-12 17:35 UTC] guillaume dot lebigot at gmail dot com
all others formulas are ok.
just HYPERLINK crash.
[2007-08-10 13:24 UTC] diego
(Diego Sávio)
Try to use with ; to separate the elements and do not use apostrophes in the link.
[2007-08-10 19:30 UTC] diego
(Diego Sávio)
I try to Use like example to help you!
Example
*********
$worksheet2->writeFormula($j,8, '=hiperlink(Aba1!A1;"Teste")');
Try to use the writeUrl() ;)
[2009-08-11 15:30 UTC] progi1984
(Franck Lefevre)
For beginning,
in Parser.php, line 532, add
--------------------------------------------------------
'HYPERLINK' => array( 359, -1, 1, 0 )
--------------------------------------------------------
But Just for BIFF8.
That runs with an formula like this ""=HYPERLINK('A1','link')");
But not with a formula like that ""=HYPERLINK('sheet!A1','link')"); "
Why ?
Because in WorkBook.php, line 541, $this->_storeExternsheetBiff8 is not enabled.
So a patch will be added when we would enable this method.