How to eliminate Overview and other words at top

dr4sight · Post by **dr4sight** » Tue Jan 16, 2018 3:16 pm

Hi,
Recently started using Calc to maintain rosters for a baseball league. I wrote a simple macro to move from the ods file to an html file.
Problem is that it inserts the word "Overview" in bold black above the table and small links "main" on one line, "instructions" on the next (those are the names of the two sheets).
Then on the far left it says Sheet 1: Main

I don't want any of that stuff to be visible just the table.

How can I accomplish this?

thanks

Lupp · Post by **Lupp** » Tue Jan 16, 2018 4:18 pm

How should I know? Would you mind to post your code? An attached example file showing the issue for you is heavily missing.

A simple recorded sub for the purpose didn't show any suspect behaviour.
One hunch: Does your "macro" print to a virtual html-printer (if something of the kind exists at all)?

dr4sight · Post by **dr4sight** » Tue Jan 16, 2018 9:55 pm

Please excuse my not using accepted protocol. That was my first post in this forum.
The rosters page I am working on is here: http://capitalbaseballleague.com/web-rosters.htm
The source that covers the text that I do not want to be shown is here:

Code: Select all

<HTML>
<HEAD>
	
	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
	<TITLE></TITLE>
	<META NAME="GENERATOR" CONTENT="OpenOffice 4.1.3  (Win32)">
	<META NAME="AUTHOR" CONTENT="Laurence Smith">
	<META NAME="CREATED" CONTENT="20180106;9390767">
	<META NAME="CHANGEDBY" CONTENT="Laurence Smith">
	<META NAME="CHANGED" CONTENT="20180116;8085208">
	
	<STYLE>
		<!-- 
		BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small }
		 -->
	</STYLE>
	
</HEAD>

<BODY TEXT="#000000">
<HR>
	<P><CENTER>
		<H1>Overview</H1>
		<A HREF="#table0">Main</A><BR>
		<A HREF="#table1">instructions</A><BR>
		
	</CENTER></P>
<HR>
<A NAME="table0"><H1>Sheet 1: <EM>Main</EM></H1></A>
<TABLE FRAME=VOID CELLSPACING=0 COLS=13 RULES=NONE BORDER=0>
	<COLGROUP><COL WIDTH=118><COL WIDTH=32><COL WIDTH=213><COL WIDTH=32><COL WIDTH=213><COL WIDTH=32><COL WIDTH=213><COL WIDTH=32><COL WIDTH=213><COL WIDTH=32><COL WIDTH=213><COL WIDTH=32><COL WIDTH=124></COLGROUP>

Post by **RoryOF** » Tue Jan 16, 2018 10:05 pm

I think we need to have hands-on of the Calc file that generates this html code.

I was able to edit the html code to remove the unwanted items, but we really need to see how they get there in the first place.

Lupp · Post by **Lupp** » Tue Jan 16, 2018 10:32 pm

You see, I suppose "Overview" (+ .pds) is the file name, in terms of header fields the 'Title', and "Main" is the name of the first sheet.
If these fields are set as left and middle part of the page format under 'Header' they would be be printed in the places you described.
However, neither export to xhtml nor saving as html would put the items in that place.

Therefore please answer my question what means you used to create the html file. I suppose a virtual print using a html printer-driver.

And, of course, do as RoryOF reminded, and attach the file.

dr4sight · Post by **dr4sight** » Tue Jan 16, 2018 11:27 pm

Attached is the ods file I have been using.

First manually and then using a macro I have highlited the A thru M columns.
Then I use the "save as" html option to have the file saved as web-rosters.htm

The problem is that the wording Overview and the other stuff printed above the actual table is what I do not want to have there.

How to eliminate Overview and other words at top

How to eliminate Overview and other words at top

Re: how to elminate Overview and other words at top

Re: how to elminate Overview and other words at top

Re: how to elminate Overview and other words at top

Re: how to elminate Overview and other words at top

Re: How to eliminate Overview and other words at top