Instant Testing lets you quickly test each new version directly after conversion. For mobile devices, just scan the barcode to open the web page. 

Instant Testing offers several time-saving services to developers:

  • After you convert a form or calculator to a web page, it opens automatically in one or more of your web browsers.
  • The converted web page can be directly accessed from other devices on the same network, without uploading it to a web server.
  • A link to the just converted web page is provided in the form of a barcode that can be scanned using the camera in a mobile device or laptop to open the web page.

Introduction

Automatic preview in web browser

Using the Browsers and Conversion Path Option you can get a list of all the web browsers installed in your system.

browser and conversion path

Select one or more web browsers by clicking on their icons. After each conversion, the converted web page will open automatically in all the selected browsers.

Screenshot of the browser selection buttons in the settings

Testing in other computers

The Instant Testing web server in the development workstation attempts to provide the converted web page to any computer or other device on the same network. Copy the link and send it to other devices via e-mail or messaging.

The QR code window

SpreadsheetConverter automatically generates a barcode, a so-called Quick Response code, that contains a link to the converted web page in the developer’s workstation.

Special QR code reader apps allow you to scan the barcode with a mobile device to have the web page open automatically in a web browser on a smartphone or tablet. You can also use the barcode to open the web page in another laptop, if it has a camera. Read more in the QR code tutorial.

qr1

If you don’t need the QR code, you can easily disable the QR code window by deselecting the Show on conversion checkbox.

If you later need the QR code for a particular web page in the developer’s environment, just go to the History List and click on the new QR icon to open the QR code window again.

qr2

If you change your mind and would want the QR code window to appear automatically after every conversion, you can select the Show on conversion checkbox in any QR code window to reactivate it.

The ThemePreview toolbar also contains a convenient link to obtain the QR code, e.g. if you want to see how different themes change the appearance of a calculator in a mobile device.

Screenshot of the QR code link in the ThemePreview toolbar

If you are viewing a converted web page from another device, you only need to scan the barcode the first time you open the page. If the web page is already open in your mobile device, just press the Reload button. It is usually a circular arrow (it looks like a “rotate clockwise” symbol) and it is often located near the website address field.

Screenshot of the Reload button in Safari

Ready for production use

When you have finished testing a spreadsheet, you can of course keep using it from the development environment if all users are on the same network as the developer, and the development system is permanently online.

If you want to make a calculator or web form available outside your own local network, you still have to upload the converted web page to a public web server.

Troubleshooting

During the installation of SpreadsheetConverter, we install a tiny web server in the development environment that serves the converted web pages to web browsers in the same PC, or to other devices on the same network.

You may be unable to connect to the development environment. In this case you may get time-out error messages in your web browser saying

  • the page can’t be reached or displayed
  • the server is taking too long to respond
  • the connection has timed out.

You should also check the Errors tab of the task pane for error messages like these from the conversion:

  • Local web server error: The server failed to start.
  • Localhost Error: the page could not preview from localhost.

If you are trying to access the web page in the development workstation from another device, you should double-check that you are indeed connected to the same network as the development workstation. Your device should typically be showing a wifi symbol for the local network – don’t try this with a phone that says it’s connected with 4G or any other “G” because it won’t be able to reach your local devices.

Good: Wifi icon from a cellphone      Bad: 3G icon from a smartphone

Problems connecting to Instant Testing may be caused by the Windows Firewall in the development PC, which is blocking attempts to connect to the built-in web server node-ssc.exe (previously node.exe). Read more in the Firewall issues section below.

Antivirus issues

Another common problem is overly anxious antivirus and Internet security programs that incorrectly identify portions of our product as malware. We frequently see false alarms related to the node-ssc.exe or node.exe programs, in particular from Bitdefender. If you get such messages, you may have to whitelist the program or disable the antivirus program completely while using SpreadsheetConverter.

Read more in the help page for Internet security software.

Firewall issues

