Jedox Data Format in Excel


Jedox Excel Add-In comes with a number of preset styles for data display. You can select these in Paste View under the Options tab (see image below). 

These preset styles can be customized. For example, you can control the display of decimal places of numbers or the background color of the view. Below is a description for changing decimal places in the Jedox style “White”. The other style sheets jedoxstyles_*.xls can be changed similarly.

We recommend that you make a backup of the existing style template before making any changes.

Open the file  <install_path>\xladdin\styles\view\jedoxstyles_White.xlsx. You should see the following worksheet:

To change decimal places for data, right-click on the “_data” style in the Styles area of the Excel Ribbon then click on “Modify…” in the context menu (see screenshot below):

On the next dialog, click the Format button to open the Format Cells dialog. In the Number tab, change the number format to 2 decimal places.

Save the file jedoxstyles_White.xlsx. After saving, the changes are applied immediately for each new view with this style.

Note: the style “_freeze” is the defined style for locked OLAP cells (i.e., cells that cannot be changed by users).