Our goal is that if no errors or warnings are displayed during the conversion, the resulting web page should give the same result as Excel.
If there are differences between Excel and SpreadsheetConverter, this is a bug. Please report the bug by email to firstname.lastname@example.org In general calculated results should be precisely identical to Excel up to the first 8 significant digits. Also, formatting of input numbers is handled differently. In Excel, if you enter 1.234567 and only want to show 2 decimals, you will see 1.23 but all calculations will use 1.234567. In SpreadsheetConverter, all calculations will use 1.23
Yes, all error values will be seen as the single value NaN (Not-a-Number). All error values are mapped to the same value, so you cannot distinguish between #VALUE and #N/A for example.
Since not all users of web pages are used to using Excel, they may not be used to Excel’s error values. Therefore, it is better to make sure that the error values are not shown to the user in order to avoid confusion.
SpreadsheetConverter sometimes has problem when mixing text and numbers in the same cell, for example a formula like
Replace formulas like this with
Also, make sure that lookup tables contain values everywhere. Do not include the header in the range. Avoid mixing TEXT and NUMBERS.
SpreadsheetConverter automatically HIDES but does not delete rows below 1000. If you have lookup tables below row 1000, these will be part of the web page but invisible.
The reason is that no one wants a web page with 1000 rows. It takes too long time to download and show in the browser.
Workaround: Split the table between different worksheets or even better between workbooks.
It is a rounding problem.
D23 contains 218.46 but D24 contains 218.45999999999998
Press the recalculate button. Automatic recalculation is turned off when the spreadsheet is too big.
In Excel you can have a formula and then let the user overwrite it, but that is not supported by SpreadsheetConverter, since formulas can never be changed.
Workaround: You can implement calculated default values using 4 cells like this
B2: <formula for calculting default>
If the checkbox is unset, the users defined value will be used, otherwise the calculated.
I wish to build my own online calculator and publish it as a web page. Can I do this with SpreadsheetConverter?
Yes, almost any advanced online calculator you can create with Excel is possible to convert to a web page. The formatting and design you apply in Excel is carried over to the web page.