Template for Excel Layout

[former_member184166]

Hi, i download SAP Estandar template using program :

<b>UPP_GET_MASTER_COPY</b>

Edit Styles the XLS file and Upload server Again using program :

<b>UPP_LAYOUT_CHECKIN</b>

In BPS0 my Layout have Custum Styles, But when look WEB Folder, Layout using OWC and not get changes.

Any idea ?

[Former Member]

The OWC interface does not support all formatting options you have in excel. I remember I could not freeze columns with OWC.

However, with simple formulas, fonts, etc...I don't remember experiencing problems.

Maybe you could try to create the web interface once your excel template in BPS0 is completed.

Regeneration of Web Interfaces are sometimes tricky.

Cheers,

Alberto Sabate

[former_member184166]

I try create Folder again and get changes good.

When export to Web Folder changes not display.

I Look Note : 782230

But Support Package is ok.

Note 632333 Say :

List of the features the Excel OWC can use from the template:

Text format - font, size, colour

Cell format - background colour, border, alignment

Number format

"Simple" formulas

Panes Split and Freeze (only for Office versions 2002(XP) or higher)

Nevertheless this applies only for cells which are not filled by BPS runtime. All texts and values written by BPS runtime into the template use standard styles. The styles cannot be changed, see below.

List of features that are not available in the Excel OWC:

<b>Styles. Consequently no changes to the SAP standard styles are taken over to the OWC. </b>Therefore the features mentioned above are available only for the cells not containing a transaction specific data

VB Macros. When needed, the designer can use a script language (VBScript, JavaScript) to access the DOM of the OWC. You can include HTML into a text component in the Web Interface customizing (tn BPS_WB) and place your script code there.

Cell and text formats not mentioned above (e.g. text orientation,...)

Line brakes within a cell

Panes Split and Freeze (only for Office version 2000)

Embeded elements (like form objects, pictures, background picture,...)

Having more than one worksheet in the Excel OWC

In comparison to HTML based planning layouts the Excel layouts do not identify the position of the documents.

-

---

GameOver.

<b>Consequently no changes to the SAP standard styles are taken over to the OWC</b>