Where standart colors for URL's in cells?

Topics: Developer Forum, User Forum
Sep 30, 2010 at 4:11 PM
Edited Sep 30, 2010 at 4:11 PM

Dear mans! I have a problem! In the derivation in excel format I have a problem with the URL in the cells ... ie I write ...

$ ObjPHPExcel-> getActiveSheet () -> getCell ('C'. $ I.'')-> getHyperlink () -> setUrl ('http://phpexcel.codeplex.com/discussions?searchText=URL');

but the color of links has only black in Excel (visited, active, hover), and links without underscores. Should be the standard blue for links.
If you change the URL for a cell in Excel, then I see a blue link

Thanks in advance mans!

Oct 1, 2010 at 2:23 PM

PHPExcel isn't Excel with its automatic changes to style when you set a hyperlink. The getHyperlink()->setUrl() method only sets the hyperlink, it doesn't change the styling of the cell in any way. You need to change the font colour, underline style, etc by hand.

Oct 2, 2010 at 1:35 PM

Well, I also did. But in Excel, I saw the state of "visited" (standart color for hyperlink)! How to make it emulate?