If you have navigational bars on top or to the left in your web site, you cannot use ‘Insert-file’ into an existing web page. If you do FrontPage will create a non-working web page!
Instead you must use the following method to add the page:
Now, your page should appear like the other pages in your web site and the navigation structure should include the new page.
The look-and-feel of the web page generated by SpreadsheetConverter is defined by a number of style sheets in the header of the HTML-file. By changing the style sheet values the page layout will change.
You can also open up the page in FrontPage or Dreamweaver and change the layout and look-and-feel. All calculations will continue to work as normal.
Lists created using Data-Validation-List in Excel will automatically be presented as dropdown-lists.
All input cells that contain TRUE/FALSE (or any localized version of it like WAHR in Germany), will automatically be presented as checkboxes.
Either create a dropdown list in Excel using Data-Validation-List, or put a formula like =IF(AND(A1>0;A1<11;A1=INT(A1)),””,”Enter value between 1 and 10″) in the cell next to the input cell. Format the text red, so that it will stand out.
You will get tabs if you choose to show more than one worksheet.
The width of the tables created by SpreadsheetConverter are only approximate. Browsers will do some reformatting when it shows the page.
If you ever need to insert a spreadsheet on an existing page in your web, just follow the steps below.
The generated web page will look like your Excel sheet with colors, borders, sizes etc. This is a standard web page, so you can open it and change the layout, color etc using a tool like Dreamweaver.
SpreadsheetConverter will automatically hide lookup tables, so you can place them on the same sheet.
Set focus needs the name of field where focus should be changed. If you name the cell in excel to ‘mystart’, you can use that name there.
The <body part has a onload-attribute where setFocus is called. You can change that to another field.
So instead of
Add the following code to your page
<form><input type=”button” onClick=”parent.location=’page.html'” /></form>
Just change out the “page.html” with the URL of the page you want to click and go to. This faq is only relevant for SpreadsheetConverter v4 or earlier. Version 5 lets you show Excel’s hyperlinks as buttons.
The problem is that you have white invisible columns to the right, and this together with “shrink-to-fit” when printing, gives this result.
Open the worksheet, press Ctrl-End and see in which column you end up.
Assuming you end up in column Z, but you only want the user to see column A to H, select column H to Z and hide these.