In case you need to adjust the Windows Firewall in the development workstation to enable access to the built-in web server, please follow the instructions below.

The built-in server automatically finds a free incoming port, so the port number may change. You must ensure that the firewall is open for all ports that are opened by node.exe, not only the port number it is currently using.

The instruction on how to change these settings in the Windows Firewall are below. Please follow the instructions relevant to the version of Windows that is used in the development environment.

Windows 8 and Windows 10

These instructions apply to the development workstation, e.g. the PC where you have installed SpreadsheetConverter, if it’s running Windows 8 or Windows 10.

  1. Open the Windows Firewall control panel.
  2. In the left pane, click Allow an app or feature through Windows Firewall.Screenshot of the WIndows Firewall Control panel in Windows 8 and 10
  3. Click Change settings at #1 on the screenshot below. If you’re prompted for an administrator password or confirmation, type the password or provide confirmation.Screenshot of the Windows Firewall settings in Windows 8 or 10
  4. Select the check box next to the node-ssc.exe or node.exe program at #2 on the screenshot above.
  5. Select the check box for Private at #3 on the screenshot below. Deselect the check box for Public so that the web server is not accessible for users of insecure public networks.
  6. Click OK.
  7. Close the Windows Firewall control panel.
  8. Move to the cell phone, tablet or laptop that you were using to test the online calculator. Refresh the calculator web page in the web browser – the page that got the time-out error message – and it will probably load correctly now. If it doesn’t, don’t hesitate to contact our Help Desk.

Windows 7

These instructions apply to the development workstation, e.g. the PC where you have installed SpreadsheetConverter, if it’s running Windows 7.

  1.  Open the Windows Firewall control panel.
  2. In the left pane, click Allow a program or feature through Windows Firewall.Screenshot of the WIndows Firewall Control Panel in Windows 7
  3. Click Change settings at #1 on the screenshot below. If you’re prompted for an administrator password or confirmation, type the password or provide confirmation.Screenshot of the WIndows Firewall settings in WIndows 7
  4. Select the check box next to the node-ssc.exe or node.exe program at #2 on the screenshot above.
  5. Select the check box for Home/Work (Private) at #3 on the screenshot below. Deselect the check box for Public so that the web server is not accessible for users of insecure public networks.
  6. Click OK.
  7. Close the Windows Firewall control panel.
  8. Move to the cell phone, tablet or laptop that you were using to test the online calculator. Refresh the calculator web page in the web browser – the page that got the time-out error message – and it will probably load correctly now. If it doesn’t, don’t hesitate to contact our Help Desk.

Windows Vista

These instructions apply to the development workstation, e.g. the PC where you have installed SpreadsheetConverter, if it’s running Windows Vista.

  1. Open the Windows Firewall control panel.
  2. Click Change Settings. If you’re prompted for an administrator password or confirmation, type the password or provide confirmation.Screenshot of the WIndows Firewall Control panel in WIndows Vista
  3. Select the Exceptions tab.Screenshot of the Windows Firewall settings in WIndows Vista
  4. Select the check box next to the node-ssc.exe or node.exe program at #1 on the screenshot below.Screenshots of the Windows Firewall Exceltions tab in Windows Vista
  5. Click on Properties at #2 on the screenshot below.
  6. Click on Change Scope.Screenshot of the Properties window in the WIndows Vista Firewall
  7. Set the scope to My network (subnet) only so that the web server is not accessible for users outside your own network.Screenshot of the Scope settings in the Windows Vista Firewall
  8. Click OK three times to close the Change Scope window, the Edit a Program window and the Windows Firewall Settings.
  9. Close the Windows Firewall control panel.
  10. Move to the cell phone, tablet or laptop that you were using to test the online calculator. Refresh the calculator web page in the web browser – the page that got the time-out error message – and it will probably load correctly now. If it doesn’t, don’t hesitate to contact our Help Desk.