Save as HTML - Page setup information missing

[hhol]

Hello,
We have an ERP application ( SAP) that creates an Excel spread sheet
with HTML tags ( Office HTML). These tags are similar to the ones that
excel creates when you save spread sheet as HTML.
The spreadhseet has header, footer and page setup info like
margins,orientation etc which is passed to it using the @page tag in
the HTML page.
Now, in windows everything works fine. I can view the spreadsheet and
all the page setup info. However, Mac does not recognize the page setup
information. We are running Office 2004 for MAC ver 11.2.2 on the MAC.
I tried creating a spreadsheet in mac and saving it as html, it does
not save the page setup information.

Any ideas in this regard will be higly appreciated.

Thanks,

Hiri

 

[Jim Gordon MVP]

Hi,

Does the file have an xml extension instead of xls?

In Excel 2004 use File > Save As then choose the file type XML Spreadsheet
instead of Excel workbook.

-Jim Gordon
Mac MVP

Hello,
We have an ERP application ( SAP) that creates an Excel spread sheet
with HTML tags ( Office HTML). These tags are similar to the ones that
excel creates when you save spread sheet as HTML.
The spreadhseet has header, footer and page setup info like
margins,orientation etc which is passed to it using the @page tag in
the HTML page.
Now, in windows everything works fine. I can view the spreadsheet and
all the page setup info. However, Mac does not recognize the page setup
information. We are running Office 2004 for MAC ver 11.2.2 on the MAC.
I tried creating a spreadsheet in mac and saving it as html, it does
not save the page setup information.

Any ideas in this regard will be higly appreciated.

Thanks,

Hiri

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[hhol]

Hi Jim,
The File has XLS extension. Saviing file as XML spreadsheet creates an
XML file, which is really not what we want. We want to use HTML to
create the spreadsheet i.e when you save the spreadsheet as HTML, it
produces HTML page with XML tags for Page and print setup. The problem
is, in MAC, Excel does not pass this page setup information to HTML. I
am not sure if it is an Excel issue or Mac issue.

Thanks

 

[Jim Gordon MVP]

Hi,

I made an Excel worksheet with a header and footer.

When saved as a web page from Excel 2004 the header information is not
retained.

When saved as a web page from Excel 2007 the header information is retained.

You can send feedback to Microsoft using the Excel Help menu. I'd recommend
that you request that the save as web page feature support headers and
footers in the next version so that they are aware that customers want this
compatibility.

-Jim Gordon
Mac MVP

Hi Jim,
The File has XLS extension. Saviing file as XML spreadsheet creates an
XML file, which is really not what we want. We want to use HTML to
create the spreadsheet i.e when you save the spreadsheet as HTML, it
produces HTML page with XML tags for Page and print setup. The problem
is, in MAC, Excel does not pass this page setup information to HTML. I
am not sure if it is an Excel issue or Mac issue.

Thanks

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Hilena Hailu [MSFT]]

Thank you for your post. We will keep this feature request on our radar for
future releases.

Regards,
Hilena Hailu
Macintosh Business Unit
Microsoft Corp.

--------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi,

I made an Excel worksheet with a header and footer.

When saved as a web page from Excel 2004 the header information is not
retained.

When saved as a web page from Excel 2007 the header information is
retained.

You can send feedback to Microsoft using the Excel Help menu. I'd
recommend
that you request that the save as web page feature support headers and
footers in the next version so that they are aware that customers want
this
compatibility.

-Jim Gordon
Mac MVP

Hi Jim,
The File has XLS extension. Saviing file as XML spreadsheet creates an
XML file, which is really not what we want. We want to use HTML to
create the spreadsheet i.e when you save the spreadsheet as HTML, it
produces HTML page with XML tags for Page and print setup. The problem
is, in MAC, Excel does not pass this page setup information to HTML. I
am not sure if it is an Excel issue or Mac issue.

Thanks

Hi,

Does the file have an xml extension instead of xls?

In Excel 2004 use File > Save As then choose the file type XML
Spreadsheet
instead of Excel workbook.

-Jim Gordon
Mac MVP

Quoting from "hhol" <[email protected]>, in article
(e-mail address removed), on [DATE:

Hello,
We have an ERP application ( SAP) that creates an Excel spread sheet
with HTML tags ( Office HTML). These tags are similar to the ones that
excel creates when you save spread sheet as HTML.
The spreadhseet has header, footer and page setup info like
margins,orientation etc which is passed to it using the @page tag in
the HTML page.
Now, in windows everything works fine. I can view the spreadsheet and
all the page setup info. However, Mac does not recognize the page setup
information. We are running Office 2004 for MAC ver 11.2.2 on the MAC.
I tried creating a spreadsheet in mac and saving it as html, it does
not save the page setup information.

Any ideas in this regard will be higly appreciated.

Thanks,

Hiri


--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info