Set Image / Picture in Worksheet behind cells

MaxMoritz · Nov 23rd 2012, 10:53am

Hi everyone,

again a short question: whenever I insert a picture on a worksheet it is always infront of the cells even if I right click on it and choose "set to back". Is there a solution to this problem?

Thank you

noelgaur · Nov 25th 2012, 7:11am

Unfortunately there is no direct way of what you desire.

But you can do the same if you wish to use Widgets,

You will have to make a HTML page having table and background image what you desire.
have an javascript __exe(params) function which populates the table.

Pass the area of cells as input parameters to your HTML page which will get pass on to __exec(params) function which
inturn will populate the table.

A very simple example is provided in the Jedox web advance guide for Jedox 4 SR1.

Hope it helps!

Best regards,
Noel.

MaxMoritz · Nov 26th 2012, 2:37pm

Hi Noel,

thanks again for your support. I have already built a workaround with widgets but in this case it was not really worth the effort. It would have been more effective and faster to use cells. Nevertheless it helped to know for sure that there is no other solution.

See u!

noelgaur · Nov 27th 2012, 2:33am

Yeah, the real benefit from widgets comes from integrating interesting components like,
external charts and reports - Jedox lacks in data visualization of charts so one could integrate external java chart libraries and make beautiful charts.
Custom web services - like data upload with button in a report itself.
Map integration.

Possibilities are endless but for background images yes its not worth the effort.

Best regards,
Noel.

tish1 · Nov 27th 2012, 9:08am

Hi,

noelgaur wrote:

Jedox lacks in data visualization of charts

Watch out for Jedox 4.1!

Regards.

laloune · Nov 27th 2012, 9:12am

tish1 wrote:

Hi,
Watch out for Jedox 4.1!

Hi Robert,

where does your information come from ?

noelgaur · Nov 27th 2012, 9:35am

For what I hear is 4.1 will have drill down charts,
but what I don't hear is that will it be kool like the neat chart libraries we see today.
I am tired of much hype about QlikView or Tableu for data visualizations. If Jedox manages bring it out - it would be a killer.

Best regards,
Noel.

laloune · Nov 27th 2012, 11:05am

Actually it is already possible to draw extended charts using the ChartDirectory PHP library (in the macro engine). Possibilities are almost infinite for people who can type code

But still it would be great to be able to get those charts done like in excel

noelgaur · Nov 27th 2012, 11:36am

Well you dont even need to do that, with chart libraries offered by good charting tools like amcharts, it could be done using widgets.
But the point here is end users and productivity.

Best regards,
Noel.

Share