WIB: change column width and text of data column in planning layout

[Former Member]

Hello experts,

I created several planning layouts and use them among themselves in a web interface. Now the problem is that every planning layout is different in the width of the columns. It doesn't look very nice. Is it possible (in planning layout or WIB) to change the column width of the planning layout so that every planning layout has the same width?

Beyond I have a problem with the text in the data column in planning layout. In data column I put fiscal year. As table head for the data column I use the variable of fiscal year. If I exeute the planning layout, fiscal year will display but only the discription (e.g. Jan. - Dec. 2007). Is it possible to display the key of the key figure fiscal year (e.g. 2007) and not the description (Jan. - Dec. 2007)?

Many thanks for your help.

Friedrich

[Former Member · Accepted solution]

Hello Friedrich,

you can also change the columns with the CSS-Stylesheet. For this go in web interface builder to MIME-Objects (CTRL+F5) and select "CSS Template import". Stylesheet "custom.css" will created. Now you have to select all classes which are responsible for columns (e.g. lead column -> look for lead). If you found all classes then implement "width:5em;" for each class. Now the columns will be changed.

Hope this helps.

Adelina

[Former Member · Accepted solution]

Hello Adellina,

I did what you described, but if I exit web interface I can not see any changes. What could be the problem?

Thanks.

Friedrich

[Former Member · Accepted solution]

Hello Friedrich,

go in your web interface in the component page to the field 'additional css file' and select your created css-file.

Adelina

[Former Member]

Hello Friedrich,

Please post the code you have written. I can help you fix the code.

Sunil

[Former Member]

Hello,

I am not clear about the issue with col. width.

1. Do you want to fix the height and width for all layouts in your application to the same width and height?

If yes, the solution is pretty simple. In tcode BPS_WB, you can predetermine the height and width of each layout. However, you will not be able to control the width of each col. as these are dynamically adjusted based on the characters being displayed in each individual col.

2. Do you want to control the width of each col. in all your layouts?

If yes, it is preferred to use the excel display. When you choose the option to display the layout in excel mode, we can control the width of each col. individually.

You can do it in two ways.

a. While creating the layout, you can set the col. width.

b. Use a simplae javascript in BPS_WB and control the col. width.

For option B, I had posted a sample code a few weeks earleir to a different post. You can look it up. I have also described how and where you should write the code.

Hope this helps.

Sunil

[Former Member]

Hello Sunil,

thanks for your answer. For better understanding: I want to fix the first column of a planning layout (e.g. for first column the width is 20). I use these planning layout in a web interface.

To come back to your answer: I found under the post "How to change a font in Excel Layout on the Web" a javasrcipt code. I hope this is the rigth code. I created after the subcomponent for planning layout a subcomponent for text and inserted your javascript. I changed layout_id with the name of my subcomponent. If I executed the web interface nothing is changing. In your example the font schould be different, but I can't see any difference. What have I to change in javascript so that it works fine?

Many thanks.

Friedrich

[Former Member]

Friedrich,

If you are setting the layouts in Excel in BPS0, you can uncheck the fit to column automatically and manually configure your width in the last page of the configuration of the manual layout. The risk is that some column would be longer than you configure.

This may also be another option.

[Former Member]

Hello Mary,

thanks for your answer. I did these settings but in web interface I can't see that the width of the column is changed.

Friedrich

[Former Member]

Freidrich,

Please check the following:

a) In the last page of Excel Layout congiruation in BPSO, make sure the checkbox for 'Publish for Web' is checked/marked. You will find 'Publish for Web' when you click on 'MS Excel Settings' icon.

b) In WIB, make sure that the text object with java script is placed after the layout object.

Hope this resolves the issue. Good luck

Regards

[Former Member]

Friedrich,

In your variable for fiscal year, select Text replacement of type characteristic value.

Hope this helps,

Mary

[Former Member]

Hello Mary,

thanks for your answer. You solved my second described problem.

Friedrich