Expand my Community achievements bar.

Error while exporting report in excel format

Avatar

Employee

I am encountering an error while trying to export a report built on cubes in excel format , are we missing any library(libreoffice is installed) or any other configuration?

Reference doc: Creating indicators

Screenshot 2019-09-12 at 8.58.12 PM.pngScreenshot 2019-09-12 at 8.58.16 PM.png

8 Replies

Avatar

Community Advisor

Hi,

Check that LibreOffice's path is set in the Campaign user's env.

E.g. for Windows, the var could be: OOO_BASIS_INSTALL_DIR="C:\Program Files (x86)\LibreOffice 5\"

Thanks,

-Jon

Avatar

Level 8

Hi ,

Please refer Installing packages and check

Environment variables section for more details.

Thanks,

Kapil

Avatar

Level 8

Hi,

1. Don't you have any errors in the web.log file about this report?

2. can you please check other export options like PDF,office. Is error same for PDF as well?

3. I am assuming OpenOffice installed on the frontal web server and  applicative server as well? Is that correct?

-Kapil

Avatar

Employee

Hi Kapil,

No errors in the log, PDF is working fine. Yes open office is installed.

Avatar

Level 2

Bonjour;

 

Avez-vous trouvé une solution, car je rencontre le même problème !

 

Merci

Avatar

Level 1

hi,

the adobe page has an error

check this :

 

OOO_URE_INSTALL_DIR=/opt/libreoffice6.4/share/
OOO_BASIS_INSTALL_DIR=/opt/libreoffice6.4/
OOO_INSTALL_DIR=/opt/libreoffice6.4/program/

 

this work for me