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 Member]

It seems like the topic of fixed rows/colums is quite interesting for a lot of BPS-applications.

We finaly came to the following solution:

1. Modifying each web interface by using the freezepanes-method might work, but we wanted a flexible solution giving the user the opportunity to freeze whatever cell he likes.

2. So we decided to modify the template BPS uses to create new business server pages from web interface builder (BSP "SEM_UPWB"). We added two buttons: the first one freezes the cell the user selected, the second one removes the freeze.

3. Now whenever a new BSP is generated, the two buttons are added automaticaly.

Here's the code we used for the modification:

<img onclick="javascript:layout_sheet.ActiveWindow.FreezePanes = true"

title="Zeilen/Spalten fixieren"

class="bpsBtnIcn"

src="../PUBLIC/BC/Icons/s_brdins.gif">

<img onclick="javascript:layout_sheet.ActiveWindow.FreezePanes = false"

title="Fixierung aufheben"

class="bpsBtnIcn"

src="../PUBLIC/BC/Icons/s_brdout.gif">

<!-- Ende Modifikation -->

Just insert the code into the Object "Layout2.htm" of BSP "SEM_UPWB" after line 492 ("...src="../PUBLIC/BC/Icons/s_f_ehlp.gif"><%endif. %>") and activate the BSP.

If you have problems adding the modification, contact me. I can also supply a short word document (only in german) describing the steps.

Regards

Thorsten

[Former Member]

Hello Thorsten,

simply GREAT

That was exactlky what I was looking for.

The next step would be have the possibility to de/activate the functionality.. .just in case some user

Great job.

Best regards

Yannick