on 10-09-2013 5:00 AM
Hello All,
I am trying to use alerts in Spreadsheet table component in Dashboard design 4.0. This changes the font color based on the condition. Is there any workaround to change the background color instead of font color?
Please share any solution (I need it asap ).
Thanks,
Sowrabha
Hi guys,
I do Conditional Formatting for Spreadsheet Table Component using Custom Number Format in Excel.
You can change color dynamically
[red][<1] for example...
http://www.excel-easy.com/examples/custom-number-format.html
*Of course drawback is you cannot change background color.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sowrabha,
Even i had the same issue where i had a lot of columns and the user wanted the freeze pane functionality of Excel in Xcelsius.
I have done it using two spreadsheet components, the first column data is always fixed, ie i know that there wont be more than 15 rows in the first column and so i have fixed the first spreadsheet component for that column in the excel.
The second spreadsheet component is where i have mapped the key figures or the numerical data. For this spreadsheet i have adjusted the Table Scale so it will fit with the first spreadsheet and have allowed horizontal scroll bar, so that the user can scroll to see the rest of the columns.
If you do the proper formatting then it works in the expected way, but this approach worked for me since i convinced the user that i can only show the alerts using the arrows or icons in the spreadsheet.
Thanks & Regards,
Arjun.C.T
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sowrabha ,
Try using below Workaround.
Step 1 :
Go to Excel and enter Hexadecimal Color Pallets as per below image and also go through below link
( Link for Hexadecimal Color Pallets code : http://dmcritchie.mvps.org/excel/colors.htm )
Step 2 : Now add a Grid Component and under properties >> appearance Tab >> Color Tab select
Background Color and bind it to any Excel Cell where we have entered the Color Pallets as shown below.
Final Output with Different Colors :
Regards
Jeetan Jagtap
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Javed for the file. I cannot open this as my version of dashboard is Xcelsius 2008 SP5 and I am able to complete my requirement using scorecard as suggested by Sara G and Durgamadhab Mishra. Thanks to you both as well! But the challenge I am facing currently is, since I have too many columns in scorecard I need to freeze some of the columns and the rest can be scrolled. Is there any solution to freeze columns in Scorecard?
This functionality is not available yet. There is a idea place idea raised for this.
https://ideas.sap.com/ct/ct_a_view_idea.bix?idea_id=%7BEB9E2163-85E8-4FCB-BF60-E58F67093E1A%7D
Hi
Yes, its not super elegant but it works.
You have to use two scorecards. One for the first column(s) you want to freeze and second for rest of the columns which can scroll. Align them side by side in a way that they appear as if one scorecard. But one limitation - if your data is more than the vertical height, vertical scrolling will de-align them. It will work if number of records within the scorecard is something for which you can adjust scorecard height to be able able to show all of them and add no vertical scrollbar.
Runali
Hi,
Since Spreadsheet is a selector component. Instead Add a Grid and then you can add alert
http://myxcelsius.com/2011/06/28/xcelsius-2008-sp4-spreadsheet-alerts/
http://xcelsius2008.blogspot.nl/2009/07/simulate-excel-conditional-formatting.html
Regards,
NK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.