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

Community Advisor

Hi ,

Please refer Installing packages and check

Environment variables section for more details.

Thanks,

Kapil

Avatar

Community Advisor

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