Fixed Rows/Columns in Web Interfaces

[#1]

We are implementing web based BPS-applications for different customers integrating the BPS interfaces into SAP Enterprise Portal. One of the main problems when using web interfaces is that you're not able to fix leading colums/rows in a way that the user only scrolls through the data cells of a layout.

Does anyone know of a way to fix leading colums or rows in BPS-Web Interfaces (either using pure HTML or Excel web component)?

HTML: When using Web Interfaces I would suggest that you have to work with frames. Has anyone done this and can provide a code example?

Excel OWC: Excel-based layouts work well with fixed rows/colums in SAP GUI. But as far as I know the Excel web component doesn't support this feature.

Thorsten

[former_member93896]

Hello Thorsten,

HTML layouts do not provide this functionality. The best you can do is use styles to format them so they fit on screen.

Excel layout however can be set to fixed columns/rows. Make the change to the layout in BPS0. On the third screen of the layout builder, select "publish to web" (button above the layout).

Regards

Marc

SAP NetWeaver RIG

[Former Member]

Hello Marc,

we have the same problem. Either the layout Key columns are to numerous or to big or the physical screen of the planners computer is too small.

I mean It should be possible using javascript and the OWC to fix the layout! Is there any built in javascript/or not to fix the column view?

Best regards

Yannick

[Former Member]

Hi,

Please check out the below link:

http://web.tampabay.rr.com/bmerkey/examples/locked-column-csv.html

This could help you to identify the HTML changes needed, to ge the scrolling. If it worked let me know. I am yet to use this one.

HTH,

Regards,

Nataraj.

[Former Member]

Hello Nataraj,

can you please send the .csv file to this email-address:

[email protected]

I have some trouble with the firewall

Best regards

Yannick

[Former Member]

Hi,

Sent the files to you. If it worked let me know, I am in the process of finalizing this approach.

regards,

Nataraj.

[former_member93896]

Hello everyone,

here's an update on the topic. The SAP NetWeaver RIG is working on a how-to paper to address the issue. We are currently testing and will publish the paper shortly. I will make an announcement in this group.

Regards

Marc

SAP NetWeaver RIG

[Former Member]

Dear Marc / Dear All,

Any improvement or updation on this requirement , as we require the same options now as we are not able to freeze the header as we do it in excel. This is creating lot of problem for the planners (BPS-Web)to identify the row/column they are into to do manual planning.

Regards

Jerry

Edited by: jerry raj on Dec 19, 2011 9:24 AM