The Excel ribbon menu

The Excel menu contains a separate ribbon for SpreadsheetConverter. This is the online help page for that ribbon menu. 

After you have installed SpreadsheetConverter, a new ribbon or menu appears in Excel.

ssc6-ssc-ribbon-tab-410-90

Conversion menu

Use the Conversion menu to select what flavor to use for the conversion, i.e. what format to use for the converted web page.

We offer you a free 30-day test of SpreadsheetConverter with access to all flavors in a limited, “demo” mode.  After the free trial period has ended, unlicensed flavors will no longer appear in the list. If you need a particular flavor, ensure you have a license key for it and that you have activated this license key under Product Activation in the Help menu. There is an online Help page for license registration.

Note that changing the flavor may affect other settings, e.g. for layout and formatting, and some widgets are only relevant in certain flavors.

After you’ve selected the right flavor, press Convert to convert the current spreadsheet to a live, calculating web page. There is a tutorial to guide you through your first conversion. 

convert

Sharing menu

The Sharing menu helps you publish the converted web page on various external servers. You must convert your spreadsheet before you share the converted web page.

The choices available are dependent on what flavors you use, so you may not see all the below in your particular setup:

  • Select Dropbox Share to upload the converted web page for testing in a Dropbox account. Unfortunately, Dropbox has discontinued the ability to host web content.
  • If you have a license for the Node.js flavor, the Quicknode Share service will upload your web page for testing on one of our Node.js servers. There is no charge but the web page is automatically deleted after seven days.

Preferences menu

The Preferences section of the ribbon contains various options and settings:

Browsers and Conversion Path Option

  • Click on the button to the right under Choose folder to store webpage and navigate to where you want SpreadsheetConverter to store the web pages it creates. Each converted calculator or form will be enclosed in its own subfolder.
  • Select what browsers you wish to verify the result of each conversion in – click once to activate a browser, click once again to deactivate. Your converted web pages will open in all selected browsers directly after conversion.

ssc6-browsers-and-conversion-path-option-350-211

ASP.NET Settings

For the ASP.NET flavor, the converted web page must be copied to the location on the server where the Site is located. If this drive is available when you do the conversions, you can select the right location directly in the Choose folder to store webpage setting above.

The Choose url setting should be set to match the address of the Site in IIS. For example, if the Site in IIS is configured to listen to port 8080 and the Site name is ‘ssc’ then the correct URL is http://localhost:8080/ssc.

Use the Choose File Format setting to specify whether you want the converted web page to be generated for ASP.Net or Classic ASP.

Screenshot of the ASP.Net settings

Customize Texts

You can translate SpreadsheetConverter to other languages or change the texts it uses with the Customize Texts setting. Select the group in the left-hand pane and edit the texts in the group in the right-hand pane. The new texts will be used for all subsequent conversions, but will not affect already converted web pages.

Screenshot of the Customize Texts setting

Advanced settings

The Advanced Settings control the internal operation of the converter.

  • If you provide data for lookup operations or dropdown menus in spreadsheet cells, we will automatically hide these cell areas if you tick the Hide lookup range checkbox.
  • Uncheck the Fixed chart Y-Axis setting to automatically adapt the min and max values of the Y axis in charts to the values.
  • The Combine JavaScript and CSS files setting makes the converted web page smaller and faster to download.
  • If you use Google Analytics to track your website visitors, please supply your Google Analytics Tracking ID to obtain visitor tracking also for the web pages generated by SpreadsheetConverter. Read more about visitor and conversion tracking.
  • When the user changes anything on the web page, all other cells are normally recalculated automatically, just like with Excel. For very large spreadsheets, we turn automatic recalculation off to make the web page more responsive – just press the Update button to recalculate the sheet. You can enforce automatic or manual recalculation with the Recalculation Method setting.
  • Use the Chart Setting if you explicitly require the charts in your web pages to be generated with the old Adobe Flash plug-in. Many mobile devices don’t support Flash, which is why we switched to generating the charts with HTML5.
  • If you’ve  changed things and want to return to the factory defaults, just press the Reset User Setting button.
  • The Enable debug mode conversion setting is mostly used by our developers to obtain more information about a conversion error.

Screenshot of the Advanced settings

Check for update

Before you report any technical problems to us, please ensure that you are using the latest version of SpreadsheetConverter. Otherwise you may be reporting a problem that has already been fixed. The Check for update menu selection will automatically verify the version you have installed, and help you apply any updates.

Purchase full license keys

Follow this link to the license web shop where you can buy the licenses you need to activate the full power of the product.

Show Notification Center in Taskpane

The Notification Center helps us communicate new features to you without the use of e-mails, blogs or newsletters. Read more about the Notification Center and how to use it.

Help menu

Use the Help menu to research any problems you might have.

  • Use Contact Support to open a new support ticket at our Help desk.
  • Follow the Home Page link to visit our website and extensive Online Help.
  • Take the Tour, a collection of images and descriptive text that helps you get started.
  • Use the Product Activation page to register license keys. For upgrades, you may need to register old license keys as well.
  • Open the About box with the currently installed version number which is useful when you contact the Help desk.

History menu

The History List contains your most recently converted spreadsheets.

Screenshot of the History List menu in the Excel ribbon

The most recently converted web page is at the top of the History list. To the left of the file name is an icon that tells you what flavor was used to create it, i.e. its output format. Using the buttons below the file name, you can open the web page in any of your web browsers, or in the Windows Explorer.

Screenshot of the History list of converted web pages

There is a video tutorial for the History List.

Taskpane menu

The SpreadsheetConverter task pane is pretty wide and can occupy a significant portion of the screen. The Taskpane menu allows you to Show the task pane when you need it and Hide it when it’s no longer needed.

To change the width of the task pane, drag the horizontal separator left/right to match your requirements.

To show/hide the task pane, you can also click on the dotted symbol on the horizontal separator.

Screenshot of the dotted symbol on the horizontal separator between the spreadsheet and the task pane