Version 3.1 of SpreadsheetConverter for HTML has been released
You can download the new version here.
Create better looking web pages
Now, you can create web pages with radio buttons, also called option buttons.
Currencies are shown when presenting calculated values. Currencies are not shown in input cells.
Easier to create web pages with different colored input cells. Previously, unless SpreadsheetConverter's automatic detection did a perfect job, you had to set the background color of each input cells to a unique color. This method still works, but you can also use the locked flag to define the input cells. By default, Excel makes all cells locked. Unlock those where you want the user to enter data.
Warn if spreadsheet contains a lot of blank lines below the active area or to the right. It is important to delete or hide these. It will make the conversion faster and in some cases reduce the size of the web page.
Productivity
If you want 2 out of 6 sheets to be shown on the web page, select these two and start conversion.
Creating radio buttons, drop-down menus isn't that easy in Excel. We have added 3 wizards to help you create these faster.
Quicker testing. The generated web page is shown faster by reusing an old window that showed the same page. Tip: The internet explorer window will always be the second window from top. Press Alt-Tab go show it.
If you have installed service pack 2 for Windows XP, you will get a warning message when testing the web pages locally. This message will never be shown when you publish the web pages on a web server. 3.1 includes a fix to remove this warning message during testing.
Functions and forms
TEXT, FIXED, and DOLLAR are supported.
CORREL, COVAR, RSQ, PEARSON are supported by 3.1.6 and later.
Input cells can be set from the url, for example http://www.spreadsheetconverter.com/set.htm?email=support@spreadsheetconverter.com&version=3.1.1 will set the input cells called email and version. Only text fields can be set, not checkboxes, list boxes, dropdown lists and radio buttons. Do not forget to encode uuencode the values if they contain characters like space, &, ?, =, ...
Submit
We have started rolling out our Advanced Submit Service for handling submits and routing the emails. You can use the first step, where the email contains the whole web page as it looked when the user pressed submit.
Other
Better support of non-English characters in file names. There are still problems with localizing the text for the toolbar buttons Workaround: Use named chars, for example 'Återställ' for Swedish Reset-button.
Optimize the stylesheet and make it smaller.
Simpler to check if a newer version of SpreadsheetConverter has been released.
A lot of bugs have been solved. If you detect any problems, please report them. We will fix them as soon.
Should you convert old pages again?
There is no point in converting old web pages again unless you have input cells formatted as h:mm or if you want currency signs on your output cells.
Also, in order to use the new submit option where you get an email that looks like the webpage, you need to convert the webpage again.
How can you upgrade to version 3.1?
If you bought a license for SpreadsheetConverter for HTML version 3, you can download the new version and install it right over your existing installation.
If you bought version 2 after 1st of December 2003, the upgrade to version 3 is for free. We sent out license keys for version 3 in the beginning of the summer. If you didn't get it, please contact us. If you purchased version 2 earlier, you can upgrade. Please contact sales for more information. The cost is $50.
