Question Re: Spread sheet Object in Technology Q&A

Spread sheet Object

Former Member — Mon, 21 Dec 2015 05:11:23 GMT

Hi buddies,

I would like to use super script values( i.e Power values) in dashboard spreadsheet object.

I need to show the below value in the Dashboard spread sheet object as 1 in the power of 0, Can any one suggest me the solution please.

N = 0¹

Re: Spread sheet Object

Former Member — Mon, 21 Dec 2015 17:13:49 GMT

Hi pramod.

I hope this would help. On the excel cell type N=0 and for the super script value(this case 1)

type alt + 0185

Please let me know if this works for you.

Re: Spread sheet Object

Former Member — Tue, 22 Dec 2015 06:17:22 GMT

Hi,

It can be done by adding the superscript i.e the exponent value you want from the symbol section in excel.

Re: Spread sheet Object

Former Member — Wed, 23 Dec 2015 07:21:23 GMT

Thanks bro its working now thank you. I am facing one more issue in spread sheet i need to center align the title for two columns. I have merged and center aligned in Excel but coming to dashboard title is not showing in center. Do the helpful.

Re: Spread sheet Object

Former Member — Wed, 23 Dec 2015 07:57:30 GMT

Hi,

The alignment in the excel itself does the alignment in the dashboard, it just takes a few moments to refresh and show up in the Canvas area after you have made changes to the spreadsheet. Please see the results achieved using the same technique.

Re: Spread sheet Object

Former Member — Wed, 23 Dec 2015 08:26:39 GMT

Hi bro please find the above image i need to show the marked title in center aligned.

Re: Spread sheet Object

Former Member — Wed, 23 Dec 2015 09:01:21 GMT

Hi Pramod,

If you notice, the first image you had posted (while starting this thread) had the center alignment. As mentioned earlier, I was able to achieve it using the same formatting way in the spreadsheet.

Re: Spread sheet Object

Former Member — Thu, 24 Dec 2015 04:41:40 GMT

Hi Bro,

My scenario is for two columns, i need to keep single heading which is center alligned.