Problems with cell hyperlinks and custom properties in LibreOffice

Topics: User Forum
Apr 18, 2012 at 6:58 AM

Hello all

I'm trying to add hyperlinks to a cell and custom properties to a document. When opening the generated file in LibreOffice 3, these items are not visible.

I'm using PHPExcel 1.7.6, LibreOffice 3 with PHP 5.3.8 on Windows XP.

Here's the code:

  $objPHPExcel->getProperties()->setCustomProperty('aa', '99');

  $objPHPExcel->getActiveSheet()->getCell('A1')->getHyperlink()->setUrl('http://www.google.com');

When checking the generated XML files, I see that the cell property is present. However, in LibreOffice / Document Properties / Custom Properties, no data is visible.

Can someone advise if this feature is not supported or if I'm doing something wrong?

Vikram

Apr 18, 2012 at 7:00 AM

Followup: I got the cell hyperlinks working. I was first trying it on a cell that didn't have a value. Once I added a value, the hyperlink became visible.

Still puzzled about the custom properties, though, any help much appreciated.

Vikram

Apr 24, 2012 at 6:25 AM

Anyone? Need some help on this.