Fixed Rows/Columns in Web Interfaces

[Former Member]

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

[olaf_fischer]

Dear all,

as Mark mentioned I am working an a How to Paper for freezing pane (header and lead) which offers an almost footprintless solution - just include a style sheet section and one javascript section, that's all - no exit class etc.

What to to?

1. Insert a text component at the very beginning of the page and an other one at the very end (attribute html = true)

2. Insert the content of file freezeLayoutStyles.txt into the first text component.

3. Insert the content of file freezeLayoutScript.txt into the second text component.

That should be really all !!!

Prerequisites:

- Internet Explorer

- New Design as of Release BW3.5 (using the SAPBEx styles)

- The front end PC should not be too old

- The text files are located at (for the next 100days):

http://sapmats-de.sap-ag.de/download/download.cgi?id=KYWV2IXL9UWABTEI55GIPOF0ASQK7Z2FKBWN4URC5098ZU1...

Have fun ...

Best Regards, Olaf Fischer

[Former Member]

Hello,

Does anybody has the How to paper about Fixed Rows/Columns in Web interfaces?

I found one link (By Olaf Fischer) that was expired.

Thanks a lot!

Bueno

[Former Member]

Hi

I have zip file for the code which I can send it to your mail ID if you want but this solution is causing lot of performance issues and I am struggling with improving the performance with JavaScript person but no results. If performance is not improved this solution can not be used. I don't mean to hurt any body who has developed this but it would be great if we find any solution that works just like excel freeze panes on HTML layout. Because of issues with freeze panes we are not able to use HTML fret end which is very good looking.

I hope SAP fixes freeze panes, export to excel and sorting issues on the HTML layouts otherwise the functionality is there and it just can not be used for these small reasons.

Thanks,

Raj.

[Former Member]

Raj could you please send me on this email:

[email protected]

This kind of function, every customer wants.

Thanks for your advice about performance too,

Regards,

Bueno

[Former Member]

sent it.

Thanks,

Raj.

[Former Member]

Hi,

The sapmat link has expired.

Could anyone repost the file to sapmats ?

Or send it to [email protected] ?

I haven't seen any published white paper yet.

Thanks very much in advance.

Olivier

[Former Member]

Hi Olaf,

Could you please send me the active link of your solution for fixing rows/columns.

Thanks!

Regards

Jocelyn