Skip to Content

Spreadsheet Fixed column size or column resize

Hi,

In crosstab we have an option to fix column size but same feature is missing in spread sheet component, I am able to resize the column width during debugging mode (F11 DOM explorer) but not able to achieve the same using CSS (below). Any suggestions will be helpful.

Thanks

.mysp.sapEpmUiControlAnalyticgridGridTableInner>tbody>tr>td.colIndexCell

{

width: 100px;

min-height: 16px;

}

Or

.mysp1.sapEpmUiControlAnalyticgridGridTableInner>tbody>tr>td.general

{

width: 100px; min-height: 16px;

}

mlo8a.png (31.3 kB)
ljxwc.png (106.2 kB)
mvby2.png (5.9 kB)
ibzbu.png (39.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 04, 2017 at 08:09 AM

    Hello Sai,

    You are almost there. I guess you assigned a custom class to your spreadsheet called mysp. That increases the complexity to create a selector to do what you want. The easiest way of doing this would be:

    .sapEpmUiControlAnalyticgridGridTableInner>tbody>tr>td.colIndexCell{
       width: 100px!important;
       min-height: 16px!important;
    }

    However now every spreadsheet on your dashboard will be resized accordingly. In case you want to use your custom css class to avoid that, you need to revisit the html structure like you did with the developer tools before. Your custom class sits higher up on the tree and is accompanied by other sap standard classes. You need to deal with that when writing your selector. Also note the "!important" extension to override other css properties. Either you use that option or write a more selecive css selector. You can check stackoverflow.com for lots of examples.

    Kind regards

    Martin

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Martin,

      Thanks for your patience - with your suggestion I have managed to reduce the font size and with width 100PX .

      You can notice font size getting small on speadsheet but columns width remain same, I can see measure Jan and rest of them visible with scroll bar means all columns are fitting on screen.

      Thanks

      SAI

      trnew.png (82.4 kB)