If you develop for mobile devices, the new Instant Testing feature lets you quickly test each new version from any device on the same network just by scanning a barcode.

The Instant Testing feature offers two time-saving services to developers:

  • The converted web page can be directly accessed from other devices on the same network, without uploading 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

The new 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.

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. After that, you can simply refresh the browser window to reload the most recent version from the development environment.

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 from your cell phone, tablet or another laptop, and instead get time-out error messages saying

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

These problems are usually caused by the Windows Firewall in the development PC, which is blocking attempts to connect to the built-in web server node.exe. In this case you may need to adjust the Windows Firewall in the development workstation.

The built-in server automatically finds a free incoming port, so the port number may change. You must open the firewall 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.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.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.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.