Removing Merged Trailer for Excel Output

Reporting Design Cookbook
1

This entry guides you through on how to overcome the following “merged blank cell” issue below when rendering to an XLSX output.

image
image910×172 18.9 KB

  • For Elixir Ambience

  1. Navigate to your \etc directory of your Ambience installation & edit the ‘application.conf’ file.
  2. In your application.conf file, add the following line, vm-args = [“-Delx.xlspipeline.merge-trailer=no”] to each of your job engine.
  • For example,
    local-job-engines = [
    {
    name = “first”
    domain = ${domain}
    #vm-args is optional, you can include strings here such as
    #[“-Xmx6G”, “-server” ] or leave it out completely
    vm-args = [“-Delx.xlspipeline.merge-trailer=no”]
    }
    …
    ]

  • For Elixir Repertoire

  1. Navigate to your \config directory of your Repertoire Server’s installation and edit the ‘EREngine-config.xml’ file.
  2. In your EREngine-config.xml file, ensure the following property value is set to ‘no’.
  • For example
    <properties>
    <property name=“elx.xlspipeline.merge-trailer” value=“no”/>
    </properties>