Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
5 years ago
Solved

Different alignment in matrix table

Hi,

I have a following columns in data table Area, Result, Colour code, Status. I am applying conditional formatting based on the result column in data table.

 

I would like to know the result status based on the conditional formatting in matrix table and it’s working fine but it’s showing different alignment/ not same comparing to others in matrix table? Do you know why? and how can I make all of them same alignment?

 

AREARESULTColour CodeFILTERStatus
DD1WIN#73B761DSTATUS
DD1WIN#73B761DSTATUS
DD1WIN#73B761DSTATUS
DD1WIN#73B761DSTATUS
DD1WIN#73B761DSTATUS
DD1WIN#73B761DSTATUS
DD2LOSS#F17925DSTATUS
DD3LOSS#F17925DSTATUS
DD3LOSS#F17925DSTATUS
DD3LOSS#F17925DSTATUS
DD3LOSS#F17925DSTATUS
DD4LOSS#F17925DSTATUS
DD5LOSS#F17925DSTATUS
DD6LOSS#F17925DSTATUS
DD7LOSS#F17925DSTATUS
DD8LOSS#F17925DSTATUS
DD9LOSS#F17925DSTATUS
ED1NO RESULT#95C8F0ESTATUS
ED2NO RESULT#95C8F0ESTATUS
ED3NO RESULT#95C8F0ESTATUS
ED3NO RESULT#95C8F0ESTATUS
ED3NO RESULT#95C8F0ESTATUS
ED3NO RESULT#95C8F0ESTATUS
ED4NO RESULT#95C8F0ESTATUS
ED5NO RESULT#95C8F0ESTATUS
ED6NO RESULT#95C8F0ESTATUS
ED7NO RESULT#95C8F0ESTATUS
ED8NO RESULT#95C8F0ESTATUS
ED9NO RESULT#95C8F0ESTATUS
BD1TIE#9A64A0BSTATUS
BD2TIE#9A64A0BSTATUS
BD3TIE#9A64A0BSTATUS
BD3TIE#9A64A0BSTATUS
BD3TIE#9A64A0BSTATUS
BD3TIE#9A64A0BSTATUS
BD4TIE#9A64A0BSTATUS
BD5TIE#9A64A0BSTATUS
BD6TIE#9A64A0BSTATUS
BD7TIE#9A64A0BSTATUS
BD8TIE#9A64A0BSTATUS
BD9TIE#9A64A0BSTATUS

 

Note: The area code length is 3 characters.

 

Any advise idea please?

 

 

 

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Saxon10 ,

     

    That is related with the font type and the fact that is Monospaced or not, that returns different spaces depending the letter.

     

    If you change it to Arial or courier new for example the columns stay similar.

     

     

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi Saxon10 ,

     

    That is related with the font type and the fact that is Monospaced or not, that returns different spaces depending the letter.

     

    If you change it to Arial or courier new for example the columns stay similar.

     

     

    • Saxon10's avatar
      Saxon10
      Post Prodigy
      5 years ago

      Hi MFelix,

       

      Thanks for your time to investigate my query and sorry for the late respones.

       

      after apply the conditional formatting in matrix table then alignment completely changed but it won't changed in table level. Please refer the snaphot

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI Saxon10,

        Did you mean the total level layouts? If that is the case, you can't do custom with them. Conditional formatting can be applied to the row content, they cant be used on the header or total level.
        Regards,
        Xiaoxin Sheng