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)    
Subscription  


 [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:32 UTC] wiesemann (Mark Wiesemann)
(wrong package was selected)
 [2007-01-12 17:35 UTC] guillaume dot lebigot at gmail dot com
all others formulas are ok. just HYPERLINK crash.
 [2007-04-11 04:25 UTC] cweiske (Christian Weiske)
not a doc problem
 [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.
 [2009-08-11 15:34 UTC] progi1984 (Franck Lefevre)
-Status: Open +Status: Analyzed