Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bug 22988769 : ABILITY TO EXPORT CUSTOM CSS STYLES TO EXCEL 2007+ AND PDF

Received Response
11
Views
5
Comments
User_D8344
User_D8344 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:38PM in Oracle Analytics Cloud and Server

Hi,

Bug 22988769 : ABILITY TO EXPORT CUSTOM CSS STYLES TO EXCEL 2007+ AND PDF. Anyone has solution or work around for this issue ?

Regards

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    As you can see there inside there isn't a patch for it now.

    So do not expect the community to have fixed a product bug

    Get in touch with Oracle and tell them you have the same issue and ask them about their plans.

  • User_D8344
    User_D8344 Rank 3 - Community Apprentice

    Hi Gianni,

    We have raised SR regarding 'Bug 22988769 : ABILITY TO EXPORT CUSTOM CSS STYLES TO EXCEL 2007+ AND PDF'

    Reply from support:

    SR.PNG

    Regards,

    BNTB

  • Gianni Ceresa
    Gianni Ceresa Mod

    Yeah, that's what I saw in the bug as well ...

    It means just what they said: an ER has been raised, so now you can only wait to see what happen with it: if they implement it and when or they just forget about it for ... "reasons".

    There isn't much which can be done.

    In generally I would say you are slightly "abusing" the tool as OBIEE isn't a tool to convert HTML into Excel or PDF, it's an analytical platform and the export to PDF and Excel is there to support the default functionalities and style of the tool. So if custom styles aren't exported into Excel and PDF is, in a way, not something the tool was expected to do but more a nice to have (and that's why you have a ER now).

    If you look for PDF you can always print/save as PDF with your browser. A browser is more specialized in transforming CSS into PDF than OBIEE because it's one of its main tasks in a way.

    For Excel ... export as CSV or use SmartView and manage the style directly in Excel. You will then only update figures but the style will be set by Excel.

  • User_D8344
    User_D8344 Rank 3 - Community Apprentice

    Hi Gianni,

    I am trying this now.will update you.

    OBIEE 12c : Report Alignment Is Missing From Excel Sheet When Report Is Exported To Excel - Extra Columns, Extra Blank Spaces, Large Size in Cells are seen (Doc ID 2317524.1)

    Regards,

    BNTB

  • User_D8344
    User_D8344 Rank 3 - Community Apprentice

    Thank you Gianni,

    Issue is fixed after changing parameter in: ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH/xdo.cfg

              <property name="xlsx-keep-values-in-same-column">false</property>

    Thank you,

    BNTB