Skip to Content
avatar image
Former Member

Spreadsheet Component in Xcelsius

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Oct 10, 2013 at 09:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 09, 2013 at 04:51 AM

    Hi Sowrabha,

    You can instead go for Scorecard, which has the option to change the color dynamically using the Row color and alternating row color, map these to your formula/condition cells and you can see the BG color change

    Thanks,

    Sara

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Spread sheet component is mainly used for bug fixing and testing purpose only and not designed as a display component. I completely agree with Sara to go with Scorecard component if you want to achieve this functionality.

  • avatar image
    Former Member
    Oct 09, 2013 at 05:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2013 at 08:54 AM

    Hi Sowrabha,

    You can use an alternate way to use alerts in Spreadsheet table component.

    Please find attached (change the file extension to xlf).

    Regards,

    Javed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2013 at 01:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 22, 2016 at 02:31 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded