Calculation
Does SpreadsheetConverter always calculate the correct result?
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 support@spreadsheetconverter.com 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
Does SpreadsheetConverter handle the error values #N/A #ERROR #VALUE?
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.
I get NaN instead of my values.
SpreadsheetConverter sometimes has problem when mixing text and numbers in the same cell, for example a formula like
=if(A1>0,A1,"")
Replace formulas like this with
=if(A1>0,A1,0)
or
=if(A1>0,A1,#N/A)
Also, make sure that lookup tables contain values everywhere. Do not include the header in the range. Avoid mixing TEXT and NUMBERS.
SpreadsheetConverter only converts the first 1000 rows to html format - what is wrong?
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. I takes too long time to download and show in the browser.
Workaround: Split the table between different worksheets or even better between workbooks.
218.46 isn't equal to 218.46.
It is a rounding problem.
D23 contains 218.46 but D24 contains 218.45999999999998
Instead of
=IF(D23<>D24,"ERROR","OK")
do
=IF(abs(D23-D24)>0.001,"ERROR","OK")
When I open the web page, where there should be calculations, all I get is a bunch of zeros.
Press the recalculate button. Automatic recalculation is turned off when the spreadsheet is too big.
How can I make calculated default values?
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
B1: FALSE
B2: <formula for calculting default>
B3: 0
B4: =IF(B1,B2,B3)
If the checkbox is unset, the users defined value will be used, otherwise the calculated.
Test here: http://www.spreadsheetconverter.com/samples/simple-default-v alue/simple-default-value.htm
and spreadsheet here: http://www.spreadsheetconverter.com/samples/simple-default-v alue/simple-default-value.xls
