Jedox data format in Excel

image_pdfimage_print

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):

At 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).

image_pdfimage_print
Was this post helpful?
NoYes (+1 rating, 1 votes)
Loading